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.
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.
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.