Solved: Matrix Row Number in SSRS 2005

Create Account

Microsoft SQL Server

Questions

Followers

Top Experts

Sandesh_Ingawale

Matrix Row Number in SSRS 2005

How to generate row number 1,2,3,4,5,6,........... of matrix row in SSRS 2005
I am trying Row Number for serial number but its difficult. Following result is in matrix

SR No.      Roll Number            Registration Code            Student Name
1      AS01-2            110905003            ADKAR SHARDUL SURESH
2      AS01-3            110901002            ADMUTHE AJINKYA RAJENDRA
3      AS01-4            110913070            ADSUL PRANITA PRAKASH
4      AS01-5            110909028            AGRAWAL GOWARDHAN
5      AS01-6            110905005            AGRAWAL NITESH DATTULAL
6      AS01-7            110908004            AGRAWAL SHIVANG UMESH
7      AS01-8            110910144            AGRAWAL VINEET DINESH
8      AS01-9            110908001            AHER SAGAR GANPATRAO
9      AS01-10            110907050            AHIRE AKSHAY ANIL

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

rashmi_vaghela🇮🇳

hi try this link
http://www.kodyaz.com/articles/article.aspx?articleid=52
https://www.experts-exchange.com/questions/23440459/SQL2005-Reporting-Services-and-RowNumber.html

Sandesh_Ingawale

ASKER

I am using matrix and this solution is for table. I want solution for matrix.

ASKER CERTIFIED SOLUTION

Tim Humphries🇬🇧

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

Sandesh_Ingawale

ASKER

Hi Tim,
I am using your function and its very good data will display as I want , but there is 1 Problem , when this report will export in Acrobat PDF OR display in print Layout that time it start with 71, I don't know why?

Sandesh

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Sandesh_Ingawale

ASKER

Hi Tim,
Result of my report is in 70 Rows.
Thanks,
Sandesh

SOLUTION

Tim Humphries🇬🇧

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

Sandesh_Ingawale

ASKER

Hi Tim,

Please find attachment of report. This report is in excel. But when this same report is display in Pdf, the sr. No. Column is start from 71. I am attaching .pdf fiilr screen shot also.
In design time I am using function that sent by you.

public dim LastSerNo as String
public dim rowCount as int32 = 0

Public Function GetRowNo(byval SerNo as String) as Integer

if SerNo <> lastSerNo then
rowCount = rowCount + 1
LastSerNo = SerNo
End If
Return rowCount
End Function

and in textbox exppression of matrix 1st column 2nd row is =Code.GetRowNo(Fields!StudentRegCode.Value)

Sandesh

SemesterwiseCreditRegistration.xls
Rep-1.JPG

SOLUTION

Tim Humphries🇬🇧

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

Sandesh_Ingawale

ASKER

Thank You very Much Tim, Now its working fine,

Thanks a lot.

Sandesh

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Sandesh_Ingawale

ASKER

Very good solution and it seems proper ans with in time.

Microsoft SQL Server

Questions

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.