Results 1 to 12 of 12
  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Snapshot Report Problem (2003)

    I have a report set up that contains a sub-report associated with each record. It prints perfectly. I then set up an control to create an email with the report attached n Snapshot format. It prints the first record (which takes up the entire first page) with the sub-report OK, but all successive records do not include the sub-report portion. Any thoughts on this curious performance?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

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

    Re: Snapshot Report Problem (2003)

    Have you tried exporting the report to snapshot format manually? What is the result?

  4. #3
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Snapshot Report Problem (2003)

    On my wife's computer rujnning Access 2002 I have a report that includes a sub-form in each record. This prints correctly on her computer. I copy the Access file to my computer (Access 2003) and the first record prints OK along with the sub-form. However, the second and following records do not include the sub-form. This is really a weird one and I don't have a clue. It is rather irritating, however, as I normally maintain my wifes Access applications on my computer and transfer them when debugged.

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

    Re: Snapshot Report Problem (2003)

    That's a strange problem. Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  6. #5
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Snapshot Report Problem (2003)

    Hi Hans,

    This is a large data base with lots of private information in it, but I'll see if there is any way to cut it down. It may take me a while to do this.

  7. #6
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Snapshot Report Problem (2003)

    OK Hans,

    I didn't think I could do it, but it zipped to just under 100 KB.

    In the attached database, clicking on Active opens up a form for editing each shutin's record. A sub-form contains a list of visits to the shutin.
    At the main menu, clicking on Preview results in a report that should replicate the data in each shutin's record including the subform with the visit information. However, the visit data only shows up for the first record and is missing for all subsequent ones! I must be missing something, as I don't understand how Access can work OK on the first record and then not duplicate the same on following ones.

    I look forward to your views on the problem.

  8. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 15 Times in 15 Posts

    Re: Snapshot Report Problem (2003)

    At the moment I can only test in Access 2002, and fhe export to snapshot works OK there, as reported by you. If nobody else comes up with an explanation or solution, I'll test in Access 2003 on Monday.

  9. #8
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Snapshot Report Problem (2003)

    OK Hans,

    I'll wait to see the results with 2003. By the way my version of 2003 is 11.6355.8028 SP1.

    Regards,

    Chuck

  10. #9
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,519
    Thanks
    0
    Thanked 22 Times in 22 Posts

    Re: Snapshot Report Problem (2003)

    My 2003 creates the .snp file normally.

    Office 2003 is at level SP2 currently. 11.6566.6568 is the special number.

  11. #10
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Snapshot Report Problem (2003)

    Like Patt, I did not have any problems with it (also using 2003 SP2)

    Sometimes with a mysterious problem it is easier to find a way around the problem rather than solve it.

    In this case change the report so that its record source is a query that includes both Shutins and Visits, and group by Shutin. Put the Shutin info in the Shutin header and the Visit info in the Detail section.

    This avoids the need for subreports.
    Regards
    John



  12. #11
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Snapshot Report Problem (2003)

    Hi,

    I tried to install SP2 -- see new post on that one.

  13. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 15 Times in 15 Posts

    Re: Snapshot Report Problem (2003)

    FYI, just as reported by patt and johnhutchison, the snapshot file displays subrecords for all records in Access 2003 for me too.

Posting Permissions

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