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

Sequential nos on reports

edited January 2006 in General
Hi,

I am using ReportBuilder 9 and I need to be able to add a label/text field
that begins with a particular number and continues sequentially for every
record in my database.

Would you please walk me through how I can achieve this. I'm fairly new to
Reportbuilder.

Thanks in advance

Comments

  • edited January 2006
    Hi Silvester,

    Two options...

    1. If you would like to start at "1", you can place a TppDBCalc inside the
    Detail Band and set its DBCalcType to dcCount. This will count the detail
    bands starting at 1.

    2. If you would like to start from a different number, you can place a
    TppVariable inside the detail band and set its type to Integer. Then using
    the OnCalc event of the variable, increment its value. This way each time
    the event fires, the value will increment.

    something like... Value := Value + 1;

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited January 2006
    Thanks Nico,

    I'm going with your option #2.

    So I went to my report..
    clicked on variable and dropped the variable onto my detail line
    changed the variable to integer
    right clicked on the variable and went to Calculations
    and I'm stuck

    I cannot find the onCalc event. Am I doing this right ?

  • edited January 2006
    Hi Silvester,

    Are you using a registered version of ReportBuilder or an application with
    ReportBuilder built-in? The OnCalc event is available in Delphi as an event
    associated with the TppVariable component. You can access it from the
    Delphi object inspector.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited January 2006
    Hi Nico,

    You're right. I'm using Membership Plus 2005 Deluxe
    http://www.quickverse.com/shopfiles/product_details.asp?ID=43042 which has
    Reportbuilder 9 built-in.

    I am guessing this is ReportBuilder 9 Standard Edition. Would you be able to
    assist on how to get this done on this report ?

    Thanks


  • edited January 2006
    -----------------------------------------
    Article: End-User Tech Support
    -----------------------------------------

    Please understand that Digital Metaphors can only provide tech support to
    the Delphi developers that purchase ReportBuilder. Digital Metaphors
    receives no distribution royalties from Delphi developers that embed
    end-user reporting solutions in their applications. It is the responsibility
    of the software publishers that sold you the product to provide you with
    tech support.

    There is an end-user tutorial called Learning ReportBuilder that can be
    downloaded from our web site for free. See the following article for more
    infomation.

    --------------------------------
    Article: Learning ReportBuilder
    --------------------------------

    Learning ReportBuilder is a complete learning system designed to teach end
    users how to build a range of reports. This system includes a 125-page PDF
    file, a stand-alone application complete with a database, and a help file.
    The PDF file is comprised of a series of tutorials that step end users
    through the process of building reports as simple as a table listing and as
    complex as crosstabs. The tutorials also introduce conceptual aspects of
    report building along the way. The application is used in conjunction with
    the tutorials so that the learning experience is interactive. The end user
    just prints out the PDF file, runs the application, and learns
    ReportBuilder. The help file is accessible from the application, so all
    three tools work together to provide a seamless learning environment.

    Learning ReportBuilder installs into C:\Program Files\LearnReportBuilder.
    When the system has successfully installed, a complete set of instructions
    appears in the form of a 'ReadMe' doc, so the end user knows just what to do
    upon installation.

    - Download Learning ReportBuilder

    http://www.digital-metaphors.com/LearnRB/LearnRB.exe

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited January 2006
    Thanks Nico,
    For your help and for a great product

This discussion has been closed.