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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics