I don't think you need to create a fake field in the report's record source. You can create a grouping on an expression like "1".
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: wrmosca@comcast.net
Date: Tue, 1 Apr 2014 14:14:17 -0700
Subject: [MS_AccessPros] Re: Sub report in Report Footer
Doyce
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: wrmosca@comcast.net
Date: Tue, 1 Apr 2014 14:14:17 -0700
Subject: [MS_AccessPros] Re: Sub report in Report Footer
Doyce
A report footer is always on the last page. Can you put in a group footer and put a "fake" field (alias) in your query that is the same for each record?
SELECT LastName, FirstName, "" as Groupie
FROM MyTable
Add a footer for the field Groupie and put your totals in that. It will show up under the detail section.
Bill Mosca
---In MS_Access_Professionals@yahoogroups.com, <winberry.doyce@roadsysinc.com> wrote :
---In MS_Access_Professionals@yahoogroups.com, <winberry.doyce@roadsysinc.com> 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
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 (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar