Crystal report parameters to be controlled by Access database table

[KMEscherich]

Hi there, am wondering if there is a way to do the following:

I developed a Crystal report that runs against a Clarity table envrionment. The report runs fine.

I have been asked to run my parameter form - Crystal report against an Access database table. Once the report runs against this Access table, I need to be able to export/convert into a PDF format, then transfer this PDF report into a folder on our shared drive.

Not sure if this can be accomplished or not. Please advise. If I need to have several buttons on a parameter form, that is okay.

Please HELP.

Thank you . . . . . . .

[jimatqsi]

Is this an Access question? I'm not sure there is anything to do in Access for this, unless you want to make an Access process to run the Crystal report. But maybe the report needs to maintain the ability to run against the Clarity DB.

Looks more like a question for a Crystal reports forum to me.

Jim

[beacon]

I've created a bunch of Crystal Reports against Access databases, so I know that you can create a Crystal Report that is connected to an Access database.

As far as running the report and automatically exporting it to PDF and saving it into a folder, I'm fairly sure that isn't possible from within Crystal Reports.

You may be able to program Access in VBA to run/export the report by adding a reference to the Crystal Reports library in VBA. I searched "Automatica lly run Crystal Report and export to PDF" and it returned a few results, although the code was written in VB. However, it would be worth taking a look at to see if you can modify the code for VBA (which may actually not be too difficult).