[AccessD] Report/Sub report question. SOLVED!

Hi Jim,

I really appreciated you looking at this with me.  I got busy on the phone
the other day and could not reply.

One issue I had was that I actually had a many to many relationship.  That
is each contract on the main form had several records to it.  So I ended up
making another sub report for the "top" tier.

After I did that, it still would not run properly for all scenarios.  So I
just started changing everything I could to see if something would work.  On
the main form, I had 2 groupings.  The 1st grouping was by project, both
header and footer was visible.  The 2nd grouping had neither visible.  I
deleted both groupings and the report ran!

So I restored and determined that the project grouping was the problem.  But
I needed that grouping.  So I deleted the header and the report ran again.
So I restored again and removed the one label and one bound field from that
section and the report ran.  I then recreated the two fields in that section
and the report ran.

So the issue seems to have been some sort of corruption or something in the
project header of the main report.  So the problem is not always what it
seems.  LOL.

I posted all of the details in the hope that this may help someone in the
future.

Thanks again Jim.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson
Sent: Monday, March 24, 2003 11:34 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Report/Sub report question.



In that case, make sure the main report and the sub report have the Contract
number as the link field between the two.
The query criteria for the sub report needs to have the contract number, the
tier code and the order field plus what ever else you want to display.  The
tier code for the sub report needs to specify "<>0" criteria. 

If it still doesn't work, send me a sample of the database and I'll take a
look at it.

Jim