Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    report - page 2 - duplex (A2k3, SP1)

    Hi All,
    I'm trying to format a report which will have a page 2 duplexed.
    I'm trying to place a page break so that after the detail section, no matter how many records there are in it, page 2 will print. There will be 1 (min) to 3 (max) records in the details (the detail section in design mode is about 2" wide).
    Please, any ideas where I can start?

    gdr
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

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

    Re: report - page 2 - duplex (A2k3, SP1)

    I don't understand your description. Can you describe more clearly what you want to do, perhaps with an example?

  3. #3
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report - page 2 - duplex (A2k3, SP1)

    Hi Hans,
    Please excuse the tardiness of this reply.
    Attached is a db with 2 design trials of the report and a table made from the original source query. (Re:rptScheduledAppointment_trial) Ideally when this report is sent to an Agency in question a maximum of 3 Clients and their related information, should appear on the front page of this report, followed by page 2 (duplexed), which is the portion of the Details section following the page break. If there are more than 3 records, then any excess, to a maximum of 3, would go on page 3, again followed by page 4 (another iteration of Page 2) duplexed. Ditto for any subsequent records.
    I've been thinking that somehow using the RecordCount and making the PageBreak visible/invisible may work, but I am unsure of where to place the code and unsure of how to let the PageBreak "know" the proper amount of records have been submitted.

    Thank you.

    gdr
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

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

    Re: report - page 2 - duplex (A2k3, SP1)

    You need a field that uniquely identifies each record. Strangely enough, the AutoNumber field in your table contains duplicates, so it can't be used for this purpose. I used ClientPKID in the attached version, but of course I don't know if that is unique in the real data.
    I created a query based on the table, and added a calculated column

    D: DCount("*","ReportTest_1","ClientPKID<" & [ClientPKID])3

    I set the record source of the report to this query, and grouped it by D. I put the related info in the group footer for D, and set the Force New Page for this footer to After Section.

  5. #5
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report - page 2 - duplex (A2k3, SP1)

    Hi Hans and Thank YOU!!
    I never would have gotten to that!!! <img src=/S/nope.gif border=0 alt=nope width=15 height=15>
    The ClientPKID, in this table, as well as in the report's record source query, is unique. About the Autonumber field.....I just forgot to remove that field (that field is not even used in the query) after playing with the query and before making the table used in the attachment.

    Wow, Thanks again. <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

    gdr
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

Posting Permissions

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