Creating reports and dashboards | Stimulsoft community forum

Hello,

I need to get the number of values contained in the rendered cross-data columns. I will use this number in a calculation.

In the attached report, I need to count the number of LabRequest.LabSamples.LabTraits.TraitRequested values that are displayed in CrossDataBand2.

How can I do that?

Thank you.

Hello.

You could get the CrossDataBand2.Count value.


Thank you.

Hello,

Thank you for your reply.
It seems that CrossDataBand2.Count returns the numbers of columns, not the number of values inside these columns.
See my example: CrossDataBand2.Count returns "3" while there are much more values in my columns.

How can I count them?

Thanks.

Hello,

Sorry, maybe I don't understand you right.
Do you need to calculate the sum?
You could do it like with the regular data bands.

Thank you.

Hi,

Sorry if I'm not clear.
Yes, the sum would work. The sum of all the cells, meaning 10, in my example.
I tried with regular sum calculations but couln't get the total sum for the entire report

Thank you for your help.

Hello,

> I tried with regular sum calculations but couln't get the total sum for the entire report

You can sue the Totals.Sum() function:
Totals.Sum(datasource, column)

Thank you.

Hi

Thank you for your help. I managed to get the total sum

Hello.

We are always glad to help you.

Thank you.