Using reports

Paradox lets you can create a report design and then run the report, which allows you to view the report's data. You can print reports, publish them to various file formats, and deliver reports to others . You can also use reports to create mailing labels or merge report data to create form letters.

In this section, you'll learn about

  creating, opening, and modifying reports
  
  running reports
  
  printing reports
  
  printing report designs
  
  setting printer options
  
  printing to a file
  
  publishing and delivering reports
  
  creating mailing labels and merging data
  
Creating, opening, and modifying reports

You can create a new report by starting with a blank report and customizing it to meet your specifications. You can also create a report by using the Report Expert. The Report Expert simplifies creating a report by leading you through every step in the report design process. You can open a report to view it or to modify its design. Moreover, you can open a form as a report.

To create a blank report

1	Click File  New  Report.

2	Click Blank.

Notes

  When you create a blank report, it is not bound to a table, and it contains only a single page for forms and reports, the report header and footer, page header and footer, and record band for reports.
  
  Buttons, notebooks, and OLE controls are not available in reports.
  
To create a report by using an Expert

1	Click Tools  Experts.

2	Double-click the Report icon.

3	Follow the instructions in the Report Expert.

To view a report

1	Click File  Open  Report.

2	Choose the file and folder where the report is stored.

3	In the Options area, enable the View the report option.

4	Click Open.

Note

  You can apply data from a table that is different from the table currently attached to the selected report by clicking Change table and choosing the file and folder where the table is stored.
  
To modify a report

1	Click File  Open  Report.

2	Choose the file and folder where the report is stored.

3	In the Options area, enable the Edit the report design option.

4	Click Open.

To open a form as a report

1	Click File  Open  Form.

2	Choose the file and folder where the form is stored.

3	In the Options area, enable the Open as a report check box.

4	In the Options area, enable the Edit the report design option.

5	Click Open.

Notes

  When you open a report from a form, the form's layout is inserted into the record band of the report.
  
  If you open a multi-page form as a report, page breaks are inserted at the appropriate places in the record band.
  
Tip

  You can view the report by enabling the View the report option.
  
Running reports

Once you create a report design, you can run the report to view the report's data. You can also run a report that uses a different table's data. You can also base a report on a query or Structured Query Language (SQL) file. For example, you may have designed a report and want to apply the report's layout, colors, and other attributes to another table's data. Instead of designing a new report for the new table, you can open the existing report but apply the new table's data. Opening the report with the new table data automatically creates a report design based on the new table data, but applying the existing report's design attributes. If you plan on running a report using a different table, it is important to note that if you need to make changes to a table, you can only make changes to the master table.

When running a report, you can display a custom menu that you create using ObjectPAL. You can also size the report's window to fit the report's design.

To run a report

  In the report design window, click View  Run report.
  
You can also	

Return to the report design window	Click View  Design report.

Toggle between running a report and designing a report	Press F8.

To run a report that uses a different table

1	Click File  Open  Report.

2	Choose the file and folder where the report is stored.

3	Click Change table.

4	In the Select replacement table dialog box, choose the file and folder where the table is stored.

5	Click OK.

6	In the Open report dialog box, enable the View the report option.

If you want to print the report, enable the Print the report option.

7	Click Open.

Notes

  You receive a warning if a field in the report does not have a corresponding field in the table. The report will open, but any undefined fields are given the name LABEL, and no data displays in them. If the report has calculated fields that reference missing fields, the calculated fields will have invalid expressions and must be redefined with the new table. If this occurs, you need to edit the calculated expression, remove all field references to the original table, and replace those field references with fields from the new table.
  
  Do not use a data model to change a table being used with a report. Although it is possible to add a new table to a data model and to delete the original table from a data model, it will cause all fields in the report to display as undefined, or to be removed, along with any group bands defined from the deleted tables.
  
Tip

  You can choose a saved query or saved Structured Query Language (SQL) file to use in the report.
  
To display a custom menu when running a report

1	In the report design window, click Format  Properties.

2	Click the General tab.

3	Disable the Standard menu check box.

Note

  The standard menu is enabled by default.
  
To size the report window to fit the report's design

1	In the report design window, click Format  Properties.

2	Click the General tab.

3	Enable the Size to fit check box.

Printing reports

After running a report, you can print the report data, and check the report's print history and status. In addition, you can specify various printing options, such as handling overflow, printing a report diagram in color if you have a color printer, and printing text as a graphic.

Paradox lets you print a report even if the data is being shared and another person is making changes to the data. However, when you print a report based on shared data, you run the risk of not printing the most current data. You can lock the report's tables to prevent this from happening.

To print a report

1	In a report, click File  Print.

2	In the Destination area, choose a printer from the Name list box.

3	In the Print range area, enable the Full file option.

If you are printing page numbers, type a value in the Number on first page box to indicate where you want page numbering to begin.

4	In the Copies area, type a value in the Number of copies box.

If you are printing multiple copies, you can collate the pages by enabling the Collate check box.

5	Choose printer settings from the Settings list box.

6	Click Print.

You can also	

Preview a print job	Click Preview.

Print a range of pages	In the Print range area, enable the Pages option. Type a page range in the Pages box.

Print pages in reverse order	In the Copies area, enable the Print in reverse order check box.

Change your printer properties	In the Print dialog box, click the Main tab. Click Properties.

Tip

  You can print with a report open in the report design window by clicking File  Print  Report.
  
To check print history and status

1	In the report, click File  Print.

2	Click the Main tab and click Status.

Tip

  You can check print history and status with a report open in the report design window by clicking File  Print  Report, clicking the Main tab and clicking Status.
  
To choose overflow handling options

1	In a report, click File  Print.

2	Click the Advanced tab.

3	In the Overflow handling area, choose one of the following from the list box:

  Create horizontal overflow pages as needed - prints report data on multiple pages if the data exceeds the page's dimensions
  
  Clip to page width - cuts off any report data that exceeds the page's dimensions
  
Tip

  You can print with a report open in the report design window by clicking File  Print  Report.
  
To print a report diagram in color

1	In a report, click File  Print.

2	Click the Advanced tab.

3	In the Options area, enable the Print in color check box.

Tip

  You can print with a report open in the report design window by clicking File  Print  Report.
  
To print text as a graphic

1	In a report, click File  Print.

2	Click the Advanced tab.

3	In the Options area, enable the Print text as graphics check box.

Tip

  You can print with a report open in the report design window by clicking File  Print  Report.
  
To prevent changes to data when printing a report

1	In the report design window, click Format  Restart options.

2	Enable the Lock tables to prevent data change check box.

Printing report designs

Paradox lets you print a report design. When you print a report design, you print only the bands and the objects contained within them. A report design does not contain report data. To print report data, you must run a report. For more information on running reports, see "Running reports."

To print a report design

1	In the report design window, click File  Print  Design.

2	In the Destination area, choose a printer from the Name list box.

3	In the Print range area, enable the Full file option.

If you are printing page numbers, type a value in the Number on first page box to indicate where you want page numbering to begin.

4	In the Copies area, type a value in the Number of copies box.

If you are printing multiple copies, you can collate the pages by enabling the Collate check box.

5	Choose printer settings from the Settings list box.

6	Click Print.

You can also	

Preview a print job	Click Preview.

Print a range of pages	In the Print range area, enable the Pages option. Type a page range in the Pages box.

Print pages in reverse order	In the Copies area, enable the Print in reverse order check box.

Change your printer properties	In the Print dialog box, click the Main tab. Click Properties.

Setting printer options

Paradox lets you create new printer settings when printing reports. Printer settings allow you to store printing options, such as which printer to use or whether to print graphics in color. You can also modify or delete the settings you create.

To create printer settings

1	Click File  Print.

2	Click Edit settings.

3	Type a name for the new settings in the Name for current settings list box.

4	Choose the new settings from the Settings to save list.

5	Click Add.

To modify printer settings

1	Click File  Print.

2	Click Edit settings.

3	In the Named settings dialog box, choose a setting from the Name for current settings list box.

4	Click Replace.

You can also	

Replace printer settings with system default settings	Enable the Use printer properties from system default check box. Enable the Save current printer properties with setting option.

Retrieve properties from the printer each time the setting is retrieved	Enable the Use printer properties from system default check box. Enable the Retrieve properties from printer each time the setting is retrieved option.

To delete printer settings

1	Click File  Print.

2	Click Edit settings.

3	In the Named settings dialog box, choose a setting from the Settings to save list.

4	Click Delete.

Note

  You can't delete default printer settings.
  
Printing to a file

You can print a report to a file, which allows you to have the report printed by a printing service or transfer it to another computer.

To print to a file

1	In a report, click File  Print.

2	In the Destination area, enable the Print to a file check box.

3	Choose a printer from the Name list box.

4	Click Print.

5	In the Print to file dialog box, choose the drive and folder where you want to save the file.

6	Type a name for the file in the File name box.

7	Click Save.

Note

  To print a report to a file, you must add a printer through the Windows Control Panel and set its output to a file. You must select that printer as the active printer before you print a report.
  
Tip

  In the report design window, click File  Print  Report.
  
Publishing and delivering reports

Paradox lets you publish reports to the following file formats:

  Text (.txt)
  
  WordPerfect 6.0 (.wpd)
  
  Microsoft Word (.doc)
  
  Rich Text Format (RTF)
  
  HTML
  
  AmiPro 3.0
  
  ASCII text
  
  MS Word for Windows 6.0/95 and 97/2000
  
  QuattroPro 6.0
  
  MS Excel 3.0 and 4.0
  
  Lotus 1-2-3 for Windows 4.0
  
You can also deliver a report, which allows others to use the report, but they cannot change the design or source code. When you deliver a report, a copy of the report is created with all of its source code removed. However, buttons and other objects still work exactly as you designed them.

To publish a report

1	Click File  Open  Report.

2	Choose the file and folder where the report is stored.

3	Click File  Publish as, and click one of the following:

  TEXT
  
  RTF
  
  HTML
  
  WPD
  
  DOC
  
  AmiPro document
  
  Quattro Pro spreadsheet (.wb2)
  
  Excel spreadsheet
  
  Lotus 1-2-3 spreadsheet
  
4	Choose the drive and folder where you want to save the report.

5	Type the filename in the Filename text box.

Notes

  A delivered report cannot be opened in the report design window.
  
  When publishing to a Quattro Pro spreadsheet, you are publishing the file to the Quattro Pro 6 (.wb2) file format.
  
To deliver a report

  In the report design window, click Format  Deliver.
  
Notes

  When you deliver a report, it is saved with the .rdl extension.
  
  You can make changes to the original report and then redeliver it. Your code is not lost, because it is protected.
  
Creating mailing labels and merging data

You can use Experts to create mailing labels and merge data. The Mailing Label expert guides you through the process of creating mailing labels for most standard label sizes. You can also use the Merge Expert to merge data from a table into a form letter created in another application, such as WordPerfect.

To create mailing labels by using an Expert

1	Click Tools  Experts.

2	Double-click the Mailing label icon.

3	Follow the instructions in the Label Expert.

To merge data by using an Expert

1	Click Tools  Experts.

2	Click the Merge Expert icon.

3	Follow the instructions in the Merge Expert. 




