Passing values for multi-value parameter in SSRS query string

Posted by Andy Xufuris on Stack Overflow See other posts from Stack Overflow or by Andy Xufuris
Published on 2010-06-03T16:21:31Z Indexed on 2010/06/03 16:24 UTC
Read the original article Hit count: 238

Filed under:

ssrs-2005

I have two reports built using SSRS 2005. The first report is set to navigate to the second when a specific field is clicked. There is a multi-value parameter on the second report. I need to pass multiple values for this parameter in the URL query string when calling this report. Is there a way to pass multiple values for a parameter in the query string of a report? Or can you pass a parameter that will cause the Select All value to be selected?

Related posts about ssrs-2005

Error in Visual Studio 2008 with SSRS 2005 report projects

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone found a good workaound for opening or editing an SSRS 2005 report project with Visual Studio 2008 yet? Will the SQL server 2008 tools be the migration path for these report projects in the future? I really dont want to have to keep VS2005 installed forever just to update SSRS reports… >>> More
SSRS 2005 tabs/newline characters display in table

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How can i get a column in an SSRS 2005 report to render control chars like new lines and tabs? For example: SELECT VW.System_name + CHAR(13) + CHAR(9) + ' > ' + VW.PTS_NAME + CHAR(13) + CHAR(9) + CHAR(9) + ' > ' + VW.FEED_NAME as Name In SSRS (and SSMS Results to Grid Mode) table… >>> More
SSRS 2005 - Cascading parameters and default value update problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a report with cascading parameters. The first parameter is Finanical Period Type, being either Month or Week. The second parameter is a list of either financial months or weeks depending on what was selected for the first parameter. This all works well and selecting a series of different Financial… >>> More
How do I convert an INT into HH:mm:ss using SSRS 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Ok I need to display total talk time of an agent that is coming into SRSS 2005 from SQL 2005 as an INT. For the life of me I cannot figure out what combination of expression editing or format editing I need to use. For the detail portion I can use: =DATEADD("s", SUM(Fields!Talk_Time.Value), CDate("00:00")) And… >>> More
How to pass Multivalued parameters through URL in SSRS 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I have main matrix report and I want to navigate my sub report from main report by Jump To URL:(Using below JavaScript function) method. ="javascript:void(window.open('http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fKonsolidata_Data_Exporting_Project%2fEXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields… >>> More

Developer IT

Passing values for multi-value parameter in SSRS query string - Developer IT

Passing values for multi-value parameter in SSRS query string

ssrs-2005

Related posts about ssrs-2005

Error in Visual Studio 2008 with SSRS 2005 report projects

SSRS 2005 tabs/newline characters display in table

SSRS 2005 - Cascading parameters and default value update problem

How do I convert an INT into HH:mm:ss using SSRS 2005

How to pass Multivalued parameters through URL in SSRS 2005

Categories cloud