Passing Multi-Value Parameters between reports
Hi I have two Reports PropertySearch and PropertyDetails. In PropertySearch I have 2 parameters PropertyNameSearch (textbox) , City (multi-select from a drop down). It takes some propertyName and Few Cities as input and displays a list of properties matching these two. So the list has a link to PropertyDetails for which I just need PropertyID that passes internally to the PropertyDetails. Everything works perfect. But when I was in second report I want to go back to the first report ( which was displaying results with based on parameters) to choose a different property. So for this I have created the parameters @PropertyNameSearch , @City in my second report and I set it to hidden. Now I'm passing these two values to the second report with actual parameter PropertyID. I have placed a link to first report in the second report that passes the @PropertyNameSearch and @City to first report. I can pass @PropertyNameSearch successfully but my problem is I cannot pass multi-value parameter @City between two reports. Any help or suggestions ? Thanks!SqlUser2011
April 14th, 2011 11:32am

This isn't exactly an answer to your specific question per se. It's just alternate method for getting to the end result. As I'm sure you've noticed, SSRS opens drill through reports in the same browser window as the 1st report, basically kicking the original report out of the way. There is a way, using some java script to force the drill through to open in it's own browser window, leaving the original report "as is". If that's an acceptable solution, check out this link... Displaying Reporting Services drill-through reports in new browser window Jason Long
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 12:08pm

Thanks for your suggestion Jason, But this JavaScript thing never worked for me. If the second report opens in new window that would be awesome, but in Sharepoint 2010, It's not working either.. :( :( Thanks!SqlUser2011
April 14th, 2011 12:11pm

What version of SSRS are you using?Jason Long
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 12:30pm

SQL Server 2008 R2 with Sharepoint 2010SqlUser2011
April 14th, 2011 12:32pm

I've made it work using the SSRS report manager. We don't have Share Point so I can't help on that end. Sorry.Jason Long
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 12:57pm

That's okay, I just got it. I have created a new parameter @CityString and set its default t0 = JOIN (Parameter!City.Value,",") . then I'm passing this string in between. Thanks for your time..SqlUser2011
April 14th, 2011 1:11pm

No problem. Glad you got it working!Jason Long
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 1:16pm

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

Other recent topics Other recent topics