How to read <NULL> 1

[CrystaLv]

I am running my SQL quesry and output result is

Order Stage
123 NC
123 <NULL>
123 Completed

So I need to count how many different stages my order has.

NC-1
<NULL>-1
Completed-1

But value <NULL> doesnt get read somehow by CR9.
Is there way around?

I need to count everything that is not Completed so <NULL> and NC will have to be 2.

Thanks

 

[lbass]

Here's a formula for counting:

if isnull({table.stage}) or
{table.stage} = "NC" then 1

Then insert a SUM (not a count) on this.

-LB

 

[CrystaLv]

It works, thanks.

Now when I have

CusID Value

123 1
123 0

111 1

112 1

I need to filter those CusIDs where Value is 0 at least once. Thanks

So in this case 123 will be eliminated and only 111 and 112 shown.

 

[IdoMillet]

@Is_It_Zero:
IF {table.value} = 0 THEN 1 ELSE 0,

Report, Selection Formulas, Group...:
SUM(@Is_It_Zero, {CusID})=0

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com