Access 2000 and Crystal Reports

[michaelacheson]

How do I link to a crystal report from an Access command button in a form.

Thanks,
Michael

 

[kenhamady]

First, you would need to have the correct version of CR
(v8.x Developer or v7.x Professional) and then you would need to select an integration method (there are 4 choices). I haven't done this, but I hear that the syntax is very similar to VB syntax for launching the report from an app. 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

 

[Morey]

You can either call the Crystal Report directly or embed the CR OCX object into the form and program to it.

If you Call the Crystal Report exe directly with the report name as the parameter, the user must have CR installed on their PC.
If you use the OCX you need to reference Crystal's technical document for this technique. Crystal has not upgraded this OCX for several years, preferring that programmers use the RDC, which is great for VB but not for Access 97 or 2000. This technique uses a Crystal viewer so that the user can only see the data, not modify the Crystal report.

 

[kenhamady]

Morey,

If you call the report exe directly it just opens the RPT file in the report designer, correct? You can't manipulate the report from access. 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

 

[Morey]

Not from Access directly, but since you must have Crystal reports installed on the PC, once you have the report opened, you can manipulate the report directly in Crystal, which is not usually what the developer wants to have happen.