CrossTable Component - conditioned based formatting

[fabzemp]

Hi

I'm working with your report engine a few weeks now.

A started using your crosstable component to create very useful reports in a short time.

My problem is that I didn't get on how to format (esp. conditional formating) the rows in a crosstable. I guess that the main problem ist, that the columns are filled out dynamicly --> Maybe today are two of them, tomorrow I could have five columns.

Example:

__________ Drinks______Food_____Other
Berlin______5__________5456_____55
Dresden____555________55_______55
...

The values in the above pivot are dynamicly calculated sums. What I want is
1. The whole column Food should have the background colour green
2. if the value ist less than 5, instead of the value should be printed a string called "none"

I'd like to solve this problem with GUI-settings and without any code if possible.

I'd really appreciate if somebody could give me some instructions or tell me in which help-source this topic could be described.

Thanks a lot

Fab

[Edward]

In the latest prerelease build we've made some improvements in Cross Tab component.
they are described here:

http://forum.stimulsoft.com/Default.aspx?g=posts&t=1172

My problem is that I didn't get on how to format (esp. conditional formating) the rows in a crosstable. I guess that the main problem ist, that the columns are filled out dynamicly --> Maybe today are two of them, tomorrow I could have five columns.

Example:

__________ Drinks______Food_____Other
Berlin______5__________5456_____55
Dresden____555________55_______55
...

The values in the above pivot are dynamicly calculated sums. What I want is
1. The whole column Food should have the background colour green

In the Tag property you should add an expression which checks DataSource.ProductName value (in your case it would be "Food").
Tag expression:

Code: Select all

{MyDataSource.ProductName}

In the Condition property of the Cross-Summary cell in CrossTab appropriate check must be made:

Code: Select all

tag == "Food"

Appropriate style to the cell must be assigned as well for this value, e.g. green background.

2. if the value ist less than 5, instead of the value should be printed a string called "none"

We'll inform you about this later.

Thank you.

[fabzemp]

Thank you.
I'll have a look at your link above and try it with your code-examples

[Vital]

Hello Fab,

2. if the value ist less than 5, instead of the value should be printed a string called "none"

I'd like to solve this problem with GUI-settings and without any code if possible.

Please get build from 14 April (when it will be available). We have added required ability to conditions editor.

Thank you.