Posted 4 August 2017, 3:18 pm ESTHey all, i am looking for a way to merge a few reports into one for viewing. Is there any type of merge for AR2?
This is the code i am using to loop through them and print them out currently:
Do Until X = theCount
Set rst = New ADODB.Recordset
strSQL = "SELECT id, theCode FROM jusers WHERE theCode = '" & theNames(X) & "'"
MM.thePrintType = "eodd"
.Source = strSQL
.ActiveConnection = conn
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
arRec.theUID = !theCode
arRec.Printer.DeviceName = MM.thePrnter
arRec.Printer.DisplayProgressDialog = False
Set arRec = Nothing
Set rst = Nothing
X = X + 1
Right now that just prints off however many sheets it needs too per report. However, what i am wanting to do is combine all that into one report so the user can see it all without having to print out multiply copies of the report(s) in order to see them all.
Any help would be great, thanks!