Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Format Help? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    The attached DB is in a97 format

    Open frm_SBF_PrintCheckDialog and click EOB button

    The attached report prints OK with exception of it printing two copies each for two patients who have multiple claims, there should only be one page for both claims.

    The test DB is printing 37 EOBís, I want it to print only 35, see page 5 & 6 and 8 & 9, what do I have to change to print only one page (with both claims) for Renee Beam & Marie Heine

    Thanks, John
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Format Help? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    The design of the report is so convoluted that it's very difficult for me to understand what it does, but you should either change the record source to a query that groups by the relevant field(s) so that there are no duplicates, or group the report by the relevant field(s) and place the controls in the group header instead of in the detail section.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Format Help? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Reworking the query did the trick, thanks for your help

    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •