Group Count
Hi I have a report to do and in the summary I have to give an order and
consignment count
like:
Consignment Order
----------------------------------
C1 12334
45541
4557
C2 4564654
444555
C3 4456465
4555777
1122
2211
111
C9 12221
C10 114454
---------------------------------
Total Consignments = 5
Total Orders = 12
I Have the report Grouped by Consignment
I can easily get the Total orders using a DBCALC in the summary band.
The problem I've got is getting the consignment count. What I think I
need is a counter that increments in the group footer.
BTW Using D7 with RB Ent 9.03
consignment count
like:
Consignment Order
----------------------------------
C1 12334
45541
4557
C2 4564654
444555
C3 4456465
4555777
1122
2211
111
C9 12221
C10 114454
---------------------------------
Total Consignments = 5
Total Orders = 12
I Have the report Grouped by Consignment
I can easily get the Total orders using a DBCALC in the summary band.
The problem I've got is getting the consignment count. What I think I
need is a counter that increments in the group footer.
BTW Using D7 with RB Ent 9.03
This discussion has been closed.
Comments
Try placing a TppVariable inside your summary band that calculates on the
Group End. Then inside the OnCalc event, increment the value of the
variable. This will accurately give you a count of groups at the end of
your report.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Worked like a dream - I was putting the variable in the Group Footer
THANKS