Page 1 of 1

Highlighting conditioner doesn't work on crosstab at all

Posted: Mon Dec 13, 2021 8:38 am
by faraday
Hi everyone,
I create a cross tab on the data band and it works properly, But when trying to highlight based on conditions on the value of data or even sorting it does not do ANYTHING. I use almost every method of condition highlighting but no result. Reading searching through forums and youtube channels don't help me either.
MRT file is in the attachment. the problem is highlighting the minimum value at the "price*count" column or even at "unit price" column. however based on my database this minimum value always has "Tender_Contractor_Equipments.ResultID==4", so that I can highlight base on this condition too (that doesn't work either)

Re: Highlighting conditioner doesn't work on crosstab at all

Posted: Mon Dec 13, 2021 9:51 am
by faraday
I could apply "Tender_Contractor_Equipments.ResultID == 4" condition with this post viewtopic.php?t=59523 and see hilight for the first time!
but this is not my desired result as I need to highlight the minimum value in that column. how should I do that?

Re: Highlighting conditioner doesn't work on crosstab at all

Posted: Mon Dec 13, 2021 12:31 pm
by Max Shamanov
Hello,

Try to use Highlight conditions with expression "Value == 4".
Please send us a sample report with demo data(XML, JSON, Excel).

Thank you.

Re: Highlighting conditioner doesn't work on crosstab at all

Posted: Mon Dec 13, 2021 12:47 pm
by faraday
Max Shamanov wrote: Mon Dec 13, 2021 12:31 pm Hello,

Try to use Highlight conditions with expression "Value == 4".
Please send us a sample report with demo data(XML, JSON, Excel).

Thank you.
tag == "4" and defining tag as Tender_Contractor_Equipments.ResultID, worked fine for me. Thanks.
is there any chance to use SQL or c# function on the interaction menu for defining tags?

Re: Highlighting conditioner doesn't work on crosstab at all

Posted: Mon Dec 13, 2021 2:14 pm
by Max Shamanov
Hello,

You can set a tag property from the C# code for component, using next code

Code: Select all

 component.Tag = new StiTagExpression("SomeText");
You can't set tag by using SQL.

Thank you.