Reading value from url to SSRS report parameter

• sally-349728

  SSC Veteran

  Points: 249

  More actions

  May 6, 2010 at 2:04 pm

  #218649

  How can I read value passed in url ( querystring value) and store it in the SSRS paramaeter ?

  example url : http://servername/reportingportal?reportid=23

  I have a dataset with parameter @reportID

  I want to dynamically read reportid value from url and into the SSRS parameter @reportID

  Thanks

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  May 6, 2010 at 10:35 pm

  #1163776

  Hi Sally,

  Can you please describe your requirement in breif.

  Raunak J

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  May 10, 2010 at 12:37 pm

  #1165179

  Have a look at the following link. I think it should get you moving int he right direcction, but in short you just need to append &Parametername=value to the end of your URL.

  http://www.mssqltips.com/tip.asp?tip=1336

  To help us help you read this[/url]For better help with performance problems please read this[/url]