Crystal Reports XI. Sum field value = "1.#J"
 

Hi all:

We're meeting a problem while developing a CR XI report. The structure of the report is as following:

Group 1 Header ---> Description of the group - Subtotal of a Formula (sum option)

Group 2 Header ---> Description of the group - Subtotal of a Formula (sum option)

Group 3 Header ---> Description of the group - Subtotal of a Formula (sum option)

Details --> Hidden

All subtotals are identical but while in group #1 and group #3 they seem to work properly, in the group #2 we get the value "1.#J"


As and example of what's going on:

Group 1 Header ---> "Group 1" - 2000

Group 2 Header ---> "Group 2" - "1.#J"

Group 3 Header ---> "Group 3 1" - 1000
Group 3 Header ---> "Group 3 2" - 1000

Details --> Hidden

Can anyone give as a clue to solve this problem.

Thanks in advance.

Re: Crystal Reports XI. Sum field value = "1.#J"
 

Adiccionaly, when the report is exported to an Excel Application the value in that cell is "0.00", but not the sum. (2000 in the example).
If the Export action is to pdf, we get the wrong string "1.#J".

Re: Crystal Reports XI. Sum field value = "1.#J"
 

Did you or anyone out there figure this out?

Re: Crystal Reports XI. Sum field value = "1.#J"
 

Instead of using automatic totalling, use the running total feature to get around this problem.