This is a migrated thread and some comments may be shown as answers.

I have a problem to count Rows

1 Answer 190 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Indiana
Top achievements
Rank 1
Indiana asked on 15 Jul 2013, 10:50 AM
Hello guys,

Im using Telerik_Reporting_Q2_2013 - and i have a problem to count the rows.
http://s7.directupload.net/images/130715/qbesd3up.png

At the top you can see how it is right now, at the bottom how i wish it to be.
=RunningValue("table1",CountDistinct(Fields.StartDate)) - seems to count wrong.

http://s1.directupload.net/images/130715/qw6y826q.png

Please help me :)

Best regards,

1 Answer, 1 is accepted

Sort by
0
Hadib Ahmabi
Top achievements
Rank 1
answered on 18 Jul 2013, 08:22 AM
The running value resets per scope. So if you want for each new group, the value to start from 0, then the expression should not be
=RunningValue("table1",CountDistinct(Fields.StartDate))
but instead
=RunningValue("rowGroup",CountDistinct(Fields.StartDate)) or "startDate1" since i cannot fully understand the structure of the table. 
Tags
General Discussions
Asked by
Indiana
Top achievements
Rank 1
Answers by
Hadib Ahmabi
Top achievements
Rank 1
Share this question
or