Report does not display 0 for Count function in Enterprise 1

[RamForum]

Hi
I am using Crystal Enterprise 9. I have created all hte reports in Crystal Designer 8.5. Before loading the report in Crystal Enterprise i am saving the reports in Crystal designer 9.0. When i created instances for the reports in the Enterprise, i found that report using Aggregate function SUM displays 0 if it doesnt have any value whereas count would not display 0. Instead it has blank space. In the Designer it shows but in the enterprise it wouldnt.
If anybody knows solution for this problem, can you please help me?
Thanks
RamForum

 

[synapsevampire]

Right click the field and select format field->Number->Customize->Show Zero Values as->0

If tha doesn't handle it, I'd apply the service packs to all products involved, and then if it persists, use a formula at the COUNT level which has:

If isnull(count({table.field},{table,groupfield})) then
0
else
count({table.field},{table,groupfield})

Something like that.

-k

 

[RamForum]

Hi
Thanks for the reply. Actually one of the report is a simple Cross-tab report. How do i apply the formula in the count level?
Thanks
RamForum

 

[synapsevampire]

I couldn't get the same results, but you can set the default for the summaries in a crosstab by doing the same thing (run the report and then right click the summary).

Not sure if it will work as you're getting a different result.

-k

 

[RamForum]

Thanks!
~
RamForum