Report problem

[lemonjuice]

I have created a table using sql. I also calculated a totals field in this table by using code(basically adding two fields together and determining the cummalative of that total). This calculation does not work correctly when i do it on the report so i have to use code. I then created a report and defined the fields as usual, but i added a Group band on the customer id. The problem is that i have to have the group on my report, but now the data lies differently in the table than on the report (because of the group). Now my total field does not display the amounts on the report according to the record.

for example:

amount amount total
a a c's total
b b a's total
c c b's total

Does anyone have advice on how to get the correct total next to the correct record?

Please help!!
~Lemon~

 

[dcpking]

1.

<<This calculation does not work correctly when i do it on the report so i have to use code.>>

it should: please post the content of the calculated field in your report that should be showing the result of, say, the combination of a1 and a2, along with all the values in the line.

2. Define your report so that you know what you'll want to see in advance (bands included). Then check out your data to see that there are fields for each group band to group on. Your descriptions aren't too clear.