Post reply

Passing Report Parameters via QueryString?

  • July 20, 2004 at 7:55 am

    #108795

    Is there a way to call my report, passing the needed parameters via QueryString?
    I'm asking this, because we use custom parameters asking screens, using the default layout of the web system here...
    Hmm, do you understand my problem?

    Thanks,

    Rafa®

  • July 22, 2004 at 5:37 am

    #515642

    Straight out of BOL (Books On Line)....

    Setting Parameters on a Report URL

    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 (&amp to separate them.

    Null parameters use special syntax; you must specify isnull for a null value. The following example illustrates multiple parameters for null and constant values:

    http://exampleWebServerName/reportserver?/foldercontainingreports/orders&division=mailorder&region=west&sales:isnull

    Parameters with multiple values are specified by repeating the parameter name; for example,

    http://exampleWebServerName/reportserver?/foldercontainingreports/orders&region=east&region=west

    If one of the values is null (that is, isnull), all other values specified for that same parameter are ignored.

    Boolean parameters are specified with a value of 0 or 1.

    Float parameters must include the decimal separator of the server locale.

    DateTime parameters must be specified with the format YYYY-MM-DDTHH:MM:SS, which is based on the International Organization for Standardization (ISO) 8601 standard.

    Steve.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply