I am new to SQL Server 2000 and have a couple of questions that i hope people can answer for me.

First off some background. My organisation has a very restrictive IT policy, we are unable to install any software other than that wich has been tested and approved by our infrastructure manager and major software contractor. Therefore the only tools that I have available to me are SQL Server 2000 (remote sever), Office 2003 (local server), and VBA (NOT the full Visual Basic suite or VB.NET).

We have approx 100+ providers in 5 geographic areas covered by the regional office that I work in. The providers MI data is held in SQL Server, along with several OLAP cubes that we have created to sumerise the MI data.

I have been asked to produce a separate PDF format report for each provider showing their MI compared to aggregates for the area, and the region. All of this data is currently available in the OLAP cubes.

It occurred to me that the quickest solution would be to pull the data from the OLAP cubes for the PDF's. Can this be done directly with SQL Server/Analysis Services/Reporting Services?

Alternatively, can I then use VBA to connect to the OLAP cubes in SQL Server, and create the report in Access?

Any pointers would be greatfully received.

You can create the reports from the Olap Cubes, using Reporting Services to create the reports then export to PDF.

Jaime E. Maccou