for option one you would have to make a source (a crystal command or its equivalent like sql stored procedure or view) and in that source make one field that unites the 3 text fields together ito one long string that wold be your source in a dynamic param 9see below)
for the second option add your tables and link them in crystal
That gets your overall data set
add a parameter in the field explorer
make it Dynamic
under value coumn add 'Type' field
click in the parameters column and add a param name
under the value colum (under the 'type' row) add the number field
name it
repeat for class field
in your select expert you can use all 3 params to limit the data in the report.
when a user refreshes the report they can select new param options but I think the last values remain until altered.
If a user cahnges an upper level option it will wipe the lowere level options if they are not part of the correct cascading in the data set
Edited by DBlank - 27 Aug 2012 at 11:43am
IP Logged
