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 |
|
jbphoenix
Yak Posting Veteran
68 Posts |
 Posted - 2009-12-18 : 14:36:45
|
| I have a report that has 24 subreports. There is a cover page that has the title, month, Client(comes from a parameter) and also lists all the reports. Depending on the client not all the subreports are displayed. The cover page looks something like this - TitleClientDate1. Cover2. Report13. Report24. Report3all the way up to 24.Right now the list is in a table. How might I make it so the reports are numbered automatically. For example, say client ABC does not have Report2. Report3 then will be on page 3 not 4. |
|
|
Tahumars
Starting Member
15 Posts |
Posted - 2009-12-21 : 11:20:53
|
| When you say the list is in a table, do you mean a database table or a table object on the report? If it's in the database table, you can use the ROW_NUMBER() function to number your row results. If you mean a report table, there is a RowNumber function you can use for the column expression under Common Functions -> Miscellaneous. |
 |
|
|
|
|
|
Automatic numbering