I had to do something like this too. I ended up having to
Run the report in the IDE to one paper tray. Save off the expr memo field contents. Run in the IDE to the other tray. Save off the expr memo field contents again. Then when I ran the report I had to open the .frx file - plug tray 1 into the EXPR field, change to that printer in set printer to Then do it again for the other printer tray. The deal is just setting printer to is not enough -- the destination gets screwed up unless the same destination is also in the .frx file too... I could dig out the code if you really need it -- it's on another computer. Chet Peter Cushing wrote: > Desmond Lloyd wrote: > >> Good Afternoon, >> >> Need some printing advice: >> >> We have an application in which we will need to print to a specific printer >> using a different paper tray (other than the default). >> Can set the printer (no brainer) >> Next step is to change the paper tray, I can do that by issuing sys(1037), >> but once changed it stays that way meaning that I would have to reissue the >> sys(1037) after printing to the "special tray". >> >> Any advice on how I might programatically change the paper tray and the >> change back? >> >> > Set up a dummy table and report and try printing to this printer using > sys(1037) before the print. Print to one tray, then open the .frx file > and have a look in the EXPR memo to see if it has a line referencing the > tray, then try another tray and have a look in here again. If you have > two different lines then these can be written back to the .frx before > doing a print and you could have a control on a screen to select the output. > > HTH > > Peter > > > [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.
