Distinct count showing 1 when there is nothing

[dev1212]

Hi guys,

I have a field {Prod.Accountnumber}. I did hierachical grouping on {Prod.branch}. When i am doing distinct count of {Prod.Accountnumber} i am getting all 1's but it should all be 0's.

Please reply ...

Thanks

 

[dev1212]

any ideas guys on distinct count?

Distinct count of {Prod.branch} gives me 1 when its Null

 

[swiss2007]

Try this
Go to File ----> Report Options ------> uncheck Convert Database NULL Values to Default.

 

[dev1212]

Thanks a lot ... it worked...

 

[dev1212]

I've a problem here..
I want to display '$0.0' when there is null of amount.
So, i did check 'convert database null values to default', if i do that then distinct counts are getting messed up.

How to display '$0.0' when the amount is null..?

Any ideas..

I tried to create a text object and wrote '$0.0' and in suppress option of that text object i wrote
"IsNull(Sum({Prod.amount}))=FALSE"

But it isnt working, i cannot use formulas here as its hierarchical summaries and crystal reports doesnt allow you to write hierarchical summary in the formula field..


Please reply with suggestions...


Thanks

 

[lbass]

Replace the amount field with a formula:

if isnull({Prod.amount}) then
0 else
{Prod.amount}

-LB

 

[dev1212]

thanks... it worked..