New to Crystal - Access Integration

[52]

I'm trying to add some reports created in Crystal 8.0 to an Access 2000 database.

Are there any good (quick) references on where to begin? I have been having problems creating a Crystal Report through Access and would rather use the Reports I have already created.

My goal is to let the users have this database and view the Crystal Reports without having to buy more Crystal licenses.

Thanks!!!!

 

[kenhamady]

You will need the developer's edition of CR. Then you add the Crystal OCX to a VB form in a way fairly similar to how it is done in VB. Then you can manipulate it in VBA. Distribution of the needed dll's might be the tricky part.

You might consider using the compile option, which you can download from CD's web site. See faq149-277. This doesn't work from an Access form, but runs from the reports from a shortcut. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[52]

THANK YOU for the link for the compile option and the info. Will this update the report every time the database is changed??

 

[kenhamady]

If you don't save data with the report, it should re-read the database each time. If you have saved data it should give the user the option to refresh. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com