This is a migrated thread and some comments may be shown as answers.

Conditional formatting on watermark

1 Answer 397 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Maxim
Top achievements
Rank 2
Maxim asked on 10 Oct 2016, 05:25 PM

How do I set up conditional formatting on a watermark?

I only want the watermark to display when a field value = "Official" (This will place a "Official Copy" watermark on the report. )

The report is ignoring the conditional formatting rule and inserting the watermark. 

 

1 Answer, 1 is accepted

Sort by
0
Katia
Telerik team
answered on 11 Oct 2016, 12:17 PM
Hi Maxim,

Watermarks are part of report's page settings and cannot use data fields directly as the data is not available at the time of the paging - Report Life Cycle.

You can use 
PageExec data function which will evaluate the aggregate function in the context of the physical page, for example:
= IIf(PageExec('textBox1', First(Fields.Column1)) = 'Official', 'Official Copy', '')


Regards,
Katia
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Greg
Top achievements
Rank 1
commented on 29 Nov 2023, 03:30 AM

The recommendation by Katia does not work.

HOW can we use a field for a conditional Watermark? This is a high-priority question as it is a core part of any reporting system in the real world.

Todor
Telerik team
commented on 01 Dec 2023, 02:26 PM

Hi Greg,

As already explained in the ticket you opened on the same issue, you need to use a Report Parameter. Here is the summary of my reply that may be beneficial for other Telerik Reporting users as well:

I suggest using a Report Parameter for setting the Expression for the Text of the Watermark. The reason is that the fields are not available in the Report PageSettings in run-time as the Report doesn't have a parent data item - see Data Items Overview for more details.

You may set the DataSource that contains the corresponding field to the Report Parameter AvailableValues.

Tags
Report Designer (standalone)
Asked by
Maxim
Top achievements
Rank 2
Answers by
Katia
Telerik team
Share this question
or