Through years of experience I’ve noticed that what displays on the screen is not always what Paradox prints. There’s simply too many things that vary from PC workstation to printer in every office. Here’s some things I’ve tried.
1. If you encounter page-breaking problems when printing reports, there are three things that can be tried.
a. Make sure you’re reviewing the report on screen, then close out of it when it looks good. Right-click on the report object from the Project Viewer, then select the “Print” option to send the output directly to a printer.
b. Or try repeating the previous step, but send the output to a different printer.
c. SOME report objects convert very well to a Word Perfect (word processing) document. Once you have it successfully converted I usually spiff it up a little and know what I print will look pretty much like Print Preview. To do this:
- Run the report and review it on screen.
- If the report looks okay, choose “File”, “Publish As”, and specify “WPD...”.
- Specify P:\Payroll\Reports\ as the folder and choose a file name (“Example Report.wpd”), then click the “Save” button.
- The Paradox version will be converted and saved as a Word Perfect document. (Example Report.WPD).
- This file can then be opened from Word Perfect.
- The .WPD version doesn’t always exactly match the Paradox format, but it usually page breaks OK when sent to a printer.
d. Sometimes I use this conversion process deliberately for other reasons.
- When I have a smaller report that only uses the left half of a page (1 - 4 inches) I publish it to Word Perfect. The page headers and footers are separate from the main text area so I can then use an “Edit”, “Select All” to format the text into newspaper columns. This reduces the number of pages by half. If I duplex the printing, it reduces the number of pages again by half.
- To help my manager create spreadsheet summaries, I first use a Paradox report with NO headers, just columns of data that are summed up based on a group band (such as Employee ID, Dept No, etc.) Once published to Word Perfect, I can do an “Edit”, and “Select All” and paste the totalled data into a Quattro Pro spreadsheet. From there she can sort it by Employee ID, Name, Date Hired, or whatever else she needs.
2. Creating your own lists by copying smaller tables to spreadsheets.
a. Start up Quattro Pro with a blank spreadsheet.
b. From Paradox, open any table.
c. Apply a filter to display only specific rows, or leave the filter criteria blank to copy all rows.
d. Click anywhere in the rows you see, then choose “Edit” and “Select All...”.
e. Copy the information to the clipboard.
f. Move over to the Quattro Pro window and paste the information into the spreadsheet, starting from cell A1 (or any other upper left corner).
g. Update, sort, save, and print the spreadsheet as needed.
1. If you encounter page-breaking problems when printing reports, there are three things that can be tried.
a. Make sure you’re reviewing the report on screen, then close out of it when it looks good. Right-click on the report object from the Project Viewer, then select the “Print” option to send the output directly to a printer.
b. Or try repeating the previous step, but send the output to a different printer.
c. SOME report objects convert very well to a Word Perfect (word processing) document. Once you have it successfully converted I usually spiff it up a little and know what I print will look pretty much like Print Preview. To do this:
- Run the report and review it on screen.
- If the report looks okay, choose “File”, “Publish As”, and specify “WPD...”.
- Specify P:\Payroll\Reports\ as the folder and choose a file name (“Example Report.wpd”), then click the “Save” button.
- The Paradox version will be converted and saved as a Word Perfect document. (Example Report.WPD).
- This file can then be opened from Word Perfect.
- The .WPD version doesn’t always exactly match the Paradox format, but it usually page breaks OK when sent to a printer.
d. Sometimes I use this conversion process deliberately for other reasons.
- When I have a smaller report that only uses the left half of a page (1 - 4 inches) I publish it to Word Perfect. The page headers and footers are separate from the main text area so I can then use an “Edit”, “Select All” to format the text into newspaper columns. This reduces the number of pages by half. If I duplex the printing, it reduces the number of pages again by half.
- To help my manager create spreadsheet summaries, I first use a Paradox report with NO headers, just columns of data that are summed up based on a group band (such as Employee ID, Dept No, etc.) Once published to Word Perfect, I can do an “Edit”, and “Select All” and paste the totalled data into a Quattro Pro spreadsheet. From there she can sort it by Employee ID, Name, Date Hired, or whatever else she needs.
2. Creating your own lists by copying smaller tables to spreadsheets.
a. Start up Quattro Pro with a blank spreadsheet.
b. From Paradox, open any table.
c. Apply a filter to display only specific rows, or leave the filter criteria blank to copy all rows.
d. Click anywhere in the rows you see, then choose “Edit” and “Select All...”.
e. Copy the information to the clipboard.
f. Move over to the Quattro Pro window and paste the information into the spreadsheet, starting from cell A1 (or any other upper left corner).
g. Update, sort, save, and print the spreadsheet as needed.