You are not logged in.
Hi,
We are trying to accommodate the following use case: our portal users belong to specific organisations, and each of these organisations has a homepage in our portal. On this organisational homepage we have included an embedded dashboard from Report Server. This dashboard contains saiku charts and dynamic list report dagets that should display prefiltered data belonging to that organisation only. For this purpose all the report dagets have a hidden parameter called p_org_id which is implicitly used in the SQL query. Now if we include the dashboard like this:
https://www.######.com/reportserver/ReportServer.html#inlinedashboard/type:single&nr:3&p_org_id:9585153the p_org_id parameter does not seem to be delivered to the reports included in the dashboard. If we embed the report directly then the parameter is passed correctly, but we need to include the dashboard because the dagets offer better integration with our portal (popup for setting parameters, persistent setting of parameters, report parameters daget for simultaneously setting the params of all dashboard items etc.)
Is there any way to achieve this passing through of parameters from the embedded dashboard url to the contained reports?
We are using RS3.0.8-6009 (2019-07-12-15-35-44) Enterprise Edition.
Thanks in advance for your help.
Offline
Hi razvan.bunea,
sorry for the late answer. Do you have a parameter dadget in your dashboard and does your report use this ?
https://reportserver.net/en/guides/user … Dashboard/
Parameter Dadget Allows to set parameters for any report dadget in the current dashboard.
Regards,
Eduardo
Offline
Hi eduardo and thanks for the response.
Some of our dashboards do include a parameter dadget and some don't. The idea is that we need to send a parameter from our portal behind the scene to the iframe containing the embedded ReportServer dashboard, not to let the user select it (so the parameter dadget is not applicable here). That parameter (an organisational id) is used by the reports to restrict the data provided to the user. When embedding the report directly (a dynamic list for example) sending this parameter is very easy through the URL and the report fetches it from there without any problem. But when embedding a dashboard, the parameter sent through the URL does not seem to reach the reports (simple list view or charts) that are included in the dashboard.
Kindest regards,
Razvan.
Offline
Hi Razvan,
we will look into this in ticket RS-4541.
"is used by the reports to restrict the data provided to the user"
-> Have you looked at user variables ? These were developed exactly for this purpose: to restrict the data provided to the user: https://reportserver.net/en/guides/admi … Variables/
In such way, you won't need to pass user-specific parameters to the report.
Regards,
Eduardo
Offline
Hi Eduardo,
Unfortunately I don't see how the user variables could be useful in this case. The "users" in my scenario are the users of our portal and they are not mapped one-to-one to the users of our ReportServer instance. We use a common organisational ReportServer "user" for each group of users from our portal that belong to the same organisation (so we rather map organisations from our portal to users in ReportServer - we do not need per-user report customisation, just per-organisation - hence the need to pass on an org_id to dashboard reports). The portal users do not have access themselves to the ReportServer console, just to the embedded reports, dashboards etc.
All best,
Razvan.
Offline