SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 07:29 PM
| ||||
| ||||
 Limiting Rows in a Report 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.      |
|
02-29-2008, 07:29 PM
| ||||
| ||||
| Re: Limiting Rows in a Report 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/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
Linear Mode
