Anyone use Business Objects?

[Scott S]

I have created a simple (as in really simple) report for a user, however, they have asked if it can automatically produce a PDF once the query has refreshed.

I know this is possible as I have seen a report in the past that does this, but the lad with said report is currently off work and has been for about 11months.

I am quite sure he used VBA, but I am a total noob when it comes to VBA and have never really used it at all.

Anyone use business objects in this way? It's so the report can be automatically produced and then saved down for audit purposes.

I know it can be done by the user ('file', 'save as' etc), but I don't want any user interaction other than entering the start and end date of the query.

 

[Scott S]

Scrap that request, I found the old query and stole the VBA code.

Don't fully understand how it works (as in, not sure what some lines of the code do), but it works and that's enough for now, will go back when i'm less busy and see what it all means.

I use SAS, not VBA, so it's going to take some getting used to (unless I find a decent book).