SQL Server Performance

External Parameters

Discussion in 'SQL Server Reporting Services' started by lidsurfer, Feb 12, 2004.

  1. lidsurfer New Member

    I would like to be able use an external parameter from another application as a reporting paramter in Reporting Services. I.e. a user would click on a report button which takes a parameter and passes it across to Reporting Services to use in a report.

    How would I achieve this?

    CHeers

    Jared
  2. MattiasT New Member

    You can set parameters through the url to the report. The following description is taken from the Reporting Services Books Online:<br /><br /><i>Another way to run a parameterized report is through a URL. You can specify one or more parameters in encoded name-value pairs, using the ampersand character (&) to separate them.<br /><br />Null parameters use special syntax; you must specify isnull for a null value. The following example illustrates multiple parameters for null and constant values:<br /><br /<a target="_blank" href=http://exampleWebServerName/reportserver?/foldercontainingreports/orders&division=mailorder&region=west&sales:isnull>http://exampleWebServerName/reportserver?/foldercontainingreports/orders&division=mailorder&region=west&sales:isnull</a><br /><br />Parameters with multiple values are specified by repeating the parameter name; for example, <br /><br /<a target="_blank" href=http://exampleWebServerName/reportserver?/foldercontainingreports/orders&region=east&region=west>http://exampleWebServerName/reportserver?/foldercontainingreports/orders&region=east&region=west</a> <br /><br /><br />If one of the values is null (that is, isnull), all other values specified for that same parameter are ignored.<br /><br />Boolean parameters are specified with a value of 0 or 1.<br /><br />Float parameters must include the decimal separator of the server locale.<br /><br />DateTime parameters must be specified with the format YYYY-MM-DDTHH:MM<img src='/community/emoticons/emotion-7.gif' alt=':S' />S, which is based on the International Organization for Standardization (ISO) 8601 standard.</i><br /><br />For more info search on Parameterized Reports in Books Online.<br /><br />/Mattias<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by lidsurfer</i><br /><br />I would like to be able use an external parameter from another application as a reporting paramter in Reporting Services. I.e. a user would click on a report button which takes a parameter and passes it across to Reporting Services to use in a report.<br /><br />How would I achieve this?<br /><br />CHeers<br /><br />Jared<br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">

Share This Page