Crystal report record/formula selection question

[susanna123]

Hi

I have a crystal report
The only issue I am now having is to not display the records if there are no data. The report is saved with data. It is filtered based on 4 parameters:
location, start date/time, end date/time and processing time.

The processing time is placed in a suppresion formula because I would like to show the average.
When i run the report with only 0 as my processing time, it will return all records that are less than or equal to 0 which is all the records but highlight those that are only greater than 45 minutes in red. This is correct behaviour. However, when i run my record with 45 minutes (2700) as the processing time in my parameter, it will display all records but suppress those that are less than 45 minutes. However when the field is being suppressed it shows blank space on the report. I would like to suppress the group header 1 but I have tried and cannot due to the record selection formula. Can you help?

 

[Madawc]

If you only want records with a particular 'processing time', then put the test in record selection. What you seem to be doing is getting all of the data and then suppressing what you don't want. Groups with the suppressed data are still there.

If there's some reason you can't use record selection - e.g. you need the data for something else - then use a running total that counts on the parameter values and use it to suppress the group footer. It has to be the footer because a running total will always be zero for the group header.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP