>HI,
>
>I have been trying to figure out the following problem:
>
>I create a report with two bands. One band has a column EXT_PRICE. I select a small subset of records and the total (at the bottom) always show the number which is larger that the sum (calculated outside) of each item. And it looks like the difference is always by 2. I even view in the debugger that records in the cursor of the band and it shows all the numbers just like in the report. Yet, the total is different.
>
>The variable that shows the Total is set as follows:
>Value to store: CURPODET.EXT_PRICE
>Initial value: 0
>Calculation type: SUM
>
>Can you see what is missing?
>
>TIA
>
>UPDATE. I see that the difference in total is different in each case. Not always by 2.
I believe that relying on Variables to calculate the totals in a two-band report is not a good practice. I found another report in my program, also two-band. And in that other report I was creating a Totals cursor (basically calculating the totals "manually" instead of relying on the Variables. I will do the same in this report.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
