Crystal Reports 2008, Oracle 11g

[hmax]

Hello:

Group A = ABCPerson
Group B = Case ID
Group C = Status - can be multiple per Case ID

So, some examples
Case ID 123
Status Closed
Status Closed - Resolved
Status Open - Investigating
Status Closed etc.

Let's get the total # Case IDs that do not have the status of "Open - Investigating" or any other status like "Open ..."

How do I do this, please? Have tried summary, running totals, and formulae. Not there yet.

Thanks!

hmax

 

[IanWaterman]

In details add formula

@NotOpen
If not({Status} like 'Open*') then 1 else 0

Then just add a normal Sum summary of this formula to your Casid group footer

Ian

 

[hmax]

Hi IanWaterman:

Yes, I thought it was this simple, too, but unfortunately it's not playing out because of the multiple status possibilities under a Case ID. Still trying ...

 

[Turkbear]

Hi,
Why group on Status? If you place that field in the details you can then use that formula to get the #
You can suppress the detail section if you want ( and do not have any other fields in there)



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[hmax]

Hi, TurkBear:

I need to see the details, and I am calculating running totals and summaries on a bunch of other items.

I found a workaround finally - created a formula for all like open results = 1 or 0.
Then created another formula calculating the sum of all results for all open/closed/pending/investigating/etc. and subtracting the like open results where = 1.

It's working.

Thanks for the suggestions, item resolved.

hmax

 

[lbass]

I don't think you will consistently get correct results with this approach. You should use a formula like this:

//{@hasOpen}:
if {table.status} like "*Open*" then 1

Then use a running total that does a distinct count of personID, evaluate using a formula:

sum({@hasOpen},{table.personId})=0

Reset Never.

-LB

 

[hmax]

Oh, good to know, lbass. Thanks for the update, and I'll go with your suggestion.

-hmax