Adding boxes in a report.

[Guest]

I added the field "Service Charge" to an exsiting report. Each line in the
report is a calulated line.
For example Line one will have QTY=8 Service Charge = 10.00
Line two will have QTY=3 Service Charge = 3.00
ect......
QTY = 8 means that 8 lines in the query went into making this one line on
the report. Each line in the query has a Service Charge of 10.00. However
only one counts!!!!

I wont to add a total box that will total all the Service Charge
boxes.(ServiceChargeBox) on the report. Both for the footer section and a
grandtotal.

how do I calculate the ServiceChargeBox field in a report? I really don't
wont ro redow the query.

 

[Marshall Barton]

I added the field "Service Charge" to an exsiting report. Each line in the
report is a calulated line.
For example Line one will have QTY=8 Service Charge = 10.00
Line two will have QTY=3 Service Charge = 3.00
ect......
QTY = 8 means that 8 lines in the query went into making this one line on
the report. Each line in the query has a Service Charge of 10.00. However
only one counts!!!!

I wont to add a total box that will total all the Service Charge
boxes.(ServiceChargeBox) on the report. Both for the footer section and a
grandtotal.

how do I calculate the ServiceChargeBox field in a report? I really don't
wont ro redow the query.

Are you saying that the report's detail section is
invisible? If so, redoing the query would be the best way
to deal with this issue because then the grand total would
just be a text box with a Sum expression.

If you can not do that, then add a text box named
txtRunServiceCharge to the group footer. Set its expression
to =servicecharge and RunningSum property to Over All.
Then the report footer text box can display the grand total
by using the expression =txtRunServiceCharge

 

[Guest]

Let me simplfiy this. In the PCCORDERNUMBER header is the box
SERVICECHARGEBOX. The information in this box is correct. In the NEWCUST
footer I won't the total of SERVICECHARGEBOX. It is that easy.

I can not use the field that SERVICECHARGEBOX uses because that information
is wrong. Only because it is replicated.
example: QTY=8 SERVICE CHARGE= 10.00

there are 8 records that make up the example. and all eight records have a
field call SERVICE CHARGE: 10.00. however I only need one entry of 10.00.
ON the report the SERVICECHARGEBOX shows 10.00. that is why I wont to use it.
If I can just use the SERVICECHARGEBOX in the calculations I can finish this
report.

 

[Marshall Barton]

Ok, you still need to use a running sum text box.

Add a text box named txtRunServiceCharge to the group
header. Set its expression to =SERVICECHARGEBOX and
RunningSum property to Over Group. Then the NEWCUST footer
text box can display the grand total by using the expression
=txtRunServiceCharge

 

[Guest]

I don't know How or When but when we meet..... I am buying you a beer!!!

Thank you.
Scott Burke

ENJOY THE HOLIDAYS!

 

[Marshall Barton]

Good on you, Scott, I'll look forward to it ;-)

Glad to hear you can move on your program's next issue ;-))