VBA Code for Filter on Multiple reports in BO Doc globally

[rrbo]

Hi ,

I have two reports in BO Document.
I wanna apply filter globally on the same object in two reports and have to export as Pdf.

I know we can Export as PDf with like.
dim mydoc as Document
mydoc.exportAsPdf(....)

I am able to filter in one report tab (Active) and ExportAsPdf with the link

http://www.islink.com/pdf/FilterandExportviaVBA.pdf.

But I need to filter globally on both reports and then have to ExportAsPdf...


Can any body please help me how we can write VBA code that applies filter for all reports.

Thanks

 

[Sridharan]

Loop through the required reports and apply the filter and export it. Seomthing like this...

For i = 1 To ActiveDocument.Reports.Count
    MsgBox ActiveDocument.Reports(i).Name
    ' Do your routine here (say Filter / Export)
Next i

Sri

 

[rrbo]

Thank You Sri. Got It.