Suppressing Problems. 1

[Sparks78]

Can you help?

BACKGROUND
I'm trying to display a list of open cases per a person in per a queue so I have the following grouping.

Queue. => Person. => Case I.d

I only want open cases to show. Within each grouping I have information about group, e.g. In the queue I have details of which queue. For Person I have a string detailing persons name.

PROBLEM
When a person doesn't have any cases open I cannot seem to suppress their name. If I add a formula to suppress when a number of cases are not certain status' everyone's name is suppressed, this is because everyone within the Db has got closed/cancelled jobs at one time. Cases can have a number of status' and still be open, cancelled and closed are the only status' I don't want.

Solution??

 

[dgillz]

Are you supressing or are you excluding the records from the report entirely with a selection formula?

You should be trying the latter, IMO.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Sparks78]

I am suppressing the data. How would you go about excluding data in a formula?

 

[Madawc]

Try Case I.d <> cancelled and Case I.d <> closed

If the rest of the select logic is complex, it would be worth writing this as a Formula field and then just testing for the formula field. If you don't start with an 'If' it will be a Boolian, returnin true or false. You can test not @Unwanted


Madawc Williams (East Anglia, UK)

 

[dgillz]

You go to report->edit selection formula->record, or report->edit selection formula->group. Then write your formula to exclude the records from the report.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Sparks78]

I am already doing the suggestion by Madawc, but thanks none the less.

I have had a brief look at the, report->edit selection formula->record, or report->edit selection formula->group this seems like the place to start.

I'll have ago tomorrow and will report back, thanks for the info.