Subreport Problem

[threadgills]

I have a Main report (Market) and a subreport (FA). Both have two fields in common (Region and Market) so they are my Child and Master fields. There is 1 record in the Market report and 41 in the FA Report. Whenever I run the report, the status shows the query running and then it hangs on formatting the report. Each report by itself runs just fine. Here's what I'm trying to get my report to look like:

Market = Sacramento

FA = B42 John Doe (all information for John Doe)
B43 Jane Doe (ditto)
And so forth

Does anyone have any idea as to why it's not formatting correctly? Do I have my Child/Master Links wrong?
Thanks for any help you can give...this one has me stumped.

 

[Clifford77]

I have similar reports built and I am having issues with the performance of the reports. The queries seem to run good as well as the subreports but when you run the master report it dogs down to a slow standstill. If you here of anything please let me know.
-Michael-

 

[threadgills]

Clifford77...the number of queries you have behind the master report may be hampering the performance. Mine has 2 subreports within the master and takes a while because the subreports have queries based on queries. I never figured out a way to fix my original problem though