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 |
|
mcfly1204
Starting Member
10 Posts |
 Posted - 2012-02-10 : 08:54:04
|
| I have a main report that displays order counts for customers, and I would like to display a sub report that displays more information for a specific customer. I do not think that this is possible, but does SSRS 2k5 support row clicks? By this I mean, if a user clicks a row (customer) then a parameter can be passed to a sub report and then the sub report will be displayed. The sub report consists of just a chart, so my other thought is to have a column in the main report that contains the chart, but I only want to display/expand the cell for the row that is clicked, otherwise a chart would be displayed for all customers and the main report would be overwhelmed with charts. Any suggestions would be appreciated. |
|
|
mcfly1204
Starting Member
10 Posts |
Posted - 2012-02-14 : 09:37:55
|
| What I ended up doing was I created an additional column for the main report, and then I placed a sub report in the column. A parameter is passed to the sub report from a value in the main report. I set another column so that I could show/hide the contents of the cell with the sub report. Everything works as I would like, but I am still interested in alternative methods if they exist. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-14 : 10:08:10
|
| you can simply go with two report one summary and other one details. from summary you can set jump to report action on customer field. on click call second report inside jump to report and pass customer details which will be added as a parameter to second report and it displays the relevant customers details.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Sub Report or Expand/Collapse Single Cell