Passing parameter via url to sql server reporting service

Question

I m trying to pass a parameter via the url to SSRS and it appears not to work   I m trying to pass a userId  string  via the url which will be passed to the database and used by the query   base url  http   blah Reports Pages Report aspx ItemPath MyReport  tried this but it doesn t work  http   blah Reports Pages Report aspx ItemPath MyReport amp UserId fred  Any ideas

User · Accepted Answer

As well as what Shiraz said  try something like this   http    lt server gt  ReportServer Pages ReportViewer aspx  2f lt path gt  2f lt ReportName gt  amp rs Command Render amp UserID  fred    Note the path would only work if you are in a single folder  When I have to do this I simply browse to the report using the reportserver path   reports  is the report manager  and copy the url then add  amp  lt ParameterName gt   lt value gt  to the end

User · Answer

As per this link you may also have to prefix your param with  amp rp if not using proxy syntax

User · Answer

Try passing multiple values via url    ReportServer  2fService Specific Reports 2fFilings 2fDrillDown 2f amp StartDate 01 01 2010 amp EndDate 01 05 2010 amp statuses 1 amp statuses 2 amp rs 3AFormat PDF   This should work

User · Answer

Try changing  Reports  to  ReportServer  in your url  For that just access this http   host ReportServer  and from there you can go to the report pages  There append your parmaters like this  amp  lt parameter gt   lt value gt   For more detailed information   http   dobrzanski net 2008 08 11 reporting-services-problem-with-passing-parameters-directly-in-the-url   https   www mssqltips com sqlservertip 1336 pass-parameters-and-options-with-a-url-in-sql-reporting-services

User · Answer

I had the same question and more  and though this thread is old  it is still a good one  so in summary for SSRS 2008R2 I found     Situations   You want to use a value from a URL to look up data You want to display a parameter from a URL in a report You want to pass a parameter from one report to another report   Actions  If applicable  be sure to replace Reports Pages Report aspx ItemPath  with ReportServer   In other words  Instead of this   http   server Reports Pages Report aspx ItemPath  ReportFolder ReportSubfolder ReportName   Use this syntax   http   server ReportServer  ReportFolder ReportSubfolder ReportName   Add parameter s  to the report and set as hidden  or visible if user action allowed  though keep in mind that while the report parameter will change  the URL will not change based on an updated entry    Attach parameters to URL with  amp ParameterName Value  Parameters can be referenced or displayed in report using  ParameterName  whether they re set in the report or in the URL  To hide the toolbar where parameters are displayed  add  amp rc Toolbar false to the URL  reference   Putting that all together  you can run a URL with embedded values  or call this as an action from one report and read by another report    http   server domain com ReportServer  ReportFolder1 ReportSubfolder1 ReportName amp UserID ABC123 amp rc Toolbar false   In report dataset properties query  SELECT stuff FROM view WHERE User    UserID  In report  set expression value to  UserID   or  Fields UserID Value   Keep in mind that if a report has multiple parameters  you might need to include all parameters in the URL  even if blank  depending on how your dataset query is written   To pass a parameter using Action   Go to URL  set expression to     http   server domain com ReportServer  ReportFolder1 ReportSubfolder1 ReportName amp UserID     amp Fields UserID Value    amp   amp rc Toolbar false    amp   amp rs ClearSession True    Be sure to have a space after an expression if followed by  amp   a line break is isn t enough   No space is required before an expression  This method can pass a parameter but does not hide it as it is visible in the URL   If you don t include  amp rs ClearSession True then the report won t refresh until browser session cache is cleared   To pass a parameter using Action   Go to report    Specify the report Add parameter s  to run the report Add parameter s  you wish to pass  the parameters need to be defined in the destination report  so to my knowledge you can t use URL-specific commands such as rc toolbar using this method   however  I suppose it would be possible to read or set the Prompt User checkbox  as seen in reporting sever parameters  through custom code in the report     For reference       2f

User · Answer

http   desktop-qr277sp Reports01 report Reports reportName Log In Name serverUsername amp paramName value Pass parameter to the report with server authentication

User · Answer

Try changing  Reports  to  ReportServer  in your url

User · Answer

I solved a similar problem by passing the value of the available parameter in the URL instead of the label of the parameter     For instance  I have a report with a parameter named viewName and the predefined Available Values for the parameter are   labels values  orders sub orders  orderDetail sub orderDetail  product sub product     To call this report with a URL to render automatically for parameter product  you must specify the value not the label  This would be wrong   http   server reportserver  Data Dictionary DetailedInfo amp viewName product amp rs Command Render  This is correct  http   server reportserver  Data Dictionary DetailedInfo amp viewName sub product amp rs Command Render

User · Answer

I ve just solved this problem myself  I found the solution on MSDN   http   msdn microsoft com en-us library ms155391 aspx   The format basically is   http    lt server gt  reportserver   lt path gt   lt report gt  amp rs Command Render amp  lt parameter gt   lt value gt

[url] Passing parameter via url to sql server reporting service

Examples related to url

Examples related to reporting-services

Examples related to parameters

Examples related to reporting

Examples related to reportingservices-2005