Get values from a crosstab

[Michael]

Hi,

I have a report containing a crosstab, which works fine.  Because my data structure is defined, I know exactly how many rows and columns of data my crosstab will contain.

Now, in code I want to take the values from the crosstab and use them to set the sizes of some pre-defined shapes on the report.  How can I iterate through the cells in the crosstab to get hold of these values, and which event handler should I use (I am assuming crosstab1_ItemDataBound).

Alternatively (and this was my first idea) I could get the data values from the data source of the report itself, but I have not been able to work out how to get hold of this and cast it into a data object which I can iterate through.  Is it possible to do this kind of thing in the report's ItemDataBinding or ItemDataBound events, for example?

Thanks,

Michael

[Peter]

Hello Michael,

In the report items ItemDataBound you can retrieve the parent data item data object. Thus our suggestion is to use crosstab textbox ItemDataBound. You may find useful the Report Events help article.

Generally the report items Size property support Bindings thus you can alter the report items size with an user function based on report data.

Best wishes,
Peter
the Telerik team