Working with Reports

From Morfikwiki.com

Figure 1 shows a picture of a blank Report as viewed in the Report designer.

Figure 2 shows a picture of the Report Designer within the context of the entire Morfik workspace.

Contents 1 Frequently used Properties 1.1 DataSource 1.2 Parameters 2 Other Properties 2.1 BackgndImage 2.2 BottomMargin 2.3 ColumnCount 2.4 ColumnHeight 2.5 ColumnLayout 2.6 ColumnWidth 2.7 Hint 2.8 Font 2.9 LeftMargin 2.10 PageFooterOption 2.11 PageHeaderOption 2.12 PageHeight 2.13 PageOrientation 2.14 PageSize 2.15 PageWidth 2.16 RightMargin 2.17 RowSpacing 2.18 SQLFilter 2.19 TopMargin 2.20 Width 3 Events 3.1 OnAfterExecute 3.2 OnBeforeExecute 3.3 OnCreate 3.4 OnDestroy 4 See also

[edit] Frequently used Properties

The following is a list of the most commonly used properties of Reports with a short description of their function.

[edit] DataSource

The DataSource property specifies the Table or Query containing the data to be presented in the Report.

[edit] Parameters

The Parameters property is edited by means of a dialog that lists the following:

• system parameters: these parameters are managed by the Morfik system, and cannot be modified
• query parameters: if the Report's DataSource is a parametric Query, its parameters will be listed here; their default values may be modified
• custom parameters: the developer may define additional parameters to be used by the Report

[edit] Other Properties

The following is a list of the less commonly used properties of Reports with a short description of their function.

[edit] BackgndImage

Set the BackgndImage property if you want to display a graphic behind the Report.

[edit] BottomMargin

The BottomMargin property specifies the height of a region along the bottom of each page where nothing may be printed.

[edit] ColumnCount

[edit] ColumnHeight

[edit] ColumnLayout

[edit] ColumnWidth

[edit] Hint

The Hint property has no effect in Reports.

[edit] Font

The Font property has no effect for Reports; set the Font property of the Report's controls instead.

[edit] LeftMargin

The LeftMargin property specifies the width of a region along the left of each page where nothing may be printed.

[edit] PageFooterOption

The PageFooterOption specifies on which pages to print the page footer:

• poAllPages — on every page
• poNotWithReportFooter — on every page except that containing the report footer
• poNotWithReportHeader — on every page except that containing the report header
• poNotWithReportHeaderFooter — on every page except those containing the report header and footer

[edit] PageHeaderOption

The PageHeaderOption specifies on which pages to print the page header:

• poAllPages — on every page
• poNotWithReportFooter — on every page except that containing the report footer
• poNotWithReportHeader — on every page except that containing the report header
• poNotWithReportHeaderFooter — on every page except those containing the report header and footer

[edit] PageHeight

The PageHeight property specifies the height of the physical page.

[edit] PageOrientation

The PageOrientation property specifies whether to align the vertical dimension of the Report with the longer (portrait) or shorter (landscape) dimension of the printed page.

[edit] PageSize

The PageSize property specifies the paper size to use. Note: if your paper size is not listed, choose psCustom, then set the PageWidth and PageHeight properties.

[edit] PageWidth

The PageWidth property specifies the width of the physical page.

[edit] RightMargin

The RightMargin property specifies the width of a region along the right of each page where nothing may be printed.

[edit] RowSpacing

[edit] SQLFilter

The SQLFilter property may be used to limit the records displayed in the Report to those matching certain criteria. Use the same syntax as you would use in the WHERE clause of an SQL statement. For example, to display only those records where Field1 lies between 3 and 5, set the SQLFilter property as follows:

"Field1" BETWEEN 3 AND 5

[edit] TopMargin

The TopMargin property specifies the height of a region along the top of each page where nothing may be printed.

[edit] Width

The Width property specifies the horizontal extent of the Report. Note: if Width > PageWidth - LeftMargin - RightMargin, the Report's content may be cropped.

[edit] Events

[edit] OnAfterExecute

The OnAfterExecute event occurs after the .pdf file has been generated by the server side of the XApp.

[edit] OnBeforeExecute

The OnBeforeExecute event occurs before the .pdf file is generated by the server side of the XApp.

[edit] OnCreate

The OnCreate event does not occur for Reports.

[edit] OnDestroy

The OnDestroy event does not occur for Reports.

[edit] See also