Conditional Formatting Issue on Crosstab Report

[dwhybro]

Hi, I have a crosstab report that requires conditional formatting on one of the output cells. It is a calculated field of no.of weeks which should be highlighted if greater than 40 and left un-highlighted if less than 40. Upon rendering every record is highlighted regardless of value. Can anyone assist. Attached is the report and I am running Reports.Web v 2016.3.7 embedded into our database product.

CrossTabTest.mrt

(320 KiB) Downloaded 291 times

CrossTabTest.mrt

(320 KiB) Downloaded 291 times

[Lech Kulikowski]

Hello,

In the Cross-Tab conditions only system variables - tag, value are available.
You can find samples:
https://demo.stimulsoft.com/#Net/CrossT ... Condition2

Thank you.

[dwhybro]

Thanks Lech. So should using this condition work on the 'Weeks' row item:

tag > 40 or value >40

I can't seem to get any option to work.

[Lech Kulikowski]

Hello,

Please send us a test data for your report.

Thank you.

[dwhybro]

Hi Lech,

I've attached a dump of some test data in Excel format. Hope this is enough.

test_data_2019-06-11_crosstab.xlsx

(12.65 KiB) Downloaded 235 times

Thanks

[Lech Kulikowski]

Hello,

Conditions with value, Tag variables are supported only for Summary cells.
For Rows and Columns, is needed to use an additional code in events:
https://stimulsoft.zendesk.com/hc/en-us ... -cross-tab

but if check your screenshot, is used flash version, in which events are not supported.

Thank you.