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

Need help with A2K report/subreport, please

P: n/a
I've got a report with a subreport linked on fund number. The
subreport returns 2 columns of dollar amounts, both current and YTD,
by object code for the selected fund number. The user can select one
or many funds.

I create a query for the subreport's recordsource in the open event.
My problem is that if there's more than one fund number, YTD amounts
from the first fund number show up on the 2nd fund numbers' report,
overwriting the 2nd fund's YTD amounts, which then show up on the 3rd,
overwriting that YTD amount, and so on. The current amounts are fine.

I've verified that the query returns the correct set of records for
the fund's YTD amounts. I just can't figure out why the YTD amount
would be overwritten for the 2nd fund and so on. If I run the report
separately for each fund then the YTD amounts are fine.

Thanks for any help or advice.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ellen Manning wrote:
I've got a report with a subreport linked on fund number. The
subreport returns 2 columns of dollar amounts, both current and YTD,
by object code for the selected fund number. The user can select one
or many funds.

I create a query for the subreport's recordsource in the open event.
My problem is that if there's more than one fund number, YTD amounts
from the first fund number show up on the 2nd fund numbers' report,
overwriting the 2nd fund's YTD amounts, which then show up on the 3rd,
overwriting that YTD amount, and so on. The current amounts are fine.

I've verified that the query returns the correct set of records for
the fund's YTD amounts. I just can't figure out why the YTD amount
would be overwritten for the 2nd fund and so on. If I run the report
separately for each fund then the YTD amounts are fine.

Thanks for any help or advice.


Can you sort/group/total on fund number?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.