Sage Report Designer User’s Guide
To add some conditional information text
To see additional information or a warning message on a report when certain object criteria are
met, you can apply conditional formatting to text objects. For example, instead of changing the
font and style of the sales balance when it is less than £2500, a warning message could appear
against the value, or the message could appear in addition to other conditional changes.
1. Open the report, set it to conditional view and add the text you require for the message to
You can then position the text box where you want the text to appear. In this example, the
'Criteria 2' line has been moved down from the original report allowing for the text to be
added underneath the 'Last Statement Balance' field.
2. Double-click on the text object.
The 'Conditional Object Properties' window appears.
3. To add your filter, follow steps 3-5 of the 'To set up conditional formatting' procedure.
Continue with steps 6 and 7 from that procedure if you want to format the font details, and
click OK. In this example you would set the same Filter;
'CBAccount.CurrentBalanceInAccntCurrency < 2500'.
4. Select the text box, and click on the right-hand mouse button.
5. Select the 'Properties' option from the menu.
6. Click on the 'Options' tab and select the 'Suppress Printing' option.
7. Click 'OK' to save the 'Object Properties' settings.
When you run the report, the warning message text that you setup earlier appears against the
balances that exceed £2500.
In the example, you can see that the Petty Cash account has a warning displayed as the current
balance is only £163.88. The amount is also displayed as italics. If you have followed the
example, the amounts in your report will also be displayed in a different colour.