i am using ssrs report i want display serial number automatically

Posted by Venky.Net under C# on 1/23/2014 | Points: 10 | Views : 16377 | Status : [Member] | Replies : 8
hi
i am using ssrs report.i want display serial number in automatically i am using RowNumber(nothing) function but can't display serial number. i am using grouping function how to display serial number automaticcaly




Responses

Posted by: Learningtorise on: 1/23/2014 [Member] Starter | Points: 25

Up
0
Down
This link should help;

http://stackoverflow.com/questions/17581613/rownumber-for-group-in-ssrs-2005

ELSE
You can Use Either of following Solution in SQL:
1..

SELECT RowNum = IDENTITY(INT, 1, 1), Columns

INTO #TEMP
FROM MyTable

SELECT * FROM #TEMP ORDER BY RowNum


OR

2...(Won't work if u r using SQL version 2000)

SELECT ROW_NUMBER() OVER (Order by Id) AS RowNumber, Field1, Field2, Field3

FROM User




http://hashtagakash.wordpress.com/

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajesh_Kumar on: 1/23/2014 [Member] [MVP] Silver | Points: 25

Up
0
Down
You can use Row_Number() over(order by id) function

Rejesh Kumar

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Snaveen on: 2/13/2014 [Member] Starter | Points: 25

Up
0
Down
Hi,

Use below expression to get serial number based on column wise.

[code]
=RunningValue(Fields!Functional_Description.Value, CountDistinct, nothing)
[/code]

In above expression "Functional_Description" is my column name and based on column i get serial number

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 2/13/2014 [Member] [MVP] Platinum | Points: 25
Posted by: Heho on: 7/6/2016 [Member] Starter | Points: 25

Up
0
Down
use this expression in expression box,
=RowNumber(nothing)


http://www.microsoft-sql-ssis.com/2016/07/how-to-show-serial-number-in-reports.html

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bhupentiwari on: 7/6/2016 [Member] Starter | Points: 25

Up
0
Down
=RowNumber(nothing)

Thanks n Regards
Bhupendra Tiwari

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Anandkumarviky on: 9/22/2016 [Member] Starter | Points: 25

Up
0
Down
creation of Serial Number in SSRS is some time a big concern, You can create it
=RowNumber(Nothing)
if this is not helpful, Please read this article for more details
http://www.csharpmagic.com/create-serial-number-in-ssrs/


Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response