SQL Server Reporting Service: can anyone explain this strange behaviour when counting rows with RowNumber? -

In my initial problem table, the number of rows in the table has already been resolved, still I want to know the original I have created a report with the following dataset:

I am following the following behavior in SQL Server Reporting Services (I hope that is clear enough for example):

I created a report with the following dataset:

  1 Select AS column 1, select 'first' column A2 column 2AS column 1, 'second' ASC Select 2 union 2 ASS column 1, 'Third' AS column 2 Association selection 3 ASS column 1, 'Fourth' AS column 2 Association selection 3 ASS column 1, 'Fifth' AS column 2  

In my report I have made a list with a group called 'list1_Details_Group' based on 'Columns', I added a table with two columns in this list; One line number ('= line number ("list1_Details_Group")) and with a' column 2 '. When I put the 'Page Break End' of my group, the output is expected:

However, when I add the following textbox: '=' Number of items: " + ReportItems ("RowNumber"). Value.ToString, the first rownumbers on the next pages go wrong:

The first rownumber of the table gets the same value from the previous page The value of the text box! I did not expect this behavior, could someone explain why this happened

BTW: When the content of the textbox is '=' the number of objects: "+ row number (" list1_Details_Group "). ToString Report is printed without problems!

Where are you adding text boxes? In the extension group? Under the table?

I will take a different view on this. I will present it in the same table Calculating the number of items used in group headers and footers (with merged columnation) and group work . This way it is always consistent and there will be no problem with the row number.

The ronember is very brittle and small changes in your layout or expression can break due to different micro-details.