Print Page | Close Window

Page numbers

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21240
Printed Date: 05 May 2024 at 5:04am


Topic: Page numbers
Posted By: Kitty1
Subject: Page numbers
Date Posted: 27 Dec 2014 at 6:06am
Hi, why would special field "page N of M" show 1 of 1 pages on every page, when it should be 1 of 60, 2 of 60, etc.   i am really confused, this has never happened before.


Replies:
Posted By: Dr4ke
Date Posted: 29 Dec 2014 at 10:42pm
Where have you put the page number formula? I.e. which section?

Posted By: Kitty1
Date Posted: 30 Dec 2014 at 2:37am
in the page footer section

Posted By: Dr4ke
Date Posted: 30 Dec 2014 at 2:44am
What is being displayed in the report; are you using the details section to display data or are you using subreports in a different section(s)?

Is the page number showing as '1 of 1' on every page or only on one/a selection of pages and nothing on the rest?

This will be quite difficult to diagnose without seeing the report but I can keep asking questions and offering suggestions to try and help pin it down.

Posted By: Kitty1
Date Posted: 30 Dec 2014 at 2:47am
it's a pretty straightforward report. just has a report header, page header, details, report footer and page footer. no sub-assemblies.   


Posted By: Dr4ke
Date Posted: 30 Dec 2014 at 2:53am
Is the page number showing as '1 of 1' on every page or only on one/a selection of pages and nothing on the rest?

Have you tried deconstructing the report bit-by-bit to see if it fixes it?

Posted By: Kitty1
Date Posted: 30 Dec 2014 at 3:05am
it says 1 of 1 on every single page.   i'm not sure what you mean about deconstructing?

Posted By: Dr4ke
Date Posted: 30 Dec 2014 at 3:10am
It sounds like the report doesn't know how many pages you have so it reverts everything to 1 of 1.

By deconstruct I mean try creating the report again, bit by bit, and see when the page numbers stop working. If it's a simple report it hopefully shouldn't take too long to remake but might give you an indication of what's causing the problem.

Posted By: Kitty1
Date Posted: 30 Dec 2014 at 3:13am
Report footer is above page footer, could that be the problem and if so, is there an easy way to switch them?

Posted By: Dr4ke
Date Posted: 30 Dec 2014 at 3:17am
No that's how it should be - as long as you don't have any data in the Report Footer then it shouldn't be causing an issue.

Can you share the .rpt file?

Posted By: Kitty1
Date Posted: 30 Dec 2014 at 3:35am
sure, how do i do that? just email and attach it ?

Posted By: DBlank
Date Posted: 30 Dec 2014 at 3:54am
If you have not already dione so, open the section expert
work your way through each section and make sure that "Reset page number after" is not checked on any section and that none of them have a condditional formua to activate that function.
Given your description the Detail section is the most likely location that this is being set at.

Posted By: Kitty1
Date Posted: 30 Dec 2014 at 4:02am
great! that did it!!!! :)    I don't know why that would have been checked, but it solved the problem. Thank you so much for all of your help and a very Happy New Year to you!!!

Posted By: Dr4ke
Date Posted: 30 Dec 2014 at 4:04am
I forgot the obvious :-)

Well done DBlank!

Posted By: Kitty1
Date Posted: 30 Dec 2014 at 4:12am
thank you both for responding to me. I appreciate it! :)   and Happy New Year to both of you.

Posted By: Dr4ke
Date Posted: 30 Dec 2014 at 4:14am
You are most welcome. HNY


Print Page | Close Window