Number of values in rendered cross-data columns
Number of values in rendered cross-data columns
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.
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.
Re: Number of values in rendered cross-data columns
Hello.
You could get the CrossDataBand2.Count value.
Thank you.
You could get the CrossDataBand2.Count value.
Thank you.
Re: Number of values in rendered cross-data columns
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.
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.
Re: Number of values in rendered cross-data columns
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.
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.
Re: Number of values in rendered cross-data columns
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.
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.
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Number of values in rendered cross-data columns
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.
> 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.
Re: Number of values in rendered cross-data columns
Hi
Thank you for your help. I managed to get the total sum
Thank you for your help. I managed to get the total sum
Re: Number of values in rendered cross-data columns
Hello.
We are always glad to help you.
Thank you.
We are always glad to help you.
Thank you.