Crystal and Access 2

[rsatty]

How can I pull a Crystal Report while using an Access Database and have the report open up in the Crystal Viewer?

 

[synapsevampire]

Perhaps you can state some specifics, are you trying to open a report within Access?

What version of Crystal?

Which viewer?

Here's the whitepaper on using Access VBA, if this doesn't help, try posting specifics.

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/rdc_vba.exe.asp

-k

 

[rsatty]

I am using Access 2000, and Crystal 8.5. I have a database that has a form that pulls reports from the Access Database depending on the option buttons chosen. But I want to Pull the Crystal Reports instead of the Access Reports (The crystal Reports are so much better). Any ideas

 

[synapsevampire]

I gather you didn't bother to read the link I sent, it shows how to integrate CR with Access...

-k

 

[rsatty]

After I sent the Reply I went to the link, that will work just fine. Thank you very much.

 

[synapsevampire]

Great, I'd hoped it might.

There aren't many VBA<->Crystal resources out there.

-k

 

[rsatty]

True

 

[pelajhia]

Thanks so MUCH - this looks like exactly what I have been looking for.

 

[lynchg]

The sample mdb from the link that synapsevampire suggested must be in Access 2000 or newer. I have Access 97, is there something I can access to help get me started?

 

[pelajhia]

I have changed the reference to crystal active x runtime library to the version for cr 9, so I am now able to run my cr9 reports using the example form without errors from my machine, on which cr9 is installed.

I need to get something like this running on someone else's machine, however. I figure it might mean some sort of install/runtime license for crystal.
Are there any doc's that outline this sort of thing? Does a crystal runtime license come with Access?
They already have Access installed (2000).

Thanks!

 

[pelajhia]

Ok, I found the 'runtime' help file, so I will peruse that before asking any more questions