 |
|||
 |
|||
 |
|||
|
|||||||||
|
Crystal Reports Tools: Improve Performance While Saving Time and Money |
|
Crystal Reports: Page number startSometimes, our Crystal Report ends up in a larger collection of corporate documents. To fit better into this environment, it could be useful to have our Crystal Report start on a page other than page one.If several reports are to appear at pages 30, 40, and 65, we can use a formula and a parameter to adjust the sequence of our pages. The parameter is a number and asks "What Page to start at?" The new formula used for the page number is: PageNumber + {?FirstPage} –1 // Subtract one to start on the first page You can use a similar approach if you want to show page count. But as that needs to count the pages in the reports that have yet to be printed, you might like to omit page count from the report.
It's usually better to put the page number in the footer, rather than in the header. Why? Because that's not "headline" information. It's really tertiary, so it's best to have it at the bottom. You can use two page footer sections for odd and even page footers. If you look at any professionally prepared bound, double sided publication you will see the page footers are different on the odd and even pages. The Even numbered pages on the left of the binding often have the page numbers on the left, and other copyright information on the right, while the right hand, odd numbered pages have these fields the other way around. The theory is that if you are looking for a specific page number, then you can thumb along the pages and see all the page numbers on the outer edge of the document. You can achieve the same effect in your Crystal Reports by using a Page Footer a and Page Footer b section with the two layouts you want. Then conditionally suppress the sections using a formula of Remainder(PageNumber,2)=0 //To suppress if page number is even And Remainder(PageNumber,2)=1 //To suppress if page number is odd You might also want to use the section formatting option "Reserve Minimum Page Footer" to give you a little more room for data on the page.
Since you're working on the page footer, let's discuss another issue. If you look at any professionally prepared bound, double sided publication you will see the page footers are different on the odd and even pages. The Even numbered pages on the left of the binding often have the page numbers on the left, and other copyright information on the right, while the right hand, odd numbered pages have these fields the other way around. The theory is that if you are looking for a specific page number, then you can thumb along the pages and see all the page numbers on the outer edge of the document. You can achieve the same effect in your Crystal Reports by using a Page Footer a and Page Footer b section with the two layouts you want. Then conditionally suppress the sections using a formula of Remainder(PageNumber,2)=0 //To suppress if page number is even And Remainder(PageNumber,2)=1 //To suppress if page number is odd You might also want to use the section formatting option "Reserve Minimum Page Footer" to give you a little more room for data on the page. See below for some good info and tips on formatting.
This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects. |
