April 22, 2015 at 2:25 pm
In an existing SSRS 2012 report, I have a requirement for a user to be able to select by multiple school(s) and/or multiple grade(s). This is fine except certain schools like elementary have grade levels of KG to 06, Middle school has grades of 06 to 09 and high school has grades of 10 to 12. Thus for example, if a user has initially selected grades 11 and 12 and then they select an elementary school that has grades KG through 06, the 'grade level' selection would need to change.
In other words, I am thinking of initially having the available and default values for the parameter called 'Grade' set to KG through 12. However if a school is selected that only has specific grade levels like elementary school, how can I override the original grade level and only allow the user to select grades that the particular school contains?
April 23, 2015 at 8:18 am
Why not just cascade the parameters?
First one is Elementary/Middle/High School
Second filters based on that.
SELECT Grade FROM src WHERE Level = @Parameters!Level
April 23, 2015 at 9:10 am
The user may not care about what school is selected. They may only want to see certain grade levels. Thus the grade level may be independent of the school selection. Thus could you tell me how to accommodate that request?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply