Lopsided report

[znibk]

I am trying to create a report which has Cash Contributors on one side of the
page with In-Kind Contributors on the other side of the page !! (Side by side
each other)
I have all the information i need in the same query.

If I create a single report, I get the lopsided effect. One group of
contributors is higher than the other, leaving blank spaces above one side.

I tried creating a report with a sub report. I used the MonthYear as the
link, as I could find no other common ground. Doing that, I have encounter
two errors, the filter (I used a form filter with the MonthYear as the
filter.) When I open the form, enter the monthyear that I want, exp, Jul
2007, I then open the main report, it asks me for the MonthYear again. The
report opens with a mess. On the SubRpt_IKcontributions, it lists all in kind
contributions, multiple times. On the main report side,
Rpt_CashContributions, it will list one or two cash contributions then many
in kind contributions, one or two cash, multiple in kind contributions.

I've no idea what I've done wrong, does anyone else? I really hope so and
that somene(s) can help me out. Christ's blessings, k

 

[Duane Hookom]

"I have all the information i need in the same query" does this query contain
a field/column that identifies "cash" or "In-Kind"?

IMHO, never use parameter prompts in queries. Always reference controls on
forms. Open the form, enter the criteria in the controls, and then run the
report.

Are all contributions made to the same entity or are the grouped. For
instance cash and in-kind contributions to "Project X" and cash and in-kind
contributions to "Project Y". From you description, all contributions go into
the same "pot".

Are you really sure you want to group by Month and Year?

Can we assume there are no contribution detail records in the main report's
control source?

 

[znibk]

Duane,

First, what does "IMHO" mean?

Second, I changed to frmDates and used my IncDate (Income Date) as my
linking field on my subreport. Can not view my subreport at all.

Third, The cash donations go to the bank, the inkind contributions go to
sell in the thrift store.

Fourth, because I got tired of double entering names, I decided to have just
one table for Contributors.

Fifth, there is a cash contribution control source in the detail section of
the main report, as well as the amount of the contribution.

Sixth, the Name of the sub report in the main report is
SubRpt_IKContributions

Seventh, perhaps most important, I will go back to all of my tables, etc.
and change the MonthYear. I will use the Income Date, Check Date, etc. for a
time period reference.

Eight, all these talk about the main report and sub report. Is there no way
to have side by side information without a subreport, which, at the moment,
is not working. Question, could I use two child/master linkings? Contributor,
since both the inkind contributions and the cash contributions come from the
same list, and the Income Date? I've tried each by itself, and will try both
together, can't hurt to give it a try.

Hope thse are better answers than I've given in the past.
Another question, have you completely given up on helping me obrain the
ending balance for my financial report? Still have hope but need help. 54
postings. Boy, are we on diffeent wave links. I shall try to do better.

Good night, good luck, and Christ's blessings.
k

The Name for the sub report is

 

[Duane Hookom]

IMHO, you should google it ;-)

I don't think you touched on these questions:
<>"I have all the information i need in the same query" does this query
contain a field/column that identifies "cash" or "In-Kind"?</>

<>Are you really sure you want to group by Month and Year? </>
I'm trying to determine how you want to group the records displayed in your
report. I assume your MonthYear field contains some expression like 200708
and 200709. Are you wanting to group your report by year and month?

<> From you description, all contributions go into the same "pot".</>
Since you didn't really answer this, I assume there is no additional
grouping required in the report other than year and month.

What are the exact field in your record sources and how do these fields
relate?