By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,466 Members | 1,141 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,466 IT Pros & Developers. It's quick & easy.

Problem printed multiple instance reports

P: n/a
MJP
I've managed to preview multiple instances of a report, all with
different filters. The problem now occurs when I try to print these
reports or export as snapshot etc. If you try to print any of the
reports it only prints the first report that was created.

Are there any workarounds for this or is this just a limitation of
access?

Nov 30 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
It sounds more like a limitation on your methodology.

Show us rge code your using and people may be able to help.

--
Terry Kreft

"MJP" <ma****@tiscali.co.uk> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...
I've managed to preview multiple instances of a report, all with
different filters. The problem now occurs when I try to print these
reports or export as snapshot etc. If you try to print any of the
reports it only prints the first report that was created.

Are there any workarounds for this or is this just a limitation of
access?

Dec 1 '05 #2

P: n/a
MJP
Dim rptInstance() as Report
Dim i as integer

i = 0

DateSQL = "DeliveryDate Between #01/01/2005# and #01/06/2005#"

Set rst = CurrentDb.OpenRecordset("SELECT PatientTag.TagID,
PatientTag.TagDescription FROM PatientTag;", dbOpenSnapshot)

rst.MoveFirst

While Not rst.EOF
sSQL = DateSQL & " And HomeTag = '" & rst!TagID & "'"

ReDim Preserve rptInstance(i)
Set rptInstance(i) = New Report_DeliveryPointPCTReport
rptInstance(i).Filter = sSQL
rptInstance(i).FilterOn = True
rptInstance(i).Visible = True
i = i + 1
rst.MoveNext

Wend

All the reports print fine, but when I try print or export any of them,
only the first report prints.

Dec 1 '05 #3

P: n/a
MJP
All the reports preview fine rather

Dec 1 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.