I am trying to create a report with Report Painter
WebFocus 7.6.4 that would show as following

Customer A Customer name
Order 1 Item 1
Item 2
Order 2 Item 1
Item 2
Item 3
Customer B Customer name
Order 1 Item 1
Order 2 Item 1
Item 2
Item 3

Can WebFocus do that ?
If yes
Where can I find document on how to do that ?


Thank you for your help

This message has been edited. Last edited by: YKK,

This is pretty basic stuff.

TABLE FILE CUSTOMER
PRINT ITEM
BY CUSTNO NOPRINT
BY CUSTNAME NOPRINT
BY ORDERNO
ON CUSTNO SUBHEAD
"<CUSTNO  <CUSTNAME"
END

So, in Report Painter, drag all of your fields onto the palette. Make the customer number, name, and order number BY fields. Right-click on the two customer fields and make them not visible. On the insert menu, choose SUBHEAD and drag the the customer fields into the subheading.

You might want to take a look at a Report Painter tutorial manual. You should be able to find one on the doc link in the upper righthand corner of this page.

Let us know if this works for you.

Thank you.