Rownumber() function of RDLC report isn't correct

.net report rdlc ssrs-tablix rdl
Fame th picture Fame th · Sep 2, 2015 · Viewed 14.5k times · Source

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.

enter image description here

Answer

Fame th picture Fame th · Sep 3, 2015

I solved this problem.

At "No." Column use this expression

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

Related questions

.rdlc Report - Cannot create a data reader for dataset 'DataSet1'

I have created a .rdlc-Report under VS 2012 using the report wizard and added data source and dataset. When I try to render the report using the code below I get following error message: Cannot create a data reader for dataset …

Read More
How to make an HTTP POST web request

Canonical How can I make an HTTP request and send some data using the POST method? I can do a GET request, but I have no idea of how to make a POST request.

Read More
How can I convert String to Int?

I have a TextBoxD1.Text and I want to convert it to an int to store it in a database. How can I do this?

Read More