Bill,
That's a good idea but as I was thinking more about it the subreport is actually the detail for one of the groups. Can I use conditional formatting to make the detail section visible for only the one group? I've started playing with code in the format event of the detail section but haven't got it to work yet.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Section(acGroupLevel1Header).Controls("Group") = "Unreferenced Issues" Then
Me.Section(acGroupLevel1Header).Visible = True
Else
Me.Section(acGroupLevel1Header).Visible = False
End If
End Sub
It errors when I run it on the first line saying "Run-time error '2467. The expression you entered refers to an object that is closed or doesn't exist."
So I haven't got something right yet.
Doyce
---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :
---In MS_Access_Professionals@yahoogroups.com, <winberry.doyce@...> wrote :
Hello friends,
I have a report that is only about 1/3 of a page. It has a report footer with totals in it. I'd like to insert a subreport that can have multilple pages at the end after the totals. However, when I do, the main report totals appear on the next page with the sub report and I'd prefer that they stay just below the detail of the main report. I don't care if the subreport starts on a new page. I tried inserting a page break before the subreport but that just makes the totals appear on page 2 by themselves and the subreport starts on the 3rd page. Can I create a 2nd report footer or other section at the end of an Access report for the subreport like I can in Crystal Reports or is there another way to do this?
Doyce
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar