Dashboard Interactive

Question

Dashboard Interactive

destrogiro

Newbie

Points: 5
More actions
February 13, 2015 at 4:06 am

#304212

Hi,
I'm developing a report and it has 3 datasets: 1 for a main report and 2 datasets for the subreports. My manager doesn't want to use ACTION to load one subreport when the user clicks on the main one.
She wants like this:
The report will have all 3 datasets in the same page. When the user clicks on a specific text-box on the main report (month/year) the others 2 reports should have their data updated based on the parameters this main report will pass to them.
Is it possible in SSRS to do this?
Thanks,
Benedito.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

sql Sarah SSCrazy Points: 2081 More actions · Answer 1

destrogiro (2/13/2015)
Hi,
I'm developing a report and it has 3 datasets: 1 for a main report and 2 datasets for the subreports. My manager doesn't want to use ACTION to load one subreport when the user clicks on the main one.
She wants like this:
The report will have all 3 datasets in the same page. When the user clicks on a specific text-box on the main report (month/year) the others 2 reports should have their data updated based on the parameters this main report will pass to them.
Is it possible in SSRS to do this?
Thanks,
Benedito.

All the objects on a report load when you click View report. There isn't a way (that I know of) to update an object after clicking view report. I have been using SSRS for around 8-9 years.

I tried to use bookmarks and other things, but couldn't get a report to do what you wanted.

A suggestion I have is to create the main report with the first data set that lists out all the data. Then use an action to go to the subreport that has all the datasets filtered by what you clicked on the first one.

Dukatum Valued Member Points: 57 More actions · Answer 2

I'm a bit new to it all, but surely you have to use 'action' and just load the report itself with new parameters ?

Seems a bit odd to not use subreports and just update them.

Black_T SSC Veteran Points: 259 More actions · Answer 3

Hi

If you don't use Action to display the subreport, you can directly insert the subreports in tablix (rendered with main report). If you need the subreport updated with the parameter selection, you have to use Go to report Action. You can only achieve either one.