Can't pass multiple parameters using URL syntax when toolbar hidde
in [Reports]
|
Prev: TFS/SQLReportServer error when creating a new project
Next: Trouble passing URL parameters to report in SharePoint
From: piers7 on 22 Jan 2009 00:55 Hey all, I am really struggling to get multi-valued parameters into a report using the URL access syntax. It seems like it only works if you show the toolbar (which I need to hide) eg: I built a dummy report with one parameter, two values for testing: http://auperapd12:2001/ReportServer2/Pages/ReportViewer.aspx?%2f_UrlParameterTesting&rs:Command=Render&Param1=One&Param1=Two works but exactly the same with the suffix (&rc:Toolbar=False&rs:Command=Render): http://auperapd12:2001/ReportServer2/Pages/ReportViewer.aspx?%2f_UrlParameterTesting&rs:Command=Render&Param1=One&Param1=Two&rc:Toolbar=False&rs:Command=Render ....fails with "Default value or value provided for the report parameter 'Param1' is not a valid value. (rsInvalidReportParameter)" Anyone come across this before? SSRS build 9.00.4035.00 [Sql 2005 + SP3]
From: piers7 on 30 Jan 2009 00:34 Anyone from MS got any comment? What happened to the two business days thing? "piers7" wrote: > Hey all, > > I am really struggling to get multi-valued parameters into a report using > the URL access syntax. It seems like it only works if you show the toolbar > (which I need to hide) > > eg: I built a dummy report with one parameter, two values for testing: > > http://auperapd12:2001/ReportServer2/Pages/ReportViewer.aspx?%2f_UrlParameterTesting&rs:Command=Render&Param1=One&Param1=Two > > works but exactly the same with the suffix > (&rc:Toolbar=False&rs:Command=Render): > > http://auperapd12:2001/ReportServer2/Pages/ReportViewer.aspx?%2f_UrlParameterTesting&rs:Command=Render&Param1=One&Param1=Two&rc:Toolbar=False&rs:Command=Render > > ...fails with "Default value or value provided for the report parameter > 'Param1' is not a valid value. (rsInvalidReportParameter)" > > Anyone come across this before? > > SSRS build 9.00.4035.00 [Sql 2005 + SP3]
From: Bruce L-C [MVP] on 30 Jan 2009 09:20
Very few people from Microsoft hang out here. The only time they do is if you are doing a MSDN managed newsgroup. To do that two things have to occur. First you have to have a MSDN subscription. Second, you have to register your newsgroup user. Essentially they monitor the newsgroup only for those posters who have registered at MSDN. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "piers7" <piers7(a)community.nospam> wrote in message news:BF1CCE81-9D90-45C3-94DA-3CD4DD9192FE(a)microsoft.com... > Anyone from MS got any comment? What happened to the two business days > thing? > > "piers7" wrote: > >> Hey all, >> >> I am really struggling to get multi-valued parameters into a report using >> the URL access syntax. It seems like it only works if you show the >> toolbar >> (which I need to hide) >> >> eg: I built a dummy report with one parameter, two values for testing: >> >> http://auperapd12:2001/ReportServer2/Pages/ReportViewer.aspx?%2f_UrlParameterTesting&rs:Command=Render&Param1=One&Param1=Two >> >> works but exactly the same with the suffix >> (&rc:Toolbar=False&rs:Command=Render): >> >> http://auperapd12:2001/ReportServer2/Pages/ReportViewer.aspx?%2f_UrlParameterTesting&rs:Command=Render&Param1=One&Param1=Two&rc:Toolbar=False&rs:Command=Render >> >> ...fails with "Default value or value provided for the report parameter >> 'Param1' is not a valid value. (rsInvalidReportParameter)" >> >> Anyone come across this before? >> >> SSRS build 9.00.4035.00 [Sql 2005 + SP3] |