details & details ?

[TK]

HI;
Is it possible to print two recordsets one after the
other in a reports detail section. I need the detail
section of the report to irritate thru the first SQL
statement (Query) printing a parts order and then
irritate thru the second SQL statement (Query) printing
a Labor order.

Any direction or help will be greatly appreciated.
T K

 

[Rick Brandt]

HI;
Is it possible to print two recordsets one after the
other in a reports detail section. I need the detail
section of the report to irritate thru the first SQL
statement (Query) printing a parts order and then
irritate thru the second SQL statement (Query) printing
a Labor order.

Any direction or help will be greatly appreciated.
T K

I believe you'd have to use at least one subreport to do this (possibly two).

 

[TK]

Thanks for the reply Rick

Well that was the conclusion I came to but thought there
must be a better way.
At this point I have 2 reports and drop them on one report
(container); however this causes an additional problem of
having to enter the Id parameter twice to view or print
the report.

TK

 

[Rick Brandt]

Thanks for the reply Rick

Well that was the conclusion I came to but thought there
must be a better way.
At this point I have 2 reports and drop them on one report
(container); however this causes an additional problem of
having to enter the Id parameter twice to view or print
the report.

I almost never use self prompting parameters. Create a small popup form for the user
to enter the ID and have your queries reference that form. Then you can also provide
things like a list of choices or validation of the entry etc..