July 16, 2009 at 10:29 am
Please tell me this can be done..
I have 5 parameters for my reports: P1, P2, P3, P4 and P5. P1 and P2 are required
P3, P4, P5 are optional and allow mutiple values.
P3, P4 and P5 have forward depdences, meaning in the sql/stored procedure, P4 uses P3 as an input parameters(Optional), P5 use P3 and P4 are input parameters(Optional)
When first time viewing the page, P3, P4 and P5 all need to display values even the optional parameters are not provided at that time.
If value(s) in P3 is selected, P4 and P5 will use values in P3 to limit their value range.
If value(s) in P4 is selected, P5 will us values in P4 to limit their value range
Is it possible in SSRS?
July 17, 2009 at 5:33 pm
Without knowing more, I'm afraid that my answer may seem a little vague.
Perhaps you could use multiple SSRS reports. I used an "initial" page to have the user click on one out of 8 "buttons"(really text fields linked) they link to one of eight reports that have different selections for each of the variables. It appears to the user to be the same report, in fact it's copied and pasted for development.
I used to try things in one step, but you may be able to accomplish this by linking reports together.
July 20, 2009 at 6:36 am
Wesley,
Thank you for the reply. I found a solution after googling.
1. Make a parameter optional (Apply to P3,P4 and P5)
1) Add 'ALL' in the drop down list by including a ' UNION' statement in the select statement for the drop down.
2) Make 'ALL' as the default parameter value, so that user does not have to make selection in the drop down
3) For forward dependence, include a OR statment to check if the default value is used
when checking the dependence.
a)for P4 add
'ALL' IN (@P3)
b)for P5 add
('ALL' in (@P3) OR 'ALL' in (@P4))
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply