Report using Count doesnt print 0's

[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

 

[hilfy]

Have you checked the format? If not, right-click on the formula in your report and select Format Field. Go to the Number tab and click on the Customize button. Make sure that "Suppress if Zero" is not checked.

-D

 

[RamForum]

Hi hilfy
Thanks for the reply. i checked it. "Suppress if Zero" option is not checked. It displays 0's in the designer. Only in the Enterprise it is not showing.
~
RamForum

 

[Madawc]

Try checking your global options, [Options] under [File] on Crystal 8.5. You may find that different machines or software tools have different settings and hence get treated differently.

Madawc Williams
East Anglia, Great Britain

 

[RamForum]

Hi
Thanx for the reply!
wot do u mean by global options? Which setting should i check for?
Can you plz brief it?
Thnx much
RamForum

 

[Madawc]

Crystal 8.5 has default values for numbers, currency, strings etc. You can change these as I described above, so that each new Crystal report will use those values, unless you go in and change it for those fields.

Different machines can have different settings. I found this problem when we upgraded our machines. Stuff I had defined with my old defaults had different settings after the migration and had to be reset.

Madawc Williams
East Anglia, Great Britain

 

[RamForum]

Thanks!