Module Report – Profit Tiger Systems Help Documentation

January 17, 2017

Limit the Number of Records per Page

To add a parameter to the report, in the Field List, right-click the Parameters section, and in the invoked menu, choose Add Parameter.

Select the parameter, and in the Property Grid, set its Description to Rows per Page:, Parameter Type to Int32 and (Name) to rowsNumber.

From the Toolbox, drop the Page Break control onto the report’s Detail band and place it at the top of the detail table.

For the created control, set the Visible property to No, and for its Formatting Rules property, click the ellipsis button, to invoke the Formatting Rules Editor.

In this dialog, click the Edit Rule Sheet… button. The Formatting Rule Sheet Editor will appear.

Now, click the Add button , to create a new formatting rule. Then, set its Visible property to Yes, and for the Condition property, click the ellipsis button, to invoke the Condition Editor.

In this editor, define the following expression for the rule: ([DataSource.CurrentRowIndex] % [Parameters.rowsNumber] == 0) And ([DataSource.CurrentRowIndex] != 0).

Click OK, to save the changes and close the dialog. Then, click Close to quit the Formatting Rule Sheet Editor.

Now, in the invoked Formatting Rule Sheet Editor, click + , to create a new formatting rule.

Set its Visible property to Yes, and click the ellipsis button for its Condition property.

In the invoked Condition Editor, define a logical expression for the rule, (e.g. ([DataSource.CurrentRowIndex] % [Parameters.rowsNumber] == 0) And ([DataSource.CurrentRowIndex] != 0)).

To save the changes and close the dialog, click OK.

Then, click Close, to quit the Formatting Rule Sheet Editor, as well.

To save the changes and close the editor, click OK.

January 17, 2017

Count the Number of Records in a Report or a Group

Count the Number of Records in a Group

Set the Running option to Group and the Function to Count.

The Ignore NULL values option is useful for functions like Count or Average, because the number of elements counted will depend on it.

If required, you can specify the Format String (e.g. as Units Count: {0}). Note that value formatting is applied to a summary independently of the general formatting, and has a greater priority.

Count the Number of Records in a Report

To add a Report Footer band to your report, right-click anywhere on it, and in the invoked Context Menu, choose Insert Band | ReportFooter.

Then, place a Label bound to a data field onto it, and in the Property Grid, expand its Summary category.

Set the Running option to Report and Function to Count.

The Ignore NULL values option is useful for functions like Count or Average, because the number of elements counted will depend on it.

If required, you can specify the Format String (e.g. as Total Count: {0}). Note that value formatting is applied to a summary independently of the general formatting, and has a greater priority.

January 17, 2017

Add a Cross Reference

Drop a label onto the created ReportHeader band, which will serve as the report’s headline.

Click the label, to type the desired contents into it. Then, in the Property Grid, set its Name property to reportTop.

To accompany the existing Group Header with the corresponding Footer, in the Group and Sort Panel, check the Show Footer option.

Then, drop a label onto it. As it will be the link, change its Text to Top of Report, and apply the desired formatting to it (e.g. the blue color and underlined text).

Set its Navigation Target property to _self. Then, if you click the drop-down list of the Navigation URL property, you can see the controls available in your report. Choose the one named reportTop.

The cross-reference is now ready. Switch to the Preview Tab, and view the result.

January 17, 2017

Add Bookmarks

Click the Label in the Report Header band, to select it, and in the Property Grid, set its Bookmark property to the same value as its text (i.e. Products by Categories).

Now, select the Label in the report’s Group Header band.

As this control is bound to data, we will bind its Bookmark property to the same data field, using the (Data Bindings) property.

Note that as with other bindable properties, you also can apply value formatting to the Bookmark property (e.g. Category {0}).

Then, for this Label, specify its Bookmark, and set the Parent Bookmark property to the Report Header’s label, to define the document map’s hierarchy.

The report with bookmarks is now ready. Switch to the Preview Tab, and view the result.

January 17, 2017

Conditionally Change a Label’s Text

To create a calculated field, in the Field List, right-click any item inside the created dataset, and on the invoked menu, choose Add Calculated Field.

Now, in the Property Grid, set the field’s Field Type property to String. Then, locate its Expression property and click its ellipsis button. The Expression Editor will appear.

In this dialog, define the required condition for the calculated field (e.g. Iif([UnitsOnOrder] == 0, ‘None’, [UnitsOnOrder]), which means that if the UnitsOnOrder data field’s value is equal to 0, the appropriate control’s text will be replaced with None).

To close the dialog, click OK.

Finally, drop the required data fields (and the created calculated field as well) from the Field List onto the report’s Detail band.

The report is now ready. Switch to the Preview Tab, and view the result.

January 17, 2017

Conditionally Hiding Bands

In this example, we will hide the Group Header and Detail bands, if a grouping field meets a certain condition. Note that no scripts are required to accomplish this task.

Add a Group Header band to the report.
For this, right-click anywhere over the report’s surface, and in the invoked Context Menu, point to Insert Band and click GroupHeader.

Drop a field which will be used as a grouping criteria, from the Field List onto the created GroupHeader1 band.

Select the Group Header, and click its Smart Tag.

Then, in the invoked actions list, click the ellipsis button for the Formatting Rules option.

In the invoked Formatting Rules Editor, click the Edit Rule Sheet… button.

Now, in the invoked Formatting Rule Sheet Editor, click the button, to create a new rule.

Then, set its Visible property to No, and click the ellipsis button for the Condition property.

Now, select the Group Header band’s strip, and in the Property Grid, locate the Formatting Rules property, and click its ellipsis button.

In the invoked Formatting Rules Editor, click the Edit Rule Sheet… button.

Construct the required logical expression (e.g. [CategoryID] < 2), and click OK.

Back in the Formatting Rules Editor, move the created rule to the dialog’s right section (Applied Rules), to make it active.

And, do the same for the report’s Detail band. That is, click the ellipsis button for its Formatting Rules property, and in the invoked dialog, apply the same rule to this band, as well.

Switch to the Preview Tab, and view the result

January 17, 2017

Conditionally Change a Control’s Appearance

Drop the required fields from the Field List onto the report’s Detail band.

Select the report by clicking anywhere over the blank area around its bands, and in the Property Grid, locate the Formatting Rules Sheet property and click its ellipsis button.

The invoked Formatting Rule Sheet Editor is intended to manage and customize formatting rules, which then can be defined for the report’s bands and controls.

In this dialog, create a new formatting rule (by using the button), locate its Condition property and, again, click its ellipsis button.

In the invoked Condition Editor, define the required Boolean condition. In this tutorial, we will format fields if the UnitPrice value is greater than 30.

To save the condition and close the dialog, click OK.

Now, back in the Formatting Rule Sheet Editor, define the formatting to be applied (e.g. specify the desired font color).

To save the changes and quit the dialog, click Close.

Select the band or control to which the formatting rule must be applied (in this example it is the Detail band), and in the Property Grid, locate its Formatting Rules property and click its ellipsis button.

If multiple rules are applied, it is possible to customize their precedence, by using the up and down arrow buttons at the right of the dialog.

So, the rules are applied in the same order that they appear in the list, and the last rule in the list has the highest priority.

January 17, 2017

Store and Restore Style Sheets

Click the report’s Smart Tag, and in the invoked actions list, locate the Style Sheet property and click its ellipsis button.

In the invoked Styles Editor, use the button, to create new styles.

Define their required properties and click the Save button.

In the invoked Save File dialog, define a name for the style sheet file (.REPSS) to be created and click Save.

Now, in the Styles Editor dialog, use the Delete button to delete the created styles, and close the dialog.

Select the report, by clicking anywhere over the blank area around its bands. In the Property Grid, locate the Style Sheet Path property and click its ellipsis button.

In the invoked Open File dialog, load the created REPSS file.

If you then click the Style Sheet properties ellipsis button, in the invoked Styles Editor, you’ll see that the properties of the styles are read-only. This is because we used the Style Sheet Path property to load the style sheet.

If the Style Sheet Path property is then set to None, and a style sheet is loaded into a report using the Style Sheet property, all the styles loaded from the style sheet file will still be kept in the report, but become editable.

When you invoke the Styles Editor (via the report’s Style Sheet property) again, you’ll see that the styles are read-only, meaning that they are obtained from an external file.

If the Style Sheet Path property is then set to None, and a style sheet is loaded using the Styles Editor of the Style Sheet property, all these styles will become editable.

January 17, 2017