Computing percents in CrossTable

[LukasT]

Hello,
I have CrossTable and I need to compute percents of "zisk" and "zisk_plan" columns in red "plneni" column... How can I do this?
Thank you...

[Alex K.]

Hello,

The ProcessCellEvent event is added for cross-fields. The event allows you to process the value of cells after the rendering a cross-table. An example of the event for cell summation:

Code: Select all

if (e.Value> 100)
e.Value = e.Value / 100;
else
e.Text = "NONE";

In this event, you can also apply to other cells. Example:

Cells [0, 0] - a numeric value in the current cell
Cells [-1, 0] - a numeric value in the cell on the left of the current one
Cells [1, 0] - a numeric value in the cell on the right of the current one
Cells [0, -1] - a numeric value in the cell above from the current one
Cells [0, 1] - a numeric value in the cell below from the current one

Code example:

Code: Select all

e.Value = Cells [-1, 0] / 2;

To subscribe to this event for changing the totals, it is not necessary to subscribe to the cell summation but to the total cell (the Total inscription). In this case, additionally, you can use the following variables:

e.Cell.SummaryIndex is the total index, starts with 0. For example, if using two total cells in the cross-table, the first one will have the 0 index, the second one will have the 1 index. If the cell does not have an index (is not a total), then the index is -1.
e.Cell.IsCrossSummary is the total angular cell, the cell at the intersection of horizontal and vertical lines of totals.

You can also find general index of the cell horizontally and vertically:

e.Column
e.Row

The indexes starts from 0.

Thank you.

[kirtapatrik]

Hello,

Where can i find the ProcessCell Event? I have only the "GetCrossValueEvent".

Wenn i use the code

Code: Select all

e.Value = Cells[0,0]

then i get the Error

The name 'Cells' does not exist in the current context

Thx for your support
Patrik

[Alex K.]

Hello,

Which version of Stimulsoft Reports.Net do you use?
This functionality was added about a month ago. Please check the latest version.

Thank you.

[kirtapatrik]

G' Day

Yes wrong Version.

Thank you
Patrik

[Alex K.]

Hello,

Let us know if you need any additional help.

Thank you.