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] ========================================
