Consultor Eletrônico

How to display FIRST ORDER OF CUSTOMER in Report Builder

Report Builder-- How to display 'first order of customer'.

First implement the join for order of customer.

You cannot change the join so that only the first order
record of customer is printed but you can design the report
so that all you see is the first order record of customer.
The simplest thing to do is to specify cust-num as the level
1 sort-group field and order-date (or order-num) as the
level 2 sort-group field. This is done using the SORT button
in Report Builder.

Then place the order fields that you want to print into a
cust-num group header. You do this by creating a bandline
with the CREATE menu. The type of bandline in this example
is called 1GH cust-num (for cust-num group header).

Now when you do the print preview you will see only the
first order record of the customer.


Progress Software Technical Support Note # 13870