Snapshot Report Problem (2003)

[Chuck Tucker]

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?

[HansV]

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

[Chuck Tucker]

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.

[HansV]

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

[Chuck Tucker]

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.

[Chuck Tucker]

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.

[HansV]

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.

[Chuck Tucker]

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

[patt]

My 2003 creates the .snp file normally.

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

[johnhutchison]

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.

[Chuck Tucker]

Hi,

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

[HansV]

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