I have written a report that acts like an account receivable statement. There is a statement for each individual account but it is all within one report thats a couple of hundred pages long. My client has requested page numbering for each individual statement, especially if one statement spans more that one page. If a statement is 3 pages long, they want "page one of three, page two of three, page three of three" and then have the page numbering start over again for the next statment. I'm thinking this can be achieved through the use of variables but I just can't put it together in my head. Any help would be appreciated!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
page numbering 1
- Thread starter mmwdmr
- Start date
What version of Crystal are you using? In 8.5 you can do this automatically, (I can't remember if its available in 8.0?) Let me know what version and I ll walk you through it if I can.
LMC cryerlisa@hotmail.com
select * from Management where proj_mgmt_skills <> NULL
0 records returned
LMC cryerlisa@hotmail.com
select * from Management where proj_mgmt_skills <> NULL
0 records returned
-
1
- #3
You want to insert a group for each statement (you can supress printing of the group header and footer if you don't want to print them). Next left click on the group footer section and select "format section". Check the box next to "Reset Page Number After". This should renumber pages after each group.
- Thread starter
- #5
To LMCryer: I am on version 8, my client is on 8.5 so I can go either way. I would like to know how this is done in both versions, automatically and otherwise.
To MrBillSC: The statement is already grouped by account number so I can try your solution right away. Thanks!
To MrBillSC: The statement is already grouped by account number so I can try your solution right away. Thanks!
- Thread starter
- #6
To MrBillSC: I tried your solution and it didn't work. I think it's because this report is put together kind of weird and has had a lot done to it over a period of several months.
I checked the reset page number after in the group footer and it worked until a statement spanned more than one page. On a statement that is 3 pages long, the page number doesn't even show up on the first page but the second and third are numbered. I'm having a similar problem getting the group header to repeat at the top of each page - when the detail takes a whole page and the group footer (total balance) is orphaned on the next page, I lose my group header (thread 767-259155). It's got to be related.
Any ideas?
I checked the reset page number after in the group footer and it worked until a statement spanned more than one page. On a statement that is 3 pages long, the page number doesn't even show up on the first page but the second and third are numbered. I'm having a similar problem getting the group header to repeat at the top of each page - when the detail takes a whole page and the group footer (total balance) is orphaned on the next page, I lose my group header (thread 767-259155). It's got to be related.
Any ideas?
How are you numbering your pages???
Have you placed the Special Field: page M of N at the bootpm of the page in the page footer
In the section expert as described earlier by others
for the group footer for account number set the following options : "New Page After" and "Reset Page After"
If you want the group Headers to repeat on each new page then enter the "Change Group" and enable the option to repeat group header on a new page.
If this doesn't solve your problem then there is something else fundamentally wrong with your report and you will have to layout more details about how the report is constructed. Jim
JimBroadbent@Hotmail.com
Have you placed the Special Field: page M of N at the bootpm of the page in the page footer
In the section expert as described earlier by others
for the group footer for account number set the following options : "New Page After" and "Reset Page After"
If you want the group Headers to repeat on each new page then enter the "Change Group" and enable the option to repeat group header on a new page.
If this doesn't solve your problem then there is something else fundamentally wrong with your report and you will have to layout more details about how the report is constructed. Jim
JimBroadbent@Hotmail.com
- Thread starter
- #8
The page numbering field was inadvertently put in the wrong section. Once I bumped it down to the page footer, it worked like a charm - an embarrasingly easy solution. Thanks!
As for the repeated group header issue. I do have it set in the change group expert and it works fine until it runs into an account whose details take up the whole first page and the group footer (which is the account balance) ends up orphaned on the second page. That's when I lose my repeated group header. There is even a workaround for this in the Crystal Knowledge Base (article c2004981) that I couldn't get to work either. So, I don't know - I'm going to keep working with it...
As for the repeated group header issue. I do have it set in the change group expert and it works fine until it runs into an account whose details take up the whole first page and the group footer (which is the account balance) ends up orphaned on the second page. That's when I lose my repeated group header. There is even a workaround for this in the Crystal Knowledge Base (article c2004981) that I couldn't get to work either. So, I don't know - I'm going to keep working with it...
It is difficult when a page footer splits over to a new page...Crystal seems to think it is on the same page for some reason...so it doesn't repeat the header
one solution for me was to count the detail lines as they were printed. The footer usually was a fixed size so I knew how much room to allocat for it. So when a detail count exceeded a certain point I conditionally split to a new page.
It left a bit of white space at the bottom of the first page but actually looked better overall since there is nothing worse than seeing just a line or two of footer on 2 pages.
So you might give that some thought Jim
JimBroadbent@Hotmail.com
one solution for me was to count the detail lines as they were printed. The footer usually was a fixed size so I knew how much room to allocat for it. So when a detail count exceeded a certain point I conditionally split to a new page.
It left a bit of white space at the bottom of the first page but actually looked better overall since there is nothing worse than seeing just a line or two of footer on 2 pages.
So you might give that some thought Jim
JimBroadbent@Hotmail.com
Hi
Hope you guys can help me with a similar problem. I have 2 groups with the group footer options set to 'New Page After' and 'Reset Page After..' Oddly enough, the PageNofM doesn't work consistantly.
First record that overflows to the next page is displayed as Page 1 of 1 on both pages while the second record (also overflowing to the second page) is displayed correctly as Page 1 of 2 and Page 2 of 2.
The page count is somehow reset or there seems to be some kind of page break for the count to reset...
Please help..
Celine
celinekoe@yahoo.com
Hope you guys can help me with a similar problem. I have 2 groups with the group footer options set to 'New Page After' and 'Reset Page After..' Oddly enough, the PageNofM doesn't work consistantly.
First record that overflows to the next page is displayed as Page 1 of 1 on both pages while the second record (also overflowing to the second page) is displayed correctly as Page 1 of 2 and Page 2 of 2.
The page count is somehow reset or there seems to be some kind of page break for the count to reset...
Please help..
Celine
celinekoe@yahoo.com
Yay! I've managed to solve my page numbering problem.
Because of the 2 groupings with 'New Page After', somehow, a blank page is inserted between the outer group and it messed up the page number sequence.
Well no idea if that is the actual problem... but Ive added an extra condition at the 'New Page After' so that a new page is not inserted in the inner group...
Well thanks anyway!
Celine
Because of the 2 groupings with 'New Page After', somehow, a blank page is inserted between the outer group and it messed up the page number sequence.
Well no idea if that is the actual problem... but Ive added an extra condition at the 'New Page After' so that a new page is not inserted in the inner group...
Well thanks anyway!
Celine
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question