Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Page Numbering (Page N of M) problem in group Post Reply Post New Topic
Author Message
ponyo8
Newbie
Newbie


Joined: 31 Oct 2009
Location: United States
Online Status: Offline
Posts: 2
Quote ponyo8 Replybullet Topic: Page Numbering (Page N of M) problem in group
    Posted: 31 Oct 2009 at 9:19am
Hi,
 
I am creating a form that has alot of data and grouping in that form.
The grouping order from top to bottom - Policy Number, Claimant Name, Check Number, Envelope Name and Claim Number.
 
One policy can have multiple claimant name, for example: James Smith (the primary policy holder - first claimant) can have Linda Smith as the dependent (second claimant) and each of them can have claims under each of them with different claim numbers. They both can receive ONE check for both people expenses.
 
So lets say the format of the form is going to be like this....
 
(Page 1 of the form)
-- Report Header is suppressed
 
-- Page Header is filled with Company Name and Address - generic (will display on every page)
 
-- Group Header - Policy Number is suppressed
 
-- Group Header - Claimant Name is suppressed
 
-- Group Header - Check Number is suppressed
 
-- Group Header - Envelope Name is filled with data below:
 
Envelope Name: James Smith (same envelope name)
Policy Holder     : James Smith (same policy holder)
Policy Number  : 123456789 (same policy number)
Claimant Name : James Smith (different claimant name)
Check Number  : 0000012345 (same check number)
 
-- Group Header - Claim Number is filled with heading of the claim details:
 
Claim No : 001
 
Service                           Amount                 Medical Code
______________________________________________
 
-- Detail Section
 
Prescriptions                       $50                              5
Surgery                               $500                           10
 
-- Group Footer - Claim Number - empty but not suppressed
 
-- Group Footer 4a - Envelope Name is suppressed
 
-- Group Footer 4b - Envelope Name has a subreport in it.
 
(Subreport to put desription of Medical Code)
 
Medical Code:
5 - Pharmacy
10 - Hospital fee
 
-- Group Footer 4 c - Envelope Name - empty but not suppressed
 
-- Group Footer - Check Number is suppressed
 
-- Group Footer - Claimant Name is suppressed
 
-- Group Footer - Policy No is suppressed
 
-- Report Footer is suppressed
 
-- Page Footer  -  this is where I put the page numbering
 
                 ---------- Page N of M--------- Now it says Page 1 of 1 on Page 1... I need this to say Page 1 of 2 because this form is going to James Smith for both pages.... Its sending to ONE Envelope Name which is The Primary Policy Holder Name.
 
 
(Page 2 of the form)
-- Report Header is suppressed
 
-- Page Header is filled with Company Name and Address - generic (will display on every page)
 
-- Group Header - Policy Number is suppressed
 
-- Group Header - Claimant Name is suppressed
 
-- Group Header - Check Number is suppressed
 
-- Group Header - Envelope Name is filled with data below:
 
Envelope Name: James Smith (same envelope name)
Policy Holder     : James Smith (same policy holder)
Policy Number  : 123456789 (same policy number)
Claimant Name : Linda Smith (different claimant name)
Check Number  : 0000012345 (same check number)
 
-- Group Header - Claim Number is filled with heading of the claim details:
 
Claim No : 002
 
Service                           Amount                 Medical Code
______________________________________________
 
-- Detail Section
 
Office Visit                           $100                           2
MRI                                     $500                            7
 
-- Group Footer - Claim Number - empty but not suppressed
 
-- Group Footer 4a - Envelope Name is suppressed
 
-- Group Footer 4b - Envelope Name has subreport
 
(Subreport to put desription of Medical Code)
 
Medical Code:
2 - Physician's Fee
7 - Imaging Fee
 
-- Group Footer 4 c - Envelope Name - empty but not suppressed
 
-- Group Footer - Check Number is suppressed
 
-- Group Footer - Claimant Name is suppressed
 
-- Group Footer - Policy No is suppressed
 
-- Report Footer is suppressed
 
-- Page Footer  -  this is where I put the page numbering
 
                 ---------- Page N of M--------- Now it still says Page 1 of 1 on Page 2 as well... I need this to say Page 2 of 2 because this form is going to James Smith too... Its sending to ONE Envelope Name which is the same Primary Policy Holder Name as page 1.
 
 
The section expert for this form (the box that is being checked off)
Report Header -> Suppress, Keep Together
Page Header - (nothing checked)
Group Header #1- Policy Number -> Suppress, Keep Together
Group Header #2 - Claimant Name -> Suppress, Keep Together
Group Header #3 - Check Number -> Suppress, Keep Together
Group Header #4 - Envelope Name -> Keep Together
Group Header #5- Claim Number -> Keep Together
Details -> Keep Together
Group Footer #5 - Claim Number -> Keep Together
Group Footer #4 - Envelope Name -> (nothing checked)
     Group Footer #4a - Envelope Name -> Suppress, Keep Together
     Group Footer #4b - Envelope Name (where the subreport located) ->
                                     Keep Together, Suppress Blank Section
     Group Footer #4c - Envelope Name -> New Page After, Reset Page
                                     Number After, Keep Together
Group Footer #3 - Check Number -> Suppress, Keep Together
Group Footer #2 - Claimant Name -> Suppress, Keep Together
Group Footer #1 - Policy Number -> Suppress, Keep Together
Page Footer -> (nothing checked)
Report Footer -> Suppress, Keep Together
 
Each claim is separated by line break
Each new claimant is separated by page break
 
BUT the page numbering is by envelope name group... but the way i put things together like i showed you above, i dont get the right page numbering. For both pages are showing 1 of 1... not 1 of 2 on first page and 2 of 2 on the second page. I am not sure if i get the grouping order wrong or if i checked wrong things on the section expert.... I dont know what i did that causing this and i have kept on moving the 'Page N of M' field around in different group footer but it still doesnt work... Please help me... THANK YOU VERY MUCH!
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Nov 2009 at 6:06pm
I think you will want to change your "Reset Page Number after" to Group header2 as a formula of
NOT onfirstrecord
 
Do not reset it on group footer 4c


Edited by DBlank - 01 Nov 2009 at 6:06pm
IP IP Logged
smk2001in
Newbie
Newbie
Avatar

Joined: 06 May 2010
Location: India
Online Status: Offline
Posts: 1
Quote smk2001in Replybullet Posted: 06 May 2010 at 12:26am
i m using vs 2005. i have designed crystal report and i inserted special field Page N of M. but it shows Page 1 of 1, Page 2 of 1, Page 3 of 1 ... etc. i placed this in page footer section. please help me.
Mukesh
IP IP Logged
hongclub
Newbie
Newbie


Joined: 11 Feb 2011
Location: United States
Online Status: Offline
Posts: 5
Quote hongclub Replybullet Posted: 13 Feb 2011 at 7:46am
did you solve the problem? i have the same issue too.

Tommy
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.