Thanks Jim - very cool!! David
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Jim Schmitt" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, March 24, 2005 8:36 PM Subject: [RBG7-L] - Re: Printer options > David: > > Actually, David, its not anything built into R:Base, but just a very useful > thing I have been doing for some time now. This is useful if you have a > screen for various report options, such as beg date and end date, beg > account and end account, etc., etc. Place the variables for the various > report options on the screen, and then place a 'PRINT' button as the last > field <symmetrically, to print the report>. On the last of the option > fields <before the print button>, simply have an eep that does the following: > - Develop the count of records by doing a 'select count (field name) ' > based on operator entered parameters. > - Run at least one page to get the number of detail lines per page (this > will vary based on heading depth, and font size). > - Develop pages (count of records / details per page), > - Do a 'MOD' command to determine if any leftover (if so, add 1 to page > count). > NOW, if you have breaks <as most of us do>, then you will have to determine > the number of breaks (x number of lines in break), etc., and add that into > the equation also. Have a text variable, such as 'ESTIMATED PAGES', and a > display only variable, such as VF_COUNT, and then from the eep, recalc the > vars, and display the count <possibly in RED so that it stands out>. > If the operator looks at the count, before pressing the 'PRINT' button, > she/he can tell if the report is 5 pages or 500 pages. > Once you add this, most operators will love it.......and some even ask 'How > did it know how many pages will be printed ?. > Just tell them it's R:MAGIC. HA. > > Have a good holiday. > > Jim > > > > > At 08:51 AM 3/24/05 -0500, you wrote: > > > >Jim > > > >Hmmm, I sure know how to show the number of records selected, but what > >little trick have I missed that shows the number of pages to be printed > >before it prints? > > > > > >David Blocker > >[EMAIL PROTECTED] > >781-784-1919 > >Fax: 781-784-1860 > >Cell: 339-206-0261 > >----- Original Message ----- > >From: "Jim Schmitt" <[EMAIL PROTECTED]> > >To: "RBG7-L Mailing List" <[email protected]> > >Sent: Wednesday, March 23, 2005 7:04 PM > >Subject: [RBG7-L] - Re: Printer options > > > > > >> Javier: > >> > >> I agree with your approach and do it that way most of the time. Another > >> good thing to do, is to display on a input screen the, number of records > >> selected, and the number of pages <to be printed> before bringing the > >> report up to the screen. Just another tool in our 7.x arsenal. > >> > >> Jim > >> > >> At 03:34 PM 3/23/05 -0600, you wrote: > >> > > >> >I have also opted for this approach, as user now want to see the reports > >on > >> >the screen before printing then they can direct the output to wherever > >they > >> >want, be that printer or file. Under the old method, we have had > >instances > >> >in the past where several-hundred page reports were printed only to find > >out > >> >that it was not what they wanted. This approach does not necessarily > >> >eliminates the problem but it diminishes it quite a bit... > >> >Javier, > >> > > >> >Javier Valencia, PE > >> >President > >> >Valencia Technology Group, L.L.C. > >> >14315 S. Twilight Ln, Suite #14 > >> >Olathe, Kansas 66062-4578 > >> >Office (913)829-0888 > >> >Fax (913)649-2904 > >> >Cell (913)915-3137 > >> >================================================ > >> >Attention: > >> >The information contained in this message and or attachments is intended > >> >only for the person or entity to which it is addressed and may contain > >> >confidential and/or privileged material. Any review, retransmission, > >> >dissemination or other use of, or taking of any action in reliance upon, > >> >this information by persons or entities other than the intended recipient > >> >is prohibited. If you received this in error, please contact the sender > >and > >> >delete the material from all system and destroy all copies. > >> >====================================================== > >> > > >> >-----Original Message----- > >> >From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Albert Berry > >> >Sent: Wednesday, March 23, 2005 3:05 PM > >> >To: RBG7-L Mailing List > >> >Subject: [RBG7-L] - Re: Printer options > >> > > >> >Marc, I do a print statement like this: > >> > > >> >PRINT <report> OPTION SCREEN WINDOW_STATE MAXIMIZED > >> > > >> >The user can then do all the Windows print functions he feels like, > >> >including just clicking the > >> >[x] > >> > > >> > > >> > > >> >--- Marc <[EMAIL PROTECTED]> wrote: > >> >> Hi all > >> >> > >> >> Since the list is slow today I will start it > >> >> off with a question. You can always count > >> >> on me to have a question. > >> >> > >> >> I was using a Choose list box for my users > >> >> to select the printer output. Such as > >> >> Printer, Lpt1, Screen.... > >> >> Then set output to Voutput > >> >> Print Report .... > >> >> out screen > >> >> > >> >> I was wondering... is there a better way > >> >> besides using a bunch of Choose statements. > >> >> > >> >> I do not think I will need all of the options we > >> >> have with 7.1, mostly Printer, LPT1, Screen, > >> >> PDF, File and maybe another one down the > >> >> road. > >> >> > >> >> Thanks > >> >> Marc > >> >> > >> >> > >> > > >> >Albert Berry > >> >Management Consultant > >> >RR2 - 1252 Ponderosa Drive > >> >Sparwood BC, V0B 2G2 > >> >Canada > >> >(250) 425-5806 > >> >(250) 425-7259 > >> >(708) 575-3952 (fax) > >> >[EMAIL PROTECTED] > >> > > >> ======================================== > >> Jim Schmitt > >> Ohio Software Services > >> 2211 Lake Club Drive > >> Columbus, Oh 43232 > >> Phone 1-614-863-1850 > >> Fax 1-614-863-0325 > >> E-mail [EMAIL PROTECTED] > >> ======================================== > >> > >> > > > ======================================== > Jim Schmitt > Ohio Software Services > 2211 Lake Club Drive > Columbus, Oh 43232 > Phone 1-614-863-1850 > Fax 1-614-863-0325 > E-mail [EMAIL PROTECTED] > ======================================== > >
