Configure the report header, footer, and properties
Set the report properties
- Select the darker gray area surrounding the report canvas to ensure that no report elements are selected, then select the properties icon (
).
- In the Page Units section, select the appropriate unit from the Page Unit dropdown.
For example, inches, centimeters, or pixels.
- In the Margin section, set the page margins.
- In the Paper Size section, set the Orientation and Paper size as needed.
These properties can also be modified after the report is complete and the overall width is known.
Display and configure the report header
- With the custom report open, select View > Header to display the header.
- To add the report title, drag and drop the TextBox widget to the header section, and then configure the properties as needed.Make sure to select outside of the element to clear the selection and then select it again to view all the TextBox widget properties.
- To add the corporate logo, do the following:
- Select the parameters icon (
) and select + New Parameter. - Enter LogoURL in the Name and Prompt fields.
This parameter is also used in the standard log reports and is populated dynamically based on the account.
Select Allow blank value("").
Select Hidden from the Visibility dropdown.
Select Save.
Drag and drop the Image widget to the left corner of the report header.
Make sure to select outside of the element to clear the selection and then select it again to view all the Image widget properties.In the properties, do the following:
Enter the Name.
In the Basic Settings section, set the Source to External, then select the square icon (
) next to the Value field and select Expression...In the dialog, double-click the LogoURL parameter under the Data field to populate the expression field and select OK.
Enter the Size and Position.
- Select the parameters icon (
Display and configure the report footer
- With the custom report open, select View > Footer to display the footer.
- To add a timestamp in the footer, do the following:
- Drag and drop the TextBox control to the footer section.Make sure to select outside of the element to clear the selection and then select it again to view all the TextBox control properties.
Double-click the Textbox, then right-click and select Expression.
In the Expression dialog, enter one of the following expressions in the Set Expression For : Value field as needed and select OK:
To display the UTC time, enter =Now().
To display the local time, enter =Code.ToLocal(Now(), Parameters!UserTimeZone.Value).
- Update the following properties:
- Enter LabelTimestamp in the Name field.
- In the Basic Settings section, set the Font size to 0.111 and the Font Style to Default in both dropdowns.
- In the Position section, set both Left and Top to 0.00, and set the Size to 3.00 in Width and 0.20 in Height.
- Drag and drop the TextBox control to the footer section.
- To add numbering in the footer, do the following:
- Drag and drop the TextBox widget to the footer section.Make sure to select outside of the element to clear the selection and then select it again to view all the TextBox control properties.
Double-click the Textbox, then right-click and select Expression.
In the Expression dialog, enter ="Page " & Globals.PageNumber & " of " & Globals.TotalPages in the Set Expression For : Value field and select OK.
Update the following properties:
- Enter PageNumbering in the Name field.
- In the Basic Settings section, set the Font size to 0.111 and the Font Style to Default in both dropdowns.
- In the Alignment section, set the Text Alignment to Right.
- In the Position section, set Left to 5.00 and Top to 0.00, and set the Size to 3.00 in Width and 0.20 in Height.
- Drag and drop the TextBox widget to the footer section.
- To adjust the footer height, drag the edge of the footer canvas upward to reduce vertical spacing.