Post reply

Cannot consistently pass url parameter

  • May 13, 2008 at 3:52 pm

    #182424

    I am passing in two parameters in the URL to my report. They limit the selections in one dataset that is used to populate a drop down list of report parameters (in this case 'Regions'). The url parameters are Region and Role. If the role is a manager, they can see a larger selection of regions, if they are not a manager, they see only their region as an option in the dropdown. Please don't be confused by the fact that the dropdown is showing a selection of regions, while at the same time the URL is passing in a 'Region' parameter -- there is a reason for this but it doesn't relate to this issue.

    The URL parameters are used in a dataset (running a stored procedure) that expects the two parameters. The parameters are used nowhere else in the report. Under the report parameters definition tab, I have the url parameters at the top of the list (as I understand it, this forces the report to evaluate them first). When I run the stored procedure in SSMS, it functions as expected -- both when I pass in 'Manager' or 'SalesRep' as role. When I pass in 'Manager' in the url, it functions as expected (that is, the drop down shows all the expected selections). When I pass in 'SalesRep', the drop down list is empty -- which to me suggests that the sproc is not returning the filtered dataset.

    When I preview the report in BIDS, manually typing in various values for the parameters that would otherwise be passed in in the URL, the report runs as I expect. Also, as I mentioned above, in SMSS the sproc runs fine.

    Any thoughts anyone? many thanks. David

  • May 14, 2008 at 12:28 am

    #814958

    Please don't cross post. It wastes people's time and fragments replies.

    No replies to this thread please.

    Direct replies to the following:

    http://www.sqlservercentral.com/Forums/Topic500040-150-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 14, 2008 at 9:25 am

    #815302

    Mea culpa.

    I found the other forum after posting to this one.

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

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