Michael, Select the relevant records:
Select all ; Name as Name, ; "1" as Record_Type, ; Address as Address, ; Notes as Notes, ; Picture as Picture ; From curFile ; Union all ; Select all ; Name as Name, ; "2" as Record_Type, ; Address as Address, ; Notes as Notes, ; Picture as Picture ; From curFile ; Into cursor curResult ; Order by 1,2 Report form <cReport> In the report set group breaks on Name and Record_Type and force Pagethrow on New Group. Then just drop the relevant fields into the Group Header bands and leave the detail band clear Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 27 April 2007 14:11 To: Profox Subject: VFP9 report question I've got a scanned picture/image file on a record that I need to print "behind" (or on the next page) of a report. Here's the example: Record layout: Name, Address, Notes, Picture I want the first page in my report to be the Name, Address, and Notes. Then 2nd page (which will be a large picture--probably 8x10) should print the guy's picture. Then Page 3 of the report would be Record 2's Name, Address, and Notes; Page 4 would be Record 2's picture, Page 6 would be Record 3's picture, etc. etc. Can I achieve this with VFP9's report writer and how? tia! --Michael -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
