Still Suffering with Subreports

I

IreneJ

Hello again, still having multiple problems getting four
subreports on a main report to print items from each by
date. Have made some head way with your help provided
but now have another problem.

I have subtotal boxes in the date footer on the main form
for the amounts from each form i.e. Subreport1 - 208.00.
Each one of the total boxes has:
=IIf([Subreport1].Report.HasData,[Subreport1].Report!
[VGAmounttoContractorTotal],0) so that if the report has
no data that the field is populated with 0.00. (This part
seems to work okay)

I have found that if any one of the subreports doesn't
have any data to report i.e. Subreport 1 - 208.00,
Subreport 2 - 0.00, the total box for Subreport 1 will
skew the data and give me a false number such as 143.00
instead of the 208.00. As long as the reports have
information in them, Subreport 1 will produce the correct
amount in the total box.

Anyone have any ideas about what might be going on. Is
there anything specific that subreports have to have make
them run correctly. I have found a way to put link/child
fields on all of them so that they have an attachment to
a date which they didn't have before, they had prevously
just been unlinked on the main report.

Thanks,
Irene
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top