Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Variable using "Count"

rbuserrbuser
edited July 2004 in End User
Hello,

Im having difficulty "counting" the number of invoices in an A/R report that
contains a column of invoice numbers as well as blanks. All I want is the
count of invoice numbers, excluding the blanks. I'm sure it's simple but I
now have a headache. Any help would be appreciated.

Susan Yates

Comments

  • rbuserrbuser
    edited July 2004
    Hello Sussan:

    You could limit the query to include invoice numbers that are not blank
    (i.e. INV_NO <> ''). Also, you could group the report by Invoice No where
    Invoice No > '' and run a count on the group.

    Regards,



    Hiram Falcon

    Lady Lynn Development, Inc.

    5532 Woodruff Avenue #109

    Lakewood, CA 90713

    Phone: 562-497-1767

    Fax: 562-938-9182





  • rbuserrbuser
    edited July 2004
    Thank you Hiram but I need the blank lines as they indicate a payment or an
    adjustment and there are figures for these blanks in other columns.

    Susan Yates

  • nicociziknicocizik
    edited July 2004
    Hi Susan,

    Try placing a TppDBCalc component on your report (preferably in a band below
    the Detail band) and assign its data field to the master field (ie. Invoice
    Number) and set its calc type to Count. This will display the count of that
    field on your report. If you need to display this value above the detail
    band, be sure to set the LookAhead property to True.

    --
    Thanks for supporting ReportBuilder! Please vote for ReportBuilder in the
    Delphi Informant Readers Choice awards!

    http://www.delphizine.com/ballot2004/

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.