[AccessD] Report/Sub report question.

Bobby,
It seems to me, there is a normalization problem.
Sub reports/forms are used to display a one to many relationship.  If "the
main report and sub report ... pull from the same table" that indicates a
one to one relationship and there is no need for a sub report.

To insure a sub report works correctly, the common field between the main
report and sub report needs to be visible to both.

HTH
Jim

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


Hi all,

Trying to do a sub report on a report.  

The main report and sub report both pull from the same table.  The main
report is linked to the sub report via the project.

My problem is that: The main report with out the sub report runs fine.  The
sub report by itself runs fine.  But when I put the 2 together, the
"formatting page" progress bar goes to 100% and just sits there.  I have let
it sit for several minutes (report and sub report by themselves come up
pretty fast).

Any ideas as to what I may be doing wrong?  

Does the project on the sub report have to be on the report?  Or just in the
query of the sub report?

Thanks in advance,
Bobby

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