Limiting A report to 2 Pages

Last Post 26 Feb 2005 10:36 AM by EspressoWillie. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
madhusd
New Member
New Member

--
18 Feb 2005 05:13 AM
How can I limit a report to exactly 2 pages ? If the data is lesser than 2 pages, insert blank spaces at the end and make it two pages or if the data is greater than 2 pages, only display 2 pages per record. The entire report is many pages, but i want only 2 pages per record.
Can anyone provide some insight into this ?
EspressoWillie
New Member
New Member

--
26 Feb 2005 10:36 AM
Seems like an interesting request. I haven't heard of adding blank records to make it 2 pages. You should be able to control number of pages by figuring out how many records you need to fill 2 pages. In your query, add the TOP parameter (ie. Select top 10 ...). As for adding blank records, you could always UNION a dummy table to your select full of blank records (2 pages worth).
You are not authorized to post a reply.

Acceptable Use Policy