Calling and RDL file to generate reports from Access

[keen1598]

So Access was unable to manage the amount of content that I needed to produce in a single report. The reports contain 12 charts/graphs all of which I needed on separate pages (one chart per page). As such I could not create large enough charts in access to fit to each page, as Access limits the amount of space one can use in a report.

I downloaded Microsoft Reports Builder 3.0 and built my reports as needed and can generate them as desired at current. I'm wondering if there a way to call that RDL file I created to generate my reports from a form control button in Access?

 

[BlueIshDan]

To execute the RDL file or to print a report with your Access Database's data. I'm not exactly familiar with RDL files yet.

 

[smig]

Create each chart as a sub report and put a page break after each sub report.

I have a report wirh almost 20 sub reports, including charts.

 

[keen1598]

Seriously? No one knows how to write and interface/subroutine to activate an RDL reports package? I figured this was pretty simple since its just a SQL Report Generator...