Limiting Rows in a Report -- sql server (alternate)

lucky
5/25/2006 6:30:14 AM

Hello,
i am in a problem that i am having a table with 100 rows while i am
presenting in report i want to limit rows to be 10 in a page in the
report like that i want to get 10 pages .Please say me the procedure
for this.
Thanks,
Baba.

Erland Sommarskog
5/25/2006 2:20:16 PM

lucky (j.v.s.s.baba@gmail.com) writes:
[quoted text, click to view]

I would suggest that you are better off asking this in a forum for the
report tool you are using. Surely you do not intend to requery the
database foe each page? Surely the report tool must permit you to define
a page size?

If the reporting tool is Reporting Services, tryu
microsoft.public.sqlserver.reportingsvcs.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at

sql server (alternate) : Limiting Rows in a Report