April 26, 2013 at 4:43 am
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
April 28, 2013 at 9:19 am
Any ideas?
April 29, 2013 at 9:06 am
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.
April 29, 2013 at 9:49 am
Please could you elaborate further?
April 29, 2013 at 10:29 am
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply