Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Limiting Reports (A97 W2K)

    I have a 42 page report that has a number of near blank pages, there are over a hundred fields in the detail section so each "Row" of data fills one page.
    What I would like to do is skip pages where certain key data is not available. any ideas of how to do this from the report rather than from the underlying query? ( it is messy enough already <img src=/S/exclamation.gif border=0 alt=exclamation width=15 height=15> )

    Many Thanks

    peter

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Limiting Reports (A97 W2K)

    Assuming that the data you want to skip is in the detail section, use the OnFormat event of that section to test the values you want to be there. If they aren't, you can Cancel the format and set MoveLayout to false. That will skip formatting the section for that record and just go on to the next without inserting any blank space for the current detail section.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limiting Reports (A97 W2K)

    Many Thanks :-)

Posting Permissions

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