Dick,
I want to thank you for your suggestion. You got me thinking about using a cursor to perform what I wanted. What I ended up doing is creating a temp table with just the Control# of the bleacher orders. I then use the cursor to print the two reports for those orders, one at a time. After those are printed, I then print the packing lists for the rest of the orders. IT worked to screen so now I will see how long this takes. I am just trying to save the office personnel time in matching reports for the orders. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Tuesday, January 11, 2011 11:40 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: sub report closer to working Jim: We have exactly the same situation. Just build 2 reports identical except for the sub report. Use a variable to check the report data before printing and direct to the right report. Easy Dick Fey Carpet Broker Inc On 1/11/2011 10:48 AM, Jim Belisle wrote: Karen, Thanks for the reply. I will continue to plug away when I get back. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, January 11, 2011 10:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: sub report closer to working By "field footer" do you mean "break footer"? I'm not sure that subreports would be smart enough to print for only a specific break footer value.. At least I've never tried it that way. Karen Is the best way to address this with compid? The sup report is in the field footer for the order number. James Belisle
