Crystal from MS ACCESS

[mehlsl]

I am writing my reports for an application in Crystal.

Can someone tell me the basics of using Crystal instead of the ACCESS
report writer?

In other words, instead of
DoCmd.OpenReport "rptTrnsact", acNormal, "", ""
I need to learn the code to open a Crystal report from within ACCESS and then return to ACCESS when done viewing or printing the report.

Thanks for any help.

Larry Mehl
mehl@cyvest.com

 

[kenhamady]

First you need the developer edition of CRv8 (or profesional edition of Crv7 or earlier.

1) Add the ActiveX control to the form.
2) Point the control to your RPT
3) Launch the report with something like:

ActiveXCtl0.PrintReport

I believe that most of the basic commands available to VB using the OCX integration method are also available to VBA. 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

 

[mehlsl]

Ken --

Thanks.

Is the ActiveX control the one named
"Crystal ActiveX Query Viewer 1.0"?

Can you tell me

1 - how to "point the control" to the rpt? The only property which looks close to what I need is "Other | QueryFileName".

2 - Where does the "launch" code go
"ActiveXCtl0.PrintReport" ?

Thanks for any more help.

Larry

 

[kenhamady]

It sounds like you might not have the Developers edition of Crystal? 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

 

[mehlsl]

Hi Ken --

I have Seagate Crystal Reports Version 8
Developer Edition English
Part No. 14-50001-085

Thanks for responding.

Larry

 

[kenhamady]

1 "Other | QueryFileName". - This is the correct propety

2 - Where does the "launch" code go? - often under a command button, but in reality you can put it many places. 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