Totals

[administrator]

In my details section, I have a control "totaldiscounts"
that pulls from the query. However, in the report footer
I have =sum([totaldiscounts]) and the amount it's
reporting is 3 to 4 times too much. This is also working
the same for "grandtotal" that is also pulling from a
query, but in the report footer =sum([grandtotal]) is
giving me 3 to 4 times too much. What am I doing wrong?

 

[administrator]

I have the control for sorting and grouping set for
the "ticktype" control, but not for "discounts" or "COH",
which are the two giving me problems.

Any other suggestion?

-----Original Message-----
The control may be summing various groups over the
report, if you have the sorting and grouping option
turned on.

Jesse Avilés
(e-mail address removed)
http://home.coqui.net/monk

-----Original Message-----
In my details section, I have a control "totaldiscounts"
that pulls from the query. However, in the report footer
I have =sum([totaldiscounts]) and the amount it's
reporting is 3 to 4 times too much. This is also working
the same for "grandtotal" that is also pulling from a
query, but in the report footer =sum([grandtotal]) is
giving me 3 to 4 times too much. What am I doing wrong?
.

 

[Jesse Avilés]

Follow this link and see if there is something that can help you. I had a
similar problem and this helped me out.

--
Jesse Avilés
(e-mail address removed)
http://home.coqui.net/monk

I have the control for sorting and grouping set for
the "ticktype" control, but not for "discounts" or "COH",
which are the two giving me problems.

Any other suggestion?

-----Original Message-----
The control may be summing various groups over the
report, if you have the sorting and grouping option
turned on.

Jesse Avilés
(e-mail address removed)
http://home.coqui.net/monk

-----Original Message-----
In my details section, I have a control "totaldiscounts"
that pulls from the query. However, in the report footer
I have =sum([totaldiscounts]) and the amount it's
reporting is 3 to 4 times too much. This is also working
the same for "grandtotal" that is also pulling from a
query, but in the report footer =sum([grandtotal]) is
giving me 3 to 4 times too much. What am I doing wrong?
.