Supressing Data Problem in Graphs

[polynominalc]

Hi

I am using Crystal Reports 9.

In my report I am grouping on a formula called @groupdays.
I have used a formula called open to calculate days in my report.

My formula is

if {TSSeverity}= "Critical" and {open} > 5 then "5 days" else if {TSSeverity}= "High" and {open} > 10 then "10 days" else if {TSSeverity}= "Medium" and {open} > 15 then "15 days"

When I group on this I get the groups high, medium and low and a blank group with all the records that dont meet this criteria. I can suppress them, but I need to do a count on the number of records and when I do the ones in the blank group come into the count and also when I graph the number of records that meet the @groupdays criteria, the suppressed records are displayed

Is there a way around this

Thanks

Mark

 

[lbass]

Go to report->edit selection formula and enter:

{table.TSSeverity} = "Critical" and {@open} > 5 or
{table.TSSeverity} = "High" and {@open} > 10 or
{table.TSSeverity} = "Medium" and {@open} > 15

Although the formula components won't be included in the SQL statement and will be processed locally, I think this will give you the capacity to use summaries and graph as you wish.

If for whatever reason you can't do this, you would need to use running totals to get your counts, and use "evaluate based on a formula" to enter your suppression criteria. For the graph, you would need to select the "on change of" field, choose "order" and choose "specified groups". You would then enter the three groups you want shown using the dropdown list. Then choose the "Other" tab and select "Discard all others." This would eliminate the other group from your chart.

-LB