May 13, 2008 at 3:52 pm
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
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
May 14, 2008 at 9:25 am
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