Conditional Formatting

Mpanal · Post by **Mpanal** » Fri Oct 09, 2009 5:36 am

Hello,

I have a databand with a calculated field that is a summatory of another field on databand. This calculated field is named "saldo"

I want that if the value of the calculated field is positive, their colour be green and if negative, red.

What expression I must have to use?

saldo > 0 don't work : error CS0019

Thanks

Post by **Edward** » Fri Oct 09, 2009 5:57 am

Hi

Please change the condition as follows:

MyDataSource.saldo > 0

where MyDataSource is the name of the DataSource in the Dictionary which contains that 'saldo' Calclated Column.

Thank you.

Mpanal · Post by **Mpanal** » Fri Oct 09, 2009 11:10 am

Thanks for the answer.

Sorry for the mistake, saldo is not a calculated column. Is a STitext.

Post by **Edward** » Fri Oct 09, 2009 3:00 pm

Hi

You can write the similar condition to the Conditions property of that StiText.

Thank you.

Mpanal · Post by **Mpanal** » Tue Oct 13, 2009 2:25 am

Dont work

My report is:

Field1, field2, field3,... saldo

Saldo is a STItext with running sum(field1). Calculate result be fine. filed1 and saldo can be positive or negative on every row.

The problem is formating color on saldo. If on format conditions, I put expresion sum(field1) > 0 color green and sum(filed1) < 0 color red, the result color depents on the result value of sum(field1) at the finish of report, not on the row.

The same result with sum(field1) and sumrunning(field1)

Post by **Edward** » Tue Oct 13, 2009 3:24 pm

Hi

Please open attached report in the Demo.exe sample application which comes with a standard installation of Stimulsoft Reports.Net.

Thank you.

Mpanal · Post by **Mpanal** » Wed Oct 14, 2009 2:57 am

Edward,

Works perfectly.

Thank you very much

:biggrin:

Post by **Edward** » Thu Oct 15, 2009 5:11 pm

Hi

Please let us know if you need any help.

Thank you.