Parameters and Specified Groups

[theosbeer]

Hello all,

CR XI R1
ODBC

I have a report with Specified Groups i.e.

Elementary Schools
where 'School Name' LIKE "ES"

Middle Schools
where 'School Name' LIKE "MS"

High Schools
where 'School Name' LIKE "HS"

Others = Secondary Shcools

I want the users to have a parameter that statically selects
Elementary Schools
Middle Schools
High Schools
Secondary

so they can pick more than one parameter, Elementary and Middle and so on.

and I need to do this in the Records selection so that the preview tree appears correctly.

any Ideas, I feel like i'm missing something small.

Theo
Middle Schools
High

 

[lbass]

Your record selection formula just needs to be:

{table.schoolname} = {?Parameter}

You could use a formula like this to group on:

select {table.schoolname}
case "ES" : "Elementary School"
case "MS" : "Middle School"
case "HS" : "High School
//etc.

Insert a group on this and then use specified order to order the groups.

For the parameter setup, add the field like "ES", "MS", "HS" as the value field, with the description entered in the description field.

Or, do you mean that there are varying school names, all tagged with "ES" or MS", etc?

-LB