Exclusion of some data...Need Help!

[proflola]

Hi All,

I have several Crystal Reports that support our Heat Help Desk. When I run the Report to Average the Duration of Calls by Type, there's one type "Internal Errors" that scews the bar chart. The Help Desk Manager would like to omit that type when running the report. I'd like to do a query that can show the report with all or excluding that type.

Do you have any suggestions?

Thanks,

SJD

 

[synapsevampire]

Go into the Report->Record selection-REcord and palce something like:

{table.calltype} <> "Internal Errors"

That will omit that data from the report.

-k

 

[lbass]

You could set up a parameter {?Exclude} and then set up your record selection formula like:

if {?Exclude} = "Y" then
{table.calltype} <> "Internal Errors" else
if {?Exclude} = "N" then
true

-LB

 

[proflola]

Thanks a bunch! I knew it had to be something simple. I'll try the parameter report selection. It sounds perfect.

--Sandy