Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Group Count

edited February 2007 in General
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

Comments

  • edited February 2007
    Hi Steve,

    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited February 2007
    Nico Cizik (Digital Metaphors) wrote:
    Worked like a dream - I was putting the variable in the Group Footer :(

    THANKS :)
This discussion has been closed.