Report Designer

See Also

Use the Report Designer to create and modify reports. When the Report Designer window is active, Visual FoxPro displays the Report menu and the Report Controls toolbar.

To quickly create a simple report layout, choose Quick Report on the Report menu. Quick Report prompts you for input on the fields and layout you want for your report.

For detailed information on using the Report Designer, see Chapter 7, Designing Reports and Labels, in the User's Guide, and the sections "Controlling Report and Label Output" and "Formatting Options for Report Controls" in Chapter 12, Adding Queries and Reports, in the Programmer's Guide.

Window Options

Bands

By default, the Report Designer displays three bands; Page Header, Detail, and Page Footer. A separator bar is located at the bottom of each band. The name of the band type appears on the bar next to a blue arrow, which indicates that the band is above, not below, the bar.

You can add the following bands to your report.

Band Printed Typical Contents
Column Header Once per column Column title
Column Footer Once per column Summary, totals
Group Header Once per group Preface to following data
Group Footer Once per group Calculated values for group data
Title Once per report Title
Date or page number
Company logo
Box around the title
Summary Once per report Grand totals
Text such as Grand Totals

Ruler

The Report Designer has a vertical and horizontal ruler you use to more precisely position objects in the bands. Use the ruler in conjunction with the View menu's Show Position command to help you position objects.

The scale for the ruler is determined by your system measurement settings. You can change from the system default scale (inches or centimeters) to pixels from within Visual FoxPro. If you want to change to the system default, change the measurement setting for your operating system.

To change the ruler scale to pixels

Change this to pixels as follows:

  1. From the Format menu, choose Set Grid Scale. The Set Grid Scale dialog box is displayed.

  2. In the Set Grid Scale dialog box, select Pixels and choose OK.

    The ruler scale is set to pixels, and the position indicator in the status bar (if Show Position is checked on the View menu) also displays positions in pixels.