Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to link Main dashboard to other dashboards via a dropdown list Expand / Collapse
Author
Message
Posted Friday, April 26, 2013 4:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
Hello,

I have created a Main dashboard using SSRS. It consists of a report with graphs etc called Dashboard.rdl

I have created two other dashboards called Helpdesk.rdl and Engineers.rdl but i would like the main dashboard (dashboard.rdl) to be linked to the other ones through a dropdown list (parameters).

I am little unsure how to achieve this. I know how parameters work in SQL.


Ok heres what i've done.

Firstly i attempted to put a text box on the Main dashboard page (dashboard.rdl page). And then i did the following:


I created two parameters on called Helpdesk and Engineers then gave them labels called Helpdesk and Value @Helpdesk and then for the Engineer parameter a label called Engineer and Value:@Engineer.


On the textbox on the report and then in Text Box Properties Under Action: I selected Go to report. I am only able to select One report. I selected: ITHelpdesk.rdl. The report i specified was the one I want in the dropdown: ITHelpdesk.rdl

I then added the parameters: ITHelpdesk and @ITHelpdesk and Engineers and @Engineers


I have gone to run the report (dashboard.rdl) the issues are:


a) Firstly the report appears blank when I initially go to run it. The report should display Dashboard.rdl

b) However what first appears when you click on dashboard.rdl is the dropdown list. If i select ITHelpdesk.rdl then and click view the report displays dashboard.rdl.



So in essence, what I am to achieve is a:

1. The user views dashboard.rdl and then has the option to select a dropdown list to be able to view other reports (dashboards).


Thanks









Post #1446895
Posted Sunday, April 28, 2013 9:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
Any ideas?
Post #1447328
Posted Monday, April 29, 2013 9:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 30, 2014 8:10 AM
Points: 322, Visits: 295
You could use two subreport boxes, one for Engineers and the other for Helpdesk. Then you could set the visibility property of the subreports based on the parameter selected.
Post #1447584
Posted Monday, April 29, 2013 9:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
Please could you elaborate further?
Post #1447616
Posted Monday, April 29, 2013 10:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 30, 2014 8:10 AM
Points: 322, Visits: 295
I've attached screenshots that go along with the directions, naming convention of images follows steps.
1) Your two subreport RDLs need to be in the same project.
2) Right click in the report body and insert a Subreport.
3) After you have inserted the subreport, right click the subreport and click on Subreport properties.
4) From the drop down, select the first subreport you want.
5) Do the same thing for the next subreport and this is what your report body should look like.
6 & 7) Create a parameter and set the available values to have a label of whatever you want the user to select and a value of your SubReport names in the project.
8) Right click the subreport1, select “Subreport Properties…” go to Visibility and click on “Show or hide based on an expression” and create an expression similar to below with your parameter name and subreport names. =IIF(Parameters!SubReportVisible.Value = "SubReport1",TRUE,FALSE)
9) Do the same thing for subreport2 changing the name in the visibility expression.
10) When the user runs the query, they are asked to choose which subreport is visible and that is the only one that shows in your report.

Everything works perfectly using the above method! Keep in mind that the queries for the subreports are run regardless if they are visible or not. If the report is taking a long time to render it may be due to one of the subreports that is running but not visible.


  Post Attachments 
01.png (25 views, 4.45 KB)
02.png (18 views, 25.28 KB)
03.png (11 views, 9.18 KB)
04.png (13 views, 23.22 KB)
05.png (16 views, 4.77 KB)
06.png (20 views, 18.53 KB)
07.png (11 views, 15.43 KB)
08.png (11 views, 27.16 KB)
09.png (10 views, 23.86 KB)
10.png (10 views, 4.68 KB)
Post #1447643
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse