Report and Subreport?

[Hector Codoceo]

Hello, my name is Hector
and I have a problem with report.

I have a report named: report1
-----------------------
SELECT [All].Journal, [All].Contractor, [All].[Total pp],
[All].Due, [All].Returned
FROM [All]
WHERE ((([All].Journal)=[enter journal name]) AND
(([All].Returned) Is Null));
--------------------------------

and I have another report called: report2
-----------------------
SELECT [All].Contractor, [All].Journal, [All].[Total pp],
[All].Due
FROM [All]
WHERE ((([All].Contractor)=[enter contructor]) AND
(([All].Returned) Is Null));
------------------------------

the different between them it's that in the report1 I ask
for the journal name, and the report show me a list of
constructors who work with the journal and the returned is
null.
I use the report2 to see in detail what's the contractors
from the list in report1 have out (including of course the
journal in report1)

Report2 it's like a detail from report1

My question is:
How can I create a report and a subreport where I only can
write the name of the journal (like in report1)and obtain
both report information.
I tryed, but the report ask me first for the journal name,
and then for the contractor, and it's supose that i dont'n
know who are the contractor because all depend of the list
from the first question.

Please I need help, I allready ask for the same solution
but from a query, and the solution that I receive was,
create a report and a subreport. (I was specting for
something more...but)
Please, help
thanks,
Hector

 

[Fons Ponsioen]

Hector the reponse realy is create a report and subreport,
but I take it you do not have experience doing so.
For as far as I read from your description you need to
create the first report sorted/grouped by journal, than
create the subreport sorted by journal and than by
constructor. Than you insert the subreport in the main
report and set the master to child link using the journal.
Hope this gets you going in the right direction.
Have a great weekend.
Fons