Print Page | Close Window

Custom Page Numbering

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22536
Printed Date: 28 Mar 2024 at 1:40am


Topic: Custom Page Numbering
Posted By: Becantor
Subject: Custom Page Numbering
Date Posted: 02 Feb 2018 at 7:52am
Hi,

Have a report that is just a single report (no embedded sub reports).

The report may be anywhere from 10-15 pages depending on add on pages, however, I would like the page counter to 'ignore' these additional pages and only have a hard page counter from 1 to 10.

So, even if the report is 15 pages, I want the page counter to read 'Page 1 of 10, Page 2 of 10, etc. Once it reaches page 10 of 10 it would be suppressed.

Any ideas on how to hard code the page number range?

thanks



Replies:
Posted By: hilfy
Date Posted: 08 Feb 2018 at 6:56am
Here's what I would do:

1. For the label in header or footer, place a text block in the report and type in "Page of 10". Then drag "Page Number" from the Special Fields in the Field Explorer to the appropriate spot in the text block. It will embed itself into the text if you do this correctly.

2. If the page number is in a section by itself, open the Section Expert. Otherwise right-click on the text block and select "Format Text...". In either case, click on the formula button to the right of "Suppress" (DO NOT check the Suppress checkbox!). Add this to the suppress formula:

PageNumber > 10

Save the formula.

This will suppress the display of the page number block when you're on pages that are past the 10th page.

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Posted By: bhanson
Date Posted: 07 Nov 2018 at 12:17am
Originally posted by hilfy

Here's what I would do:

1. For the label in header or footer, place a text block in the report and type in "Page of 10". Then drag "Page Number" from the Special Fields in the Field Explorer to the appropriate spot in the text block. It will embed itself into the text if you do this correctly.

2. If the page number is in a section by itself, open the Section Expert. Otherwise right-click on the text block and select "Format Text...". In either case, click on the formula button to the right of "Suppress" (DO NOT check the Suppress checkbox!). Add this to the suppress formula:

PageNumber > 10

Save the https://www.fitnessdonkey.com/ebook-reviews/james-bauer-his-secret-obsession - his secret obsession book formula.

This will suppress the display of the page number block when you're on pages that are past the 10th page.

-Dell


Thanks for the detailed guidelines. It really helped. Thank you!



Print Page | Close Window