SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 ssrs 2008 r2 bullet list
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jassie
Constraint Violating Yak Guru

268 Posts

Posted - 10/11/2013 :  21:47:27  Show Profile  Reply with Quote
In a SSRS 2008 r2 current report, I want to be able to add a bullet list of link that the user can click on.
Basically I want the bullet list to look like the following:

+ product a
+ proudct b

after clicking on both links, the user would see the following:

product a
-link to accessories for product a
-link to support for product a
-link for mainteance to product a
product b
-link to accessories for product b
-link to support for product b
-link for maintenance for product b

The links under each product are staiic values. The links would not be obtained by querying the database.
Can you show me how to create the task I listed above using SSRS 2008 r2 reports?

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 10/12/2013 :  04:55:49  Show Profile  Reply with Quote
just add three rows below each product by creating a dummy grouping. then add the three links by using jump to url property. Then set visibility property for links as toggle based on product row

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Edited by - visakh16 on 10/12/2013 04:56:33
Go to Top of Page

jassie
Constraint Violating Yak Guru

268 Posts

Posted - 10/12/2013 :  11:47:14  Show Profile  Reply with Quote
How do you create a 'a dummy grouping'? I thought all groupings have to be based upon some dataset that is connected to the report?

Can you give me directions on how to create a 'dummy grouping? Would you create a dataset that does nothing except for use 'getdate()?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 10/12/2013 :  14:04:25  Show Profile  Reply with Quote
quote:
Originally posted by jassie

How do you create a 'a dummy grouping'? I thought all groupings have to be based upon some dataset that is connected to the report?

Can you give me directions on how to create a 'dummy grouping? Would you create a dataset that does nothing except for use 'getdate()?


Reading again I thing you can put grouping on Product itself. then add three rows inside group and put static link so that it gets repeated for each project.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jassie
Constraint Violating Yak Guru

268 Posts

Posted - 10/12/2013 :  23:57:31  Show Profile  Reply with Quote
Thank you for your answers! I have the following addtional questions:

1. add three rows inside group? Can you tell me about the benefit of using an inside group? What is the purpose of the inside group?
2. Can you tell me how to setup a 'dummy dataset'?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 10/13/2013 :  01:36:19  Show Profile  Reply with Quote
quote:
Originally posted by jassie

Thank you for your answers! I have the following addtional questions:

1. add three rows inside group? Can you tell me about the benefit of using an inside group? What is the purpose of the inside group?
2. Can you tell me how to setup a 'dummy dataset'?


Inside group will ensure whole details gets repeated for each item in the group (in your case for each product)

Dummy group is not required in this case. But if you want to use it you can use a grouping on say

=RowNumber(Nothing)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jassie
Constraint Violating Yak Guru

268 Posts

Posted - 10/13/2013 :  23:20:26  Show Profile  Reply with Quote
Thanks!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000