Go4Expert (http://www.go4expert.com/)
-   Programming (http://www.go4expert.com/forums/programming-forum/)
-   -   Crystal Reports XI. Sum field value = "1.#J" (http://www.go4expert.com/forums/crystal-reports-xi-sum-field-value-1j-t13724/)

 josemacall 11Sep2008 14:33

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.

 josemacall 11Sep2008 14:52

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".

 suki_su 23Nov2009 22:55

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

Did you or anyone out there figure this out?

 janatar 10Dec2009 01:32

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

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

 All times are GMT +5.5. The time now is 01:57.