CRM Project Summary Layout Tab

Use the Layout tab to set the font, margins, orientation, page size, and other formatting options for the report. (For mailing labels, formatting options are on the General tab instead of the Layout tab.)

The default margins for a report are one of the following:

  • The DPS default margins
  • The default margins set up for you on the Users form in Settings
  • The default margins set on the Reporting tab of the My Preferences dialog box
  • The margins specified in the report file

You can specify different margins for a report, no matter what the default source is.

Document Properties

This section consists of fields that enable you to select the unit of measurement, page size, margins, and orientation of the report.

Field Description
Unit of Measure

Select the unit of measure, inches or millimeters, to use for the measurement fields on the report :

  • Top, Bottom, Left, and Right margin fields.
  • Page Orientation radio buttons
  • Dimension Width and Height fields on the Layout tab.
  • Left margin for first column and Width fields on the Columns tab.
  • Left margin indent for groups on the Sorting/Grouping tab.
  • Height, Width, Top, and Left fields on the Graph tab.

When you switch from one unit of measure to the other, the measurements that are currently entered or displayed in the measurement fields are automatically converted to the new unit of measure (1 inch = 25.4 millimeter).

Show Condensed View for Dashparts Use this toggle to show or hide a condensed view for dashparts.
Top Margin Enter the margin for the top of the page. Use the unit of measure (inches or millimeters) that you entered in the Unit of Measure field on this tab. If your unit of measure is inches, use decimals for fractions of an inch (for example, 0.75 or 1.20).
Bottom Margin Enter the margin for the bottom of the page. Use the unit of measure (inches or millimeters) that you entered in the Unit of Measure field on this tab. If your unit of measure is inches, use decimals for fractions of an inch (for example, 0.75 or 1.20).
Left Margin Enter the margin for the left edge of the page. Use the unit of measure (inches or millimeters) that you entered in the Unit of Measure field on this tab. If your unit of measure is inches, use decimals for fractions of an inch (for example, 0.75 or 1.20).
Right Margin Enter the margin for the right edge of the page. Use the unit of measure (inches or millimeters) that you entered in the Unit of Measure field on this tab. If your unit of measure is inches, use decimals for fractions of an inch (for example, 0.75 or 1.20).
Page Orientation The Orientation option is available only for reports for which you can select columns. Select one of the following options for the orientation of the report on the printed page:
  • Automatic Based on the Report Columns: DPS selects the most appropriate orientation based on the columns you select for the report, the page size, and the margins. If the columns fit across the narrow dimension of the page, DPS uses portrait orientation. If the columns do not fit across the narrow dimension, DPS uses the landscape orientation.
  • Portrait: Select this option if you always want the long dimension of the page to be vertical.
  • Landscape: Select this option if you always want the long dimension of the page to be horizontal.
Page Size Select the page size for the report. The width and height of the page size that you select in this field display in the Dimension Width and Height fields below the Page Size field.

If you select Custom in as the page size, you can enter the width and height that you want.

Width and Height Fields The Width and Height fields display the width and height of the page size that you select in the Size field. The measurements display in either inches or millimeters based on which one you selected in the Unit of Measure field on this tab.

Font and Border

Field Description
Font

Use this option to change the font for the report. The default font for a report is one of the following:

  • The default font (Arial)
  • The default font set up for your username and password in the Users form in Settings
  • The default font that you selected on the Reporting tab of the My Preferences dialog box
Alternate Row Color Some reports are easier to read with alternating colored rows. You can opt to display alternating row colors for the report grid in a couple of ways. If you know the RGB color value of the alternate row that you wish to use, you can it in the field. Otherwise, you can click in the field to display the RGB color tool, then in the lower left of the color field hover and click on the + icon and drag it to a color of your choice. The RGB values and the color are displayed in the field. Use the slider on the color bar on the right to view and select values within that color range.
Show Border Lines on Report To generate the report with border lines separating sections and data fields, select this check box. Some reports are easier to read with border lines displayed.

Header and Footer

Field Description
Override Heading Dates

By default, DPS uses the starting and ending dates for the accounting period that you selected when you logged in to DPS.

To specify different period dates for the report heading, select Override Heading Dates and enter the dates that you want in the For the Period start and end date fields.

For the Period

This field displays the start and end date range for the period.

  • To change the start date for the accounting period, click and select a calendar date.
  • To change end date for the accounting period, click to and select a calendar date.
Heading background color Select a background color for the report row that displays column headings. Use this option to make the headings stand out from the rest of the report data, for example.
Text Formatting Tool Use this tool to format the reports header and footer information.
Report Footer Enter the text for the report footer. Do not remove the [version] - [options] portion of the footer. For more formatting options, click Edit to open the Text Editor.
Show grid lines on report To generate the report with grid lines separating data fields, select this check box. Some reports are easier to read with grid lines displayed.
Override regional settings If you want to use formatting for numbers or currency amounts for a report that is different than the default formatting in Regional and Language Options in the Windows Control Panel, select the Override regional settings check box and select the culture associated with the format that you want from the drop-down list. If you select a different culture, DPS automatically displays the default formats associated with that culture in the Number, Currency, and Date fields.

If you do not select Override regional settings, the format settings are the settings specified for your computer in Regional and Language Options in the Windows Control Panel.

Number

This field displays the default format for non-currency numbers for the report. This format is the default format for each numeric field on the report.

  • To change the default format, click to open the Format Number dialog box.
  • To change the format for an individual report column, go to the Columns tab, click the Format grid column for the report column, and click to open the Format Number dialog box.
Currency

This field displays the default format for currency amounts for the report. This format is the default format for each currency field on the report.

  • To change the default format, click to open the Format Currency dialog box.
  • To change the format for an individual report column, go to the Columns tab, click the Format grid column for the report column, and click to open the Format Currency dialog box.
Date

This field displays the default date and time format for the report. This format is the default format for each date or date-and-time field on the report.

  • To change the default format, click to open the Format Date dialog box.
  • To change the format for an individual date column, go to the Columns tab, click the Format grid column for the report column, and click to open the Format Date dialog box.
Report language

If you use multiple languages, this field displays the language in which the report will be generated. For standard reports, this field displays the language that you specified when you logged in. For favorite reports or reports for which you select a saved set of options, it displays the language that was active when you created the favorite or the options set.

You cannot use this field to change the language. To generate a report in a different language, do one of the following:

  • Select that language when you log in and then generate the report. (This only applies to standard reports. For favorite reports, the language specified when you created the favorite is used, whether or not it matches the language you selected when you logged in.)
  • Select a set of saved options that you created for that language.
  • Select a favorite version of the report that you created for that language.

Number, Date, and HTML Formatting

Field Description
Default Format The default format settings are the settings specified for your computer in Regional and Language Options in the Windows Control Panel. If you want to use different language and regional formatting for numbers or currency amounts for a report, select the culture associated with the format that you want from the Default Format drop-down list. If you select a different culture, DPS automatically displays the default formats associated with that culture in the Number, Currency, and Date fields.
HTML Formatting This check box applies only to memo fields. Select this check box if you want to apply HTML formatting (bold, underlining, colors, and so on) to the contents of all memo fields on a report based on the formatting applied when the text was originally entered in each memo field.

If you do not want to apply HTML formatting for all memo fields, clear this check box to print or display the text in all memo fields without any special formatting. You may want to do this if, for example, the formatting was applied inconsistently during data entry or the formatting is unsatisfactory for some other reason.

Instead of turning on or off HTML formatting for all memo fields on a report, you can turn on or off HTML formatting individually for memo fields. In the grid on the Columns tab in a report's options dialog box, select a memo field and clear the HTML Formatting check box in the grid for it.

Number Setting Sample This field displays the default format for each numeric field on the report. Click to open the Format Number dialog box.
Currency Setting Sample This field displays the default format for each currency field on the report. Click to open the Format Currency dialog box.
Date/Time Setting Sample This field displays the default format for each date and/or time field on the report. Click to open the Format Date/Time dialog box.
Use Dashpart Report Layout

Select this check box to generate the report using the special formatting applied when you display a report as a dashpart on your Dashboard.

The following are the main formatting characteristics:

  • The report header information is displayed in the lower-left corner of the final report page.
  • The default font size is applied to the report title, replacing the larger font that is normally used.
  • Page headers and footers are not displayed.

You normally do not use this option except when you want to generate a report as an archive report and you want to display that archive report as a dashpart. When DPS displays an archive report as a dashpart, it does not actually run the report, so it cannot automatically apply the dashpart report layout as it does with other reports. As a result, you must use this option when you generate the archive report if you want the normal dashpart report layout.