How to Show the Serial Number in Reports Automatically Using Expression in .NET

Rahul Bansal

ASP.NETReports in .NETSerial Number in ReportsSerial Number in Reports Automatically

11 Comments

Join the conversation! Your thoughts help the community grow.

ratnesh kumar5y ago
After splitting the use of exp. (=JOIN(Split(Fields!FileName.Value,"?"), System.Environment.NewLine)) splitting row into column and add serial number 1, 2, 3 so on. how to do. ?
shivaram santosh8y ago
Thanks for useful information
Shovan Saha9y ago
Serial number is essential. Thanks for sharing.
Shovan Saha9y ago
Serial number is essential. Thanks for sharing.
veera muthu10y ago
Thankyu For your useful information
Nikunj Trivedi11y ago
Good One Article Sir....Its Very helpful to us.......But I have One Query Regarding Crystal Report..How to print crystal report programatically on button click ?? bcoz in Visual studio 2010 crystal report , there are so many problems on PRINT button and Export button.
Sandeep Jaglan11y ago
this doesn't work well when you have row show/hide condition is enabled
- Rahul Bansal11y ago
  Yeah sure
majedul islam11y ago
thnx
Gm Arif11y ago
thanks
mohan Chandankar12y ago
thanx

This article explains how to show the Serial Number in reports automatically using expressions in .NET.

Description

Using expressions you can add Serial Numbers to reports automatically. I will show you a demo by which you can create the serial numbers in reports.

Note: I am assuming that you can create the report. If you are a beginner to reports then follow my earlier article "Getting Started with Reports in .NET".

Use the following procedure to understand this article.

Step 1: I will create a table named "Employee" in my database "Test"

CREATE TABLE [dbo].[Employee](

[Name] [varchar](50) NULL,

[Salary] [int] NULL

)

insert into Employee (Name,Salary)values('A',50000)

insert into Employee (Name,Salary)values('B',10000)

insert into Employee (Name,Salary)values('C',60000)

insert into Employee (Name,Salary)values('D',20000)

insert into Employee (Name,Salary)values('E',10000)

insert into Employee (Name,Salary)values('F',70000)

insert into Employee (Name,Salary)values('G',40000)

select * from employee

Step 2: Create a page named "Default.aspx" with "ScriptManager" from the Ajax Extensions section, "SQLDataSource" from the Data section and "ReportViewer" Control from the Reporting section.

Bind the table columns with "SQLDataSource" to access the data.

Step 3: Add a report named "Report.rdlc" and bind the dataset into the reports using Table.

Run the "Default.aspx" after adding the report named "Report.rdlc" to the "ReportViewer" control

Purpose: I want to add the sequence number or serial number to every row.

Solution

To do this I will use an expression named "RowNumber".

Insert a new column on the left side and name it "Serial No."
Create the expression by right-clicking on that column as in the following:
Select the "Miscellaneous" as a category and "RowNumber" as an item, then expression will be like:

=RowNumber(nothing)

Where the nothing keyword indicates that the function will begin counting at the first row in the outermost data region. Click the "OK" button.
Run the "Default.aspx" page.