Row Number

Question

Row Number

joseph_smithy-1130150

SSC-Addicted

Points: 493
More actions
July 17, 2009 at 5:40 am

#155978

I want to add a row number at the bottom of my table on SSRS
what is the code for it?

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

kramaswamy SSCoach Points: 18181 More actions · Answer 1

Are you trying to add a field to your table which will indicate the "row number" of the row? In that case, what you want to do is add an identity field to the table, like this:

ALTER TABLE [TableName] ADD [FieldName] INT IDENTITY (1,1)

If you're trying to add a row number to your query result set, then what you want is this:

SELECT

[Criteria],

ROW_NUMBER() OVER (ORDER BY [ColumnName])

FROM

[Table]

WHERE

[WhereClauses]

VaibhavChoubey@SQL Ten Centuries Points: 1033 More actions · Answer 2

Not clear buddy you want to add a row number or a page number??

joseph_smithy-1130150 SSC-Addicted Points: 493 More actions · Answer 3

i want to add a row number to the bottom of the table in SSRS.... so it count how many rows i have

kramaswamy SSCoach Points: 18181 More actions · Answer 4

Well, this isn't really the right forum for SSRS questions, but you've got several ways you could accomplish this. One of them is to use the ROW_NUMBER function that I mentioned above as part of your query, and then do a MAX() call against the ROW_NUMBER field to get the number of rows.

VaibhavChoubey@SQL Ten Centuries Points: 1033 More actions · Answer 5

Use this SSRS function:

RowNumber(scope)

Parameters

scope

(String) The name of a dataset, data region, or group, or null (Nothing in Visual Basic), that specifies the outermost context, usually the report dataset.

joseph_smithy-1130150 SSC-Addicted Points: 493 More actions · Answer 6

joseph_smithy-1130150

SSC-Addicted

Points: 493

July 17, 2009 at 7:05 am

#1026146

how do i set the scope to 'String'?

kramaswamy SSCoach Points: 18181 More actions · Answer 7

joseph_smithy (7/17/2009)
how do i set the scope to 'String'?

The scope isn't String, the scope's type is String. The value is the data set in your case.

joseph_smithy-1130150 SSC-Addicted Points: 493 More actions · Answer 8

Got it now...

The name of my dataset it 'DrillThru'

So if i enter the following on the bottom row of my table.

=RowNumber(DrillThru)

I get the following error -

Error1[rsInvalidAggregateScope] The Value expression for the textbox ‘textbox8’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.00