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 - 2010-01-04 : 14:42:30
|
| My report consists of 23 subreports. The main page lists all the subreports and page numbers. I have a table on the main page that displays the page numbers and report names. The reports and pages are listed based on a parameter. Depending on the parameter chosen it's possible that all the subreports will be run. Instead of listing them all in a long single column I would like to list the reports in 2 columns. Is it possible to limit the number of rows in a table so I can list 12 reports in one column and the remaining in the other? |
|
|
jbphoenix
Yak Posting Veteran
68 Posts |
Posted - 2010-01-04 : 14:58:10
|
| I figured out a way to do it using Rownumber. |
 |
|
|
|
|
|
Limit rows in a table??