details & details ?

  • Thread starter Thread starter TK
  • Start date Start date
T

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
 
TK said:
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
Click to expand...

I believe you'd have to use at least one subreport to do this (possibly two).
 
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
 
TK said:
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.
Click to expand...

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..
 
Back
Top