Posted by Erland Sommarskog on 10/02/16 11:48

lucky (j.v.s.s.baba@gmail.com) writes:
> 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.

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
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Output stored procedure
• Prev in forum: Re: using lookup and display only field as control field
• Thread view: Re: Limiting Rows in a Report

[Reply to this message]