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!