join two reports

[checoturco]

Hi all,

I have two reports that need to be printed together, because i print the reports to a pdf printer.

i have a button with this code:

stDocName = "report_A"
DoCmd.OpenReport stDocName, acNormal
stDocName = "report_B"
DoCmd.OpenReport stDocName, acNormal

of course this print two different reports and i ask if somebody have some idea to join this two reports( append the second report to the first).

tks all guys.

checoturco

 

[Idris]

you need to Create a Blank Report say "Report_0"

Insert the SubReport "report_A"
below it
Insert another SubReport "report_B"

and then call the query

stDocName = "Report_0"
DoCmd.OpenReport stDocName

 

[checoturco]

tks Idris,

I done as you suggest and i have some things work and others not.

All a have in the page header of the report_A doesn´t appear in report_0 ( the report that includes the two subreports). if i open the report_A this things appear.

the vba code that i have in the report_a doesn´t work in the report_0, like this:

Reports!report_A!label_1.Visible = True

this gives me the error that the report_A doesn´t exist or is misspelled.

if i open the report_A first and then the report_0, this error doesn´t appear but the code dosen´t work because the data doesn´t appear in report_0 but appears on report_A


i apprecciate all help

checoturco

 

[Idris]

Well this is little bit tricky in here

you got to create the unbound sub control and move the report titles to that control header & footer

Whereas if you dont have data try the following codes in the reports

Private Sub Report_NoData(Cancel As Integer)
Cancel = -1
End Sub