Tableau URL that is passed to SSRS - not working for multiple values
Hi
I think this is a simple problem - but am unsure.
I have created a link in Tableau to a report in SSRS - which works fine when I pass a single value e.g.
http://reporting.company.co.nz/reportserver?/Faults%20Reports/Display_Specific_Faults&rs:Command=Render&sheet_no=293750
This runs the report in SSRS as expected - All Good.
If I allow Tableau to pass multiple values (I have little control over the creation of the URL) - then Tableau builds the URL below, i.e. comma seperated 293750,294104 (the parameter is multi-value within SSRS) :
http://reporting.company.co.nz/reportserver?/Faults%20Reports/Display_Specific_Faults&rs:Command=Render&sheet_no=293750,294104
Clearly SSRS does not like this format.
I have read many posts about using split etc within SSRS - but am not clear on how I use this.
I can manually get the report to run in SSRS by adding the parameters as in the below URL.
http://reporting.company.co.nz/reportserver?/Faults%20Reports/Display_Specific_Faults&rs:Command=Render&sheet_no=294308&sheet_no=293111
Can anyone explain in basic terms how I can translate the parameters passed in from Tableau e.g (293750,294104) to be in an appropriate format for SSRS to be able to run the report.
Thanks
Andrew
December 3rd, 2012 7:54pm
MAnaged to complete - by uisng a split table function on the parameter - so the values were being read into the dataset as individual values and viola!!
Free Windows Admin Tool Kit Click here and download it now
December 3rd, 2012 11:20pm
Hi Andrew,
To pass multiple values for a parameter within the URL, we can use the following URL instead in the drill-through action:
="http://<Server Name>/reportserver?/Faults Reports/Display_Specific_Faults&rs:Command=Render&sheet_no="&Join(split("293750,
294104",","),"&sheet_no=")
Besides, we can also pass values of a field or a multi-value parameter within the URL. For example,
="http://<Server Name>/reportserver?/Faults Reports/Display_Specific_Faults&rs:Command=Render&sheet_no="&Join(Fields!ID.Value,"&sheet_no=")
Regards,
James
December 4th, 2012 8:53pm