Running CR Pro. 10

 

Got a report that I'm having a "Grand Total" formula issue with...the formula below is in RFooter B. <br><br>

 

{#Local}+{#National}+{#Prospects}<br><br>

 

It works well when there is data in each of the three buckets but if any of them are empty then the Grand Total is empty.

 

Here's an example of the {#Prospects} "Running Total" formula the other two (Local and National) are similar.

 

({tblReps.RepNumber} in [3,247,253,280,282,479,504,592])
and
({tblAccounts.AccountType} = "Prospect")

 

Any ideas on how I can fix this problem?

In your example I had to make the following adjustments; the first #Local was missing a right bracket and the last line had to be adjusted, replaced #National with #Prospects and all was well!

 

Thank you very much for your help in solving this issue! I'm sure I speak for many who frequent this forum, your generosity in sharing your wealth of knowledge of Crystal Reports with others is very much appreciated!!!