Larry, 3 options that I can think of: I've done something similar with a list of items where before the report is run, I declare a cursor that loops through the detail records and creates a string variable that I then place in my report. Here's a snippet:
DECLARE cursor2 CURSOR FOR SELECT numup,partno,SIZEdesc FROM sizedata WHERE jonum=.whval1 ORDER BY prod# OPEN cursor2 FETCH cursor2 INTO vnumup ivnd1, vpartno ivnd2, vdesc ivnd3 WHILE SQLCODE <> 100 THEN SET VAR vlyout=(.vlyout+' '+.vnumup+'-up '+.vpartno+' '+.vdesc) FETCH cursor2 INTO vnumup ivnd1, vpartno ivnd2, vdesc ivnd3 ENDWHILE You could insert ascii codes for tabs and carriage return if you wanted to format it a certain way. I then just insert to vlyout variable where I want in my report (in a region, set to stretch). Also, Bill Downall demonstrated a way to do something like this at one of the conferences last year. Basically, you create a small report that would be one of your detail sections. In your code, you print the report as an image (OPTION GIF or TIFF) and then place a variable image in your main report where you want that detail to print. You may have to play around with the options for printing GIF or TIFF that would improve the image quality, size etc. Option 3 is... Wait until 7.5. Sub-reports!! Dawn -----Original Message----- From: Larry Wilson [mailto:[EMAIL PROTECTED] Sent: Monday, June 20, 2005 3:27 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Report Question Hello Group: I am looking for ideas on how to print 2 detail sections on a report. I am trying to reproduce an insurance form that lists vehicles added in 1 section and vehicles deleted in another section on the same form. The form is limited to 5 vehicles added and 5 vehicles deleted along with totals for each section. I can reproduce the exact look of the form using page style the problem I am having is in creating the detail sections. I have run into this problem in the past years but I cannot remember what I did to solve it. I am using the rbase 7.1 the latest Update 81. Any help will be greatly appreciated. TIA Larry
