Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-10-11 : 21:47:27
|
| 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 bafter 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 bThe 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
52326 Posts |
Posted - 2013-10-12 : 04:55:49
|
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-10-12 : 11:47:14
|
| 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()? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-12 : 14:04:25
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-10-12 : 23:57:31
|
| 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'? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-13 : 01:36:19
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-10-13 : 23:20:26
|
| Thanks! |
|
|
|
|
|
|
ssrs 2008 r2 bullet list