Adding serial numbers to rows in Report builder

Question

Post reply

Adding serial numbers to rows in Report builder

s.lekha

Right there with Babe

Points: 766
More actions
January 2, 2009 at 1:58 am

#217049

Hi all,
It's been quite sometime that i have been working on reports using report builder, iam not able to figure out as of how to add a serial number to every row in a report using report builder, can anyone help me with this?
Thanks for your help,
Regards,
lekha

Viewing 11 posts - 1 through 10 (of 10 total)

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

ramu.valleti SSCrazy Points: 2229 More actions · Answer 1

Use RowNumber(Nothing)

Ramu
No Dream Is Too Big....!

s.lekha Right there with Babe Points: 766 More actions · Answer 2

Hi,

Thanks for your reply.

I have created a report with a set of fields dragged and dropped from the entity field set, i want to add an extra column just to display the serial number, iam not able to do this since the builder does not allow me to add a column which does not belong to the entity. Hence, if i have to add rownumber() function in the formula field to a new column which is not a field in the entity field set , how do i do it? coz, there is no function called rownumber() in the functions tab in report builder.

mohamed_khateeb SSC Enthusiast Points: 115 More actions · Answer 3

Right click on the row you want to add the serial then Expression ---> Common Function (on the left) ---> Miscellaneous ---> Then Double click on RowNumber

and write (nothing)

Regards

s.lekha Right there with Babe Points: 766 More actions · Answer 4

Hi,

The expression function is for report designer, but how do i add it for a report builder, this has a predefined set of functions where rownumber() is not a part of it, so is there any other option?

mohamed_khateeb SSC Enthusiast Points: 115 More actions · Answer 5

mohamed_khateeb

SSC Enthusiast

Points: 115

January 9, 2009 at 8:18 am

#924217

Sorry, i don't know

jayasabarik SSC Journeyman Points: 77 More actions · Answer 6

jayasabarik

SSC Journeyman

Points: 77

March 27, 2009 at 11:10 pm

#967829

Thanks for your answer. It's working.

sheetalchordia Valued Member Points: 72 More actions · Answer 7

Thanks a ton for your answer. its working. Altho, Ronumber(Nothing) can only be used as an expression, we cannot use this for the interactive sort. Any idea?

ezytime SSCommitted Points: 1846 More actions · Answer 8

If you're using SQL Server 2005 or later, using the ROW_NUMBER() function as an extra column in your SQL query would let you use the number in Report Builder as well as in an Interactive Sort expression.

ashwini.waghole SSC Journeyman Points: 79 More actions · Answer 9

Hello I have same problem about sr no. Please tell me the solution which u got

🙂

becklery Hall of Fame Points: 3315 More actions · Answer 10

Hi, s.lekha.

As I know, you can have a try of RAQ Report. Using it, you can add serial numbers to rows in report with easy operations.

1. Set Report style as Row report and set Input type as Input Report. As shown below:

2. Write starting value expression and define rules for steady increment or decrement. As shown below:

Then, the report will be shown as below:

RAQ Report: Web-based Excel-like Java reporting tool[/url]