Previous Topic

Next Topic

Report Designer Report Properties

Reports have bands and components, and also have their own properties. To access the Report properties from the Design Window, click outside the design area, or select the Report from the drop down option. You can also click ReturnToParent Return to Parent (Shift+Esc) until you return to the Report property.

Report properties default from the Report Preferences.

Report Properties

AfterQuery

Code that executes immediately after the SQL Query is run, see MaxBasic.

BeforeReport

Code that executes before the report is started for initialising variables used elsewhere in the report, see MaxBasic.

Comment

You can enter documentation or comments with no effect on the generation of the report.

Font

Determines the font of the printed output. Click Open Font Dialog (F2) to select the font, style, size and characteristics. The purpose of setting a font for a report is that all bands that have the ParentFont property set to True will use the reports font. This saves having to individually set the font for each band (and ultimately each component on each band). You can change the font by clicking the font buttons on the toolbar.

MarginBottom MarginLeft MarginRight MarginTop

Set margins for the report (millimetres). The margins are shown in the Design Window as red dashed lines. You can place components outside the margins and they will print if within the printable area of the printer. Margins are useful for aligning components using right-click. If the margins are outside the printable area, they appear in the Design Window at the maximum printable area for the printer.

ModifiedDateTime

ModifiedUser

Updated each time the Report design is saved.

Orientation

Select doPortrait or doLandscape for portrait or landscape orientation.

Report.Orientation property can be set from BeforeReport code allowing you to switch between Portrait and Landscape on the fly.

Report.Orientation = 0 gives Portrait
Report.Orientation = 1 gives Landscape.

Page

To set the page size for this report design, click Narrative Open Page Setup (F2). Set a value other than the Default Paper Size when designing reports to print on non-standard size pre-printed forms, for example, 8½" continuous invoice forms. When the report is run, Accredo will attempt to select the required paper size - if the printer being used has support for that paper size (it may not if the report is run on a different printer from the one used at design time).

PartCount

PartCount sets the number of copies of the form or report to be generated. This is useful if you want to print a Customer copy and an Office copy. For example if PartCount is set to 2, two copies of each document are printed.

This can also be set using MaxBasic code, with the PartCount global variable. The PartNumber function can be used in code to show different information on different parts.

For an example of using the PartCount variable, see IN Tutorial: Add Watermarked Second Page to Invoice.

PFD Image Max Dpi

Set the maximum Dpi (Dots per inch) for images in report pdf files. Defaults from the Report Preferences. Picture boxes in report pfd files will recalculate the dpi for images to match this setting.

Report Title

Click Narrative Open Narrative Editor (F2) to enter the report title. This value is accessible using the MaxBasic ReportTitle function.

ReportVersion

Shows the report version number.

ShortName

A filename to be used as the default filename or worksheet when the printing destination is Disk File or Excel Worksheet.

Note: Assigning to the ShortName in code will not change the filename when printing to Diskfile, however it may be assigned to change the current Worksheet name when printing to Excel or in Excel format. For example when setting ForceNewWorksheet True for a band assign to Report.ShortName in the AfterBand code to set the Worksheet name.

Users

Lists users with access to the report. See Report Designer - User List.

See Also

Report Designer

Book Contents

Book Index