I set this page up at first in pagemode but I needed it in a PDF format. http://www.dean-med.pitt.edu/DeptAdmin/SrElective/FSURG.PDF <http://www.dean-med.pitt.edu/DeptAdmin/SrElective/FSURG.PDF> The data being put into each of these columns is actually coming from 4 different databases. Internation, Visiting and current Med Students and grades. This has all the courses for 2 years. http://www.dean-med.pitt.edu/DeptAdmin/SrElective/SrElectiveMenu.html <http://www.dean-med.pitt.edu/DeptAdmin/SrElective/SrElectiveMenu.html> I created a Temporary Table and placed everything in the table. All the columns are text. I add the courseid to each row and then set the report to break on courseid. The only user input that is need is to set what course and classyear to run or run them for a given class. I'm also in the process of converting all my remaining pagemode reports in windows reports using temp tables. Anyone that wants the code let me know and I'll be glad to send it to you. Buddy
-----Original Message----- From: Javier Valencia [mailto:[EMAIL PROTECTED]] Sent: Wed 2/12/2003 3:10 PM To: RBASE-L Mailing List Cc: Subject: [RBASE-L] - RE: Pagemode in Windows Brad, Emmitt: It is not as easy as it sounds. Like Karen I have one monster report that uses data from several files and does a lot of on the fly calculations and conditional printing based on run time and static values. I tried many times to use the "temporary table" approach and I just could not get it to work. By its own nature the report generator is designed for repetitive data that can be broken into subsets (break headers and footers, detail section, etc) with each subset generally sharing similar information and common formatting, this is true for the majority of (but not necessarily all) database reports. Occasionally, there are reports that do not conform to this norm, such as those in which the detail line and/or headers/footers are almost separate and different report for each record; for these occasions, PAGEMODE is the only option short of using external tools (Crystal Reports, VB programming). Also, don't forget that in Window, you really cannot print more than one report in one page as it will always place a page feed at the end of each report, and if you write the report to a file, you loose all your formatting (unless you use Acrobat Distiller). Hopefully, when "reports within reports" becomes available (I am keeping my fingers crossed), all these issues will become moot; until then, in some extreme cases PAGEMODE is not only a good solution but the only solution available within R:Base. Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ]On Behalf Of Brad Davidson Sent: Wednesday, February 12, 2003 1:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Pagemode in Windows .... Just to jump on the wagon, heartily concur in this method of DOS to Windows reporting. As we have a plethora of DOS reports now being converted via this method to take advantage of Windows Rbase 6.5++ and eventually ver. 7.0, we find this the best course in efficiency. Regards, Brad Emmitt Dove wrote: > Karen, > > If you are running Windows R:Base, the best thing I've found is to do is this: > > 1. Leave all your code in place, but instead of fooling around > with headers, footers, etc., and writing to the file, create a temporary > table and insert rows to that table containing the data (detail) lines of > the report. > 2. Now build a Windows report based on the temporary table with > all the formatting your heart desires. > > This solution retains the logic in your PAGEMODE report while taking > advantage of the Windows formatting. > > Emmitt Dove > Manager, DairyPak Business Systems > Blue Ridge Paper Products, Inc. > 40 Lindeman Drive > Trumbull, CT 06611 > (203) 673-2231 > [EMAIL PROTECTED] > [EMAIL PROTECTED]
