John, Yes, you can do it in one report with a little messing about and some "print when..." conditions etc, but you KNOW what will happen. The user will change ONE of the reports by adding something else in and all the initial hard work will be in vain and you'll have to split into two separate reports anyway.
Bite the bullet now and split it - you know it makes sense. <BG> Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John J. Mihaljevic Sent: 24 January 2007 13:36 To: [email protected] Subject: Printing groups conditionally Hi all, I have a report that is going to be sorted one of two ways - either by Order Number or by Machine Number. When it's sorted by Order Number, all the data is just to be printed sequentially with no breaks. But when it's sorted by Machine Number, the users want a break and subtotals by Machine. Is there a way to do this with just one report form? Could I set up the grouping and subtotals but set it up so that those things only print when I'm printing the report by Machine Number? Or do I need to have two separate report forms? Thanks much! John "The difference between a successful person and others is not a lack of strength, not a lack of knowledge, but lack of will." - Vince Lombardi * All mail scanned by Norton AntiVirus. No AV software on your computer? Remove me from your address book, please. * Please respect my privacy. Do not forward my address to anyone else or include me in emails sent to multiple recipients. Use BCC. [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 ** 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.

