Solved

Count with null values

Posted on 2003-10-21
12
559 Views
Last Modified: 2008-03-04
In the report I have a count of a fields that can be null (I use LEFT OUTER JOIN in SQL).

 When I created all my reports, Crystal Reports gave zero for the count when all values of the field are null.

 But now, using RAS or installing Crystal Reports in other PCs, the result (in the same reports) for the count is null when all values of the field are null.

 I have tryed selecting "Convert another NULL values to predeterminated" in Report Options, but it only works with summary fields, not with summary in crosstabs. I use a lot of crosstabs in my reports.

 Which is the option I have to select in my PC so I get zero with the count of null values?

 I know I can get zero using a formula instead of using a summary count, but I have a lot of reports. So I would prefer knowing why Crystal Reports works different in my PC, instead of modifing all my reports.

 Thanks in advance. Regards

 Inaki

 
0
Comment
Question by:jtaaribi
  • 5
  • 4
12 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 9593731
Are the machines using the same version of MDAC?

mlmcc
0
 
LVL 7

Expert Comment

by:ladylinet
ID: 9594007
There is an option in 'Options' too, that superseed 'Report options' one  - check what do you have there.

Lady Linet
0
 

Author Comment

by:jtaaribi
ID: 9614955
The problems can be the service packs.

 When I created all my reports, I had Crystal Reports 9 Advanced SP 1. I got zero for the count of a field when all values of the field were null. Besides, viewing reports with RAS, the count result was zero when all values were null.

 But now, installing SP2 in Crystal Reports or SP1 for RAS (Crystal Enterprise), the result (in the same reports) for the count is null when all values of the field are null.

 The problem is with Crystal Reports without Service Packs installed too. Only works fine with Crystal Reports SP1, and RAS without Service Packs.

 This problem occurs with summary fields and with crosstabs

 Thanks. Regards

 Inaki
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
LVL 7

Expert Comment

by:ladylinet
ID: 9615457
Ok, try installing latest Monthly Service Pack for CR Main, Export/Database and RAS - RAS one is dependant on Database/Export one, and you should have all 3 installed.
 They fixed lot of things in latest monthly fixes.
 
Lady Linet
0
 

Author Comment

by:jtaaribi
ID: 9626128
The SP2 for Crystal Reports and SP1 for Crystal Enterprise have been released now (October 2003), so the newer Monthly Hot Fix was published in september (2003-09-09).

 Regards

 Inaki
0
 
LVL 7

Expert Comment

by:ladylinet
ID: 9629604
So you have September hotfix installed?
 SP2 includes hotfix from June and before; they released it in September, but it does not include September hotfixes, because they are not tested enough. Service packs are always laging behind monthly fixes.

Lady Linet
 
 
0
 
LVL 7

Accepted Solution

by:
ladylinet earned 125 total points
ID: 9630394
Check this:
 http://www.kenhamady.com/news0310.html

 Perform Grouping on Server - who will guess that this option can cause so much trouble?

Lady Linet
0
 

Author Comment

by:jtaaribi
ID: 9632262
I have downloaded cr90mainwin_en.zip (Crystal Reports 9 Main Program Files Monthly Hot Fix, published at 2003-09-09).

 I have been comparing cr90mainwin_en.pdf and cr90win_en_sp2.pdf. I have selected some bugs in cr90mainwin_en.pdf, and I have found them in cr90win_en_sp2.pdf too. So I think the bugs of September Monthly Hot Fix are already included in service pack 2.

 Thanks. Regards

 Inaki
0
 

Author Comment

by:jtaaribi
ID: 9942493
Crystal Reports has assigned a number for solving this bug and has resolved it in WHF (ADAPT00221763)
 Thanks for all
 Inaki
0
 
LVL 7

Expert Comment

by:ladylinet
ID: 9943401
I'm glad to hear that they acknowledged and fixed that bug.

Lady Linet
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question