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

Grouping on Custom Fields

edited February 2003 in End User
Can anyone help with this?

I am producing production tracking labels for our manufacturing facility to
ensure that certain items are bundled together for transportation. Normally
this is not a problem as there are usually only single item in any
particular (part) order, and therefore I only need to print One label.
Occasionally, however the Item Qty is greater than 1. In these cases I need
to print a label for each of the (qty) items.

My plan is to use a Group based on a custom field and use the GetBreakValue
event to loop me round for the additional labels.

My problem is that I cannot find anything in either the RBuilder or RAP help
files, the Developer documentation or the End-User documentation, nor does
there do not appear to be any examples in the Samples directories!

I am sure that this is a fairly simple problem to fix if only I could find
some pointers to get me started.

I am using an End-User reporting system that is built into our Order
Processing system (supplied by a 3rd party) so cannot create any pass-thru
code to help. I do have RBuilder 7 Enterprise installed on my development
PC.

Any help much appreciated.

TIA

P A Bennett
Dip.Comp(Open). MIAP.

Comments

  • edited February 2003
    I used the 'reservat' table located in the DBDEMOS database and created
    repeating detail bands based on the number of tickets each person bought

    using the 'BandsPerRecord' property. The code in RAP to do this was created
    in the 'DetailBand BeforePrint' event and looked like the following:

    procedure BeforePrint(Sender: TObject);
    begin
    Report.Detail.BandsPerRecord := reservat['NumTickets'];
    end;


    --
    Best Regards,

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