jtaaribi
asked on
Count with null values
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
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
There is an option in 'Options' too, that superseed 'Report options' one - check what do you have there.
Lady Linet
Lady Linet
ASKER
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
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
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
They fixed lot of things in latest monthly fixes.
Lady Linet
ASKER
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
Regards
Inaki
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
Crystal Reports has assigned a number for solving this bug and has resolved it in WHF (ADAPT00221763)
Thanks for all
Inaki
Thanks for all
Inaki
I'm glad to hear that they acknowledged and fixed that bug.
Lady Linet
Lady Linet
mlmcc