Including null values in parameter fields 1

[maddyyikes]

Using: Crystal Reports 8.5
P4 Database (proprietary)
ODBC driver

I have a field called "SubCategory" in the database. It has the following values:

Mainframe
Security
Network Infrastructure
Hardware
Desktop Software
....and so on(about 50 values)

I have the following requirement:

Sometimes I need to see the records pertaining to all the subcategories while at other times I need to see the records of all subcategories except one of them (say Mainframe) How can this be achieved using the parameter field, as I want the user to make a choice for the same, at runtime? I do not want to specify all the values (in the "SubCategory" field) as default values in a parameter field and then select a subset of them, as I feel that there is a more efficient way of achieving the same. Plz help!! Thanx in advance!!!

Note: The "SubCategory" field has been concatenated with the "Category" and "Problem Type" fields and is represented as "Category-SubCategory-ProblemType" field in the report.

 

[MColeman]

You could have a parameter that defines the run mode.

if {@runmode} = 'I' then include all else
if {@runmode} = 'E' then exclude only the selected
subcategories

 

[maddyyikes]

Hi ,
Thanx a lot! ...but could u plz explain to me more specifically as to how I can exclude a few subcategories and select the others? Thanx in advance!

 

[MColeman]

if {?runmode} = 'I' and {@subcategory} = {?subcategory}
then true else
if {?runmode} = 'E' and {@subcategory} not = {?subcategory}

where {@subcategory} is the field name in the database
and {?subcategory} is the parameter for subcategory
and {?runmode} is the parameter for the run mode