[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

-----Original Message-----
From: Bobby Heid [mailto:bheid at appdevgrp.com]
Sent: Monday, March 24, 2003 10:06 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Report/Sub report question.


Thanks again Jim for taking the time to look at this.

No, the prime's cannot be a sub also.  These are actually contracts.

The data is actually processed into a work table because of the weird
requirements of the report.  The main report and sub report are actually
working correctly by themselves.

I guess my main problem is that I have to CTRL-Break to get the report to
stop doing whatever it is doing.  When I do this, I am put back into design
mode.  Therefore I cannot tell what exactly is causing the problem.

There is another field in the table that tells the proper order for display.

Thanks again,
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 10:35 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Report/Sub report question.



Bobby,
One question comes to mind.  Can a Prime Contractor also be a sub
contractor?
If so, then I would suggest creating a table to record the 1-M
relationships.
Two fields labeled Prime and Sub is all that is needed.
So the data would look like:
Prime	Sub
A	B
A	C
A	D
B	A
B	E

Etc.

The reason to do it this way is that a Prime Contractor on one contract can
be a Sub contractor for another.  Unless a Prime will always be a prime and
sub will always be a sub.

If the tier code is one field in the primary table, I'm not sure how you
would separate the data to what you need.  e.g. if a company is prime and
ONLY a prime, how do you determine what companies are the subs?

Maybe I don't understand how it works.

Yes, the field needs to be available on the report.

I'm confused, but that's my normal state....

Jim
 

-----Original Message-----
From: Bobby Heid [mailto:bheid at appdevgrp.com]
Sent: Monday, March 24, 2003 8:31 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Report/Sub report question.


Hi Jim,

The two reports pull different data based upon a tier code.  The primary
report pulls data for tier 0, and the sub report pulls data for tier<>0.
The reason I need to do it this way is that the report is required to show a
different subtotal for the tier 0 records and one total of all of the
records for the tiers under that one tier.  Note that there can be many tier
0 records.  The tier 0 records are primary contractors and the tier<>0
records are sub contractors under that contractor.

When you say that the field needs to be visible, are you saying visible on
the report or available to display on the report (IE. in the query)?

Hope I haven't confused everyone even more.  LOL.

Thanks,
Bobby


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com