Rownumber() function of RDLC report isn't correct

Question

Below figure is my report. This tablix has 10 row from dataset.

It's grouped by TOOL_CODE and TYPE for get count. At "Count" Column is use this expression ..

   = Count("Detials")

"Detials" is a name of group(by TOOL and TYPE)

And No.Column I use expression by Rownumber() function like these

   = Rownumber(Nothing)

It's wrong because Rownumber() refer to items in dataset. It's not count from row which is display.

interesting! I guess you could add custom function to increment for each actual report row. — InitK, Sep 02 '15 at 16:11

score 7 · Answer 1 · answered Sep 03 '15 at 01:57

7

I solved this problem.

At "No." Column use this expression

  =RunningValue(CountDistinct("TableName"),Count,"TableName")

answered Sep 03 '15 at 01:57

Fame th

score 7 · Answer 2 · answered Sep 06 '18 at 06:02

7

This works:

=RowNumber(Nothing)

I like it also for the fact that it will number grouped sets of data independently, so you know the total in each group.

answered Sep 06 '18 at 06:02

Hannington Mambo

score 0 · Answer 3 · edited Jul 12 '17 at 20:05

0

You can just add an expression at the detail level of =RowNumber("[tablename]")

edited Jul 12 '17 at 20:05

Floern

answered Jul 12 '17 at 20:00

David Pilkinton

3 Answers3