Combining Two Values for a Parameter

[LHG33]

Hi everyone! My report has a parameter called ReportType. ReportType is set equal to a field called StatusCode, which has three values to select from: 'C', 'R', and 'P'. My problem is that when I select 'P', I would like to see data for 'P' and 'R' both on the report.

So in effect, with my parameter I would be able to choose either 'C' (which would be regular), 'R' (which would be rejects), or 'P' (which would be power encode AND rejects).

I have tried to write a formula to combine 'P' and 'R' but to no avail. I was going to set that equal to the parameter. Any ideas?

Thanks!

 

[synapsevampire]

In the record selection criteria, place something like:

(
If {?ReportType} = "P" then
{MyTable.StatusCode} in ["P", "R"]
else
If {?ReportType} = "C" then
{MyTable.StatusCode} = "C"
else
If {?ReportType} = "R" then
{MyTable.StatusCode} = "R"
)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com