Crystal 8.5 - Need help creating formula to hide data

[christinetjx]

I have created a report displaying calls logged to a Helpcenter. The calls are grouped by assignment. Calls closed immediately by the Helpcenter are listed first as 'Closed on Initial'. I use the following formula (from lbass) to get this info:

If isnull ({incidentsa3.assignment}) or {incidentsa3.assignment} = '' then
'Closed on Initial'
else
({incidentsa3.assignment})

That formula works wonderful.
What I would like to do now is filter out other groups that come up in the list. For example in the list below, I would like to completely leave out the groups 'Projects' and 'Future Releases' so they don't show up at all:

Group: # Calls Closed:
Closed on Inital 2359
Development 43
Projects 54
Future Releases 3

Can I do this by elaborating on the original formula mentioned above, or should I create a new formula to do this (there are about 6 assignment groups I want to leave out.) I would greatly appreciate it if you could show me how to do this.

Christine

 

[kskid]

If you don't want to see it at all, then I would filter it out in the Records Selection.

not({incidentsa3.assignment} in ["Projects","Future Releases"])

Cheers,
-LW

 

[christinetjx]

I'm sorry, that does not appear to be working correctly. Was I supposed to create a new formula (which I did) or should that be part of my old formula?

As a new formula, what it displays now (next to the group name) is True or False.

Thanks for your patience, I am a novice at this.

 

[synapsevampire]

In the Report->Edit Selection Formula->Record place LW's formula.

-k

 

[christinetjx]

Ok, this is what is happening.
Right now I have 2 sets of criteria in this report:

I have the formula I first mentioned that gives me 'Closed on Initial Calls'.

I also have the criteria you had me post in the
Report | Edit Selection Formula | Record area.

Your suggestion worked; the groups I wanted out of there are gone.

However I now no longer see my 'Closed on Initial Calls' either, which brings me back to my initial question. Do i somehow merge these 2 sets of criteria so that i see all this information when I look in
Report | Edit Selection Formula | Record area.

Thank you.

 

[kskid]

The original formula you have

If isnull ({incidentsa3.assignment}) or {incidentsa3.assignment} = '' then
      'Closed on Initial'
else
      ({incidentsa3.assignment})

should be placed on your report canvas. You can also group on this formula to give you the totals you need

-LW

 

[christinetjx]

Thank you for your quick responses. The problem still exists. My formula for 'Closed on Initial' (@COI) works by itself and your suggestion about the record selection also works by itself. However, when i use the two sets of criteria together, any kind of record selection where I list even one assignment group I don't want to see... when I run the report, it also completely removes my 'Closed on Initial' assignment group. No other assignment groups are affected.

On the report canvas, I have dragged the @COI formula to where the Group 'Assignment' is posted (the Group 'Assignment' is suppressed). Thank you again for your assistance.

 

[kskid]

Please post your record selection formula. You may have to check for nulls

isnull(incidentsa3.assignment) or
not({incidentsa3.assignment} in ["Projects","Future Releases"])

 

[christinetjx]

Heeeyyy.... how come my mail didn't notify me you wrote. hmmm... Good news, I figured out what i was doing wrong. Instead of making my record selection on the Group 'Assignment', I made the selections on the COI formula I'd created and dragged over to where the Assignment Group was posted. Thank you so much for all your time. It is greatly appreciated.