CodeGuru Forums -
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic Newsletters VB Forums Developer.com


Newest CodeGuru.com Articles:

  • SQL Server Modeling Services with Microsoft Visual Studio 2010 Beta 2
  • Faltering Windows support
  • Internet Explorer 8 Click Clever Click Safe
  • Release Candidate 2 for ASP.NET MVC 2

  • Search CodeGuru:
     



    Go Back   CodeGuru Forums > Visual Basic Programming > Crystal Reports
    FAQ Members List Calendar Search Today's Posts Mark Forums Read

    Reply
     
    Thread Tools Search this Thread Rate Thread Display Modes
      #1    
    Old October 31st, 2009, 01:29 PM
    Ponyo8 Ponyo8 is offline
    Junior Member
     
    Join Date: Oct 2009
    Posts: 1
    Ponyo8 is an unknown quantity at this point (<10)
    Unhappy Page Numbering problem

    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!
    Reply With Quote
    Reply

    Bookmarks
    Go Back   CodeGuru Forums > Visual Basic Programming > Crystal Reports


    Thread Tools Search this Thread
    Search this Thread:

    Advanced Search
    Display Modes Rate This Thread
    Rate This Thread:

    Posting Rules
    You may not post new threads
    You may not post replies
    You may not post attachments
    You may not edit your posts

    BB code is On
    Smilies are On
    [IMG] code is On
    HTML code is Off
    Forum Jump


    All times are GMT -5. The time now is 12:07 PM.



    Acceptable Use Policy


    The Network for Technology Professionals

    Search:

    About Internet.com

    Legal Notices, Licensing, Permissions, Privacy Policy.
    Advertise | Newsletters | E-mail Offers


    Powered by vBulletin® Version 3.7.3
    Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.