Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-07-18 : 14:48:14
|
| Is it possible to have an auto number line? For example first line is 1, 2, 3, 4, 5 etc.. |
|
|
jhermiz
3564 Posts |
Posted - 2005-07-18 : 14:57:26
|
Where do you want to place this auto number ?
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-07-18 : 15:18:04
|
| It doesn't matter, but was thinking about doing it within Reporting Services. I have a long list and it would help if I aut number it for easier viewing for the user. |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-07-18 : 15:25:15
|
Simple two ways to do it:1) The hard way to number it directly in SQL (yuck)2) The simple way to use the RowNumber function in Reporting ServicesHere is an example for you, create a report using the report table. In one of the text boxes type the following:=RowNumber(Nothing)Place this say in the details sectionRun the report and you will notice each line number has a number associated with it.For more info consult RS Books Online using the RowNumber function.Good day!Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-07-18 : 16:25:11
|
| Awesome Jon!!! Didn't know it was that simple. I was looking for auto numbering in Books online but did not find that. Guess it was row numbering.Million Thanks. |
|
|
|
|
|
|
Auto Numbering