Hi All,
I am new to RS2000 but have made a report that i need to have 1 record shown per page.
the paper i am going to print to is 254mm x 178mm.
I cant seem to figure this one out so any help or advise is most welcome
Single record per page
Hot Topic
- Question on MDX
- Export XML data to File
- Convert SQL 2005 to SQL 2000
- SQL Server 2005 Express limits
- sp_spaceused and filegroups
- How to use sum and count aggregate functions with xml data type in SQL Server 2005
- Storage of packages: file system or Sql Server?
- BOL Package example Errors
- BUG: SSIS imported package errors with 'Guid should contain 32 digits with 4 dashes'
- Criteria validation Reporting Server
SQL Server
- Going from Express to SQL 2005 Standard
- Connection String Question.
- Encryption of Data in SQL05
- ODB Datareader time columns
- SQL 2005 server seems to get slower and slower each night it runs
- SSIS will not start after SQL Server 2005 SP1 upgrade
- Hierarchy
- Management Studio doesn't run!
- Programatically Evaluating SSIS Expression
- Using SSMS to Manage SSIS
Single record per page
AGuther
You can a grouping to your data region, use RowNumber() function to control how many records belong to each group, and add a pagebreak on the group. This page contains a sample of how to do this http://msdn2.microsoft.com/en-us/library/ms157328.aspx (scroll to the page breaks section).