April 11, 2016 at 2:14 am
Good Day,
I've SSRS report with a drill through report which works fine.
But now I've added a parameter on the main report which must help determines which drill through report must open based on the selected parameter and I'm using an expression on my action drill through but my expression below seems to be incorrect.
=IIF(Parameters!ReportView.Value="ConsultantView",FLOWSGROWTH,FLOWSGROWTH_MANAGEMENT)
Please assist what is wrong with the above expression for the drill though report expression action.
Thanks in advance.
April 11, 2016 at 2:40 am
You should be quoting your return values so your expression returns a string, otherwise SSRS will think you are trying to return objects.
April 11, 2016 at 4:17 am
I'm reading something about the report path , can someone provide an example for the report path to use for SSRS Native browser. I need this for my expression so I can highly appreciate if the report path could be in an example of an expression for native drive through report
April 11, 2016 at 4:18 am
In need to report an object which is a report on this case using the drill through action >> Go to report >> expression option
April 11, 2016 at 4:50 am
You should be returning a string that tells SSRS where the target report is. Also, they will need to take the same parameters (if any) with the same names.
I.e. =IIF(Parameters!ReportView.Value="ConsultantView","FLOWSGROWTH","FLOWSGROWTH_MANAGEMENT")
If the reports are not in the same folder as the report that is calling them you can just use their absolute paths on the report server in your expression.
E.g.
=IIF(Parameters!ReportView.Value="ConsultantView","/FlowReports/FLOWSGROWTH","/ManagementReports/FLOWSGROWTH_MANAGEMENT")
April 11, 2016 at 6:03 am
Thank you very much, This is exactly what I was looking for
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply