Page 1 of 1

Conditional Formatting Issue on Crosstab Report

Posted: Thu Jun 06, 2019 4:15 am
by 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 320 times
CrossTabTest.mrt
(320 KiB) Downloaded 320 times

Re: Conditional Formatting Issue on Crosstab Report

Posted: Thu Jun 06, 2019 5:39 pm
by 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.

Re: Conditional Formatting Issue on Crosstab Report

Posted: Fri Jun 07, 2019 12:48 am
by 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.

Re: Conditional Formatting Issue on Crosstab Report

Posted: Mon Jun 10, 2019 7:17 am
by Lech Kulikowski
Hello,

Please send us a test data for your report.

Thank you.

Re: Conditional Formatting Issue on Crosstab Report

Posted: Tue Jun 11, 2019 1:32 am
by 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 277 times
Thanks

Re: Conditional Formatting Issue on Crosstab Report

Posted: Tue Jun 11, 2019 6:55 am
by 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.