April 18, 2005 at 8:43 am
I have created a report that uses a stored procedure with the parameters @StartDt, @EndDt and @User. I want to show a list of users based on if they posted within the @StartDt and @EndDt.
I have tried creating a data source where I select distinct users where posted date is within the @StartDt and @EndDt. I then went to the Parameters window and used the data source on the @User parameter. When I preview the report I put in the dates and then click on the drop down arrow and the screen starts flashing the parameters section, but never comes back.
Can anyone tell me what I am doing wrong?
April 18, 2005 at 5:18 pm
If you want these to be dependent (also called 'cascading') then you need to ensure they are in the correct order, that is, if you want to use dates in the latter parameter queries, then you need to moe the date parameters above the user parameter in the report parameters list.
On a slightly different tack, if your report is intended to show users who did something between two dates, why do you have a user parameter at all? ie bring back all users who did something between A and B. Alternatively, if you want to see if a particular user did something between two dates, then your parms don't need to be related (ie you *want* a filter that says 'time >= A' AND time <= B and User = 'X').
Last option is that you're having to create your parm lists from the 'fact' (transaction) table. If so, your DB design could have some flaws, and you could/should have a 'user' table that you can query to get the list of users for your parameter drop down.
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply