Blank Running Total Fields

[jrennatc]

I have a report (version 9) that uses running totals to get conditional counts. I then use the counts to suppress sections. The report runs great from my PC and shows 0's for the counts when no records exist. When I put it in Crystal Enterprise, the zeros do not appear (just Nulls) which makes my suppression formulas not work either. Is there a setting on CE that controls this? Any idea why it works in the report version, but not CE? I had to create over 150 running total fields to get the business unit what they were asking for, so I really don't want to try and re-write the formulas if at all possible.

Thanks in advance for your help.

 

[synapsevampire]

150 Running Totals...Ouch...

I'm not aware of this issue, but you might be able to use formulas instead of Running Totals for future requirements so that they would always return a zero.

Since you didn't what's in the Running Totals, where they are and any conditionals, it's pretty hard to advise you.

You might also make sure that the service packs are up to date on CR and CE.

-k

 

[jrennatc]

The users originally wanted a cross-tab, but the way they wanted the data organized, I couldn't get it in a cross-tab, so I mocked one up in the group footer using running totals.

Format like:

GH1 - group name
GH2 - group name
D - some details for particular records (others suppressed)
GF1a Titles across the top
GF1b RunTotA1 RunTotB1 RunTotC1 RunTotD1 ...
%ofTot %ofTot %ofTot %ofTot
...
GF1i RunTotA8 RunTotB8 RunTotC8 RunTotD8 ...
%ofTot %ofTot %ofTot %ofTot
GF1j Total Total Total Total

Then this grid is repeated in GF2

The running totals have formulas to evaluate the count of records. Example formulas like:
{@BusinessDays} >= 6 and {@BusinessDays} <= 9 AND {@ClosedStatus} = "Closed" AND {@TierDesc} = "Tier 2 Research" AND NOT ({Command.ACSUBSTATUS} IN ["External Participant","External Vendor","External Client"])

Or another is..

{@ClosedStatus} = "Closed" AND {@TierDesc} = "Tier 2 Retirement" AND ({Command.ACSUBSTATUS} IN ["External Participant","External Vendor","External Client"])

I tried changing the custom number format "Show Zero Values" property to use 0 instead of the default. Worked on my PC, but not CE.


Thanks again.

 

[synapsevampire]

Had you used a formula, it might be:

if {@BusinessDays} in 6 to 9
AND
{@ClosedStatus} = "Closed"
AND
{@TierDesc} = "Tier 2 Research"
AND
NOT ({Command.ACSUBSTATUS} IN ["External Participant","External Vendor","External Client"])
then
1
else
0

Then did a sum of this, you would receive zero when appropriate.

There may be a way to get Crystal to show the zero, as I said, I haven't come up against this.

You might try leaving the Running Totals and and testing a kludge of creating a formula which contains something like:

if isnull({#rt1}) then
0
else
{#rt1}

Of course you'd still have to create 150 formulas...double ouch...

Did you verify that your CE install has the latest service pack?

http://support.businessobjects.com/fix/hot/si75/default.asp

Might help.

-k

 

[jrennatc]

Good call on the service pack! Our dev system has SP2 for version 9. It ran fine there as well. We should be moving that SP to production soon.