>Hi Mark
>thanx for the advice, but i have no clue on how to use sql. what i need to do is get a layout like below:
>--------Items Serviced--------
>Make Model Serial#
>------------------------------
>XYZ A123 12345
>ABC B321 98765
>
>--------Parts Used------------
>Qty Part# Desc Price
>------------------------------
>1 67584 Spring 1.25
>2 99495 Lever 9.99
> Parts Total 11.24
>
>-----------Labor--------------
>Date Time Rate Total
>------------------------------
>07/05/00 1hr 25.00 25.00
> Labor Total 25.00
>------------------------------
>
>-----------Description--------
>Disassembled, repaired and (memo field)
>reassembled. Tested working Ok.
>------------------------------
> Invoice Total 36.24
>
>this is far simplified, but gives the idea. each column under each section is a field from a different file. given this and the report designer has only 1 details band or area, i am lost.
>
>i know you guys also have lives to live and any detailed help will be a blessing!
You can put all of your data into a single cursor that has all of your fields you might need, along with some sort of identifier field to tell you which fields you want to print. Then in the report, you can make use of the "Print When" capabilities to control printing the proper output at the right time.
Cursor Structure:
INFOTYPE C 1: "I" for items serviced, "P" for parts used, etc.
MAKE C
MODEL C
SERIAL C
QTY N
PART C
DESCRIP C
PRICE N
LABDATE D
LABTIME C
LABRATE N
WORKDONE M
Now you would have records like this:
INFOTYPE MAKE SERIAL QTY PART DESCRIP PRICE LABDATE LABTIME LABRATE WORKDONE
I XYZ A123
I ABC B321
P 1 67584 Spring 1.25
P 2 99495 Lever 9.99
L 07/05/00 1hr 25.00
Get the picture?