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

Need Report with info from two Reports

P: n/a
I have two reports: 2004 New Enrollments and 2004 Cancellations.

1. Each report shows by month:
"Monthly", "BiMonthly"([BiMonthly]*2), "Weekly" ([Weekly]*52/12),
"Total Monthly" ([monthly]+[BiMonthly]+[Weekly]) and "Projected
Annual"([Total Monthly]*12).

2. At the end of the report is the "Grand Total Projected
Annual"(=sum([Projected Annual])

I need a report that gives GrandTotal Projected Annual enrollment minus
the GrandTotal Projected Cancellations for a real total revenue.

By the way, my Grand Total Projected Annual on the 1st report I created
works, but on the other report (cancellation) which I copied and made
the necessary changes as to Control Source. What's up with that?
Thank you so much. Blessings,
Barbara

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
bm****@yahoo.com wrote:
I have two reports: 2004 New Enrollments and 2004 Cancellations.

1. Each report shows by month:
"Monthly", "BiMonthly"([BiMonthly]*2), "Weekly" ([Weekly]*52/12),
"Total Monthly" ([monthly]+[BiMonthly]+[Weekly]) and "Projected
Annual"([Total Monthly]*12).

2. At the end of the report is the "Grand Total Projected
Annual"(=sum([Projected Annual])

I need a report that gives GrandTotal Projected Annual enrollment minus
the GrandTotal Projected Cancellations for a real total revenue.
In a group total or report footer you could have 3 controls: Annual,
Cancellation, Net. The net's control source would be
=[Annual] - [Cancellation]

You can use a Dsum() control source for Cancellation. Ex:
=Dsum("Amount","TableName","Type = 'C' And Year(EnrollDate) = 2004")

By the way, my Grand Total Projected Annual on the 1st report I created
works, but on the other report (cancellation) which I copied and made
the necessary changes as to Control Source. What's up with that?
Thank you so much. Blessings,
Barbara

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.