Calling a crystal .rpt file from access2000 form button 3

[GotFish]

Is it possible (ie...relatively easy) to call a crystal report from an access2000 form (either button, or from switchboard menu item? I am rather new to access forms, but familiar with low/moderate vb code....anyone have an example?

 

[BobbyRidler]

Place a Crystal reports control on a form.
Set it's ReportFileName property to the file name of your crystal report.
Place a button on the form.
In the onclick event for the button type this code:

'cmdOpenReport is the name of your button
Private Sub cmdOpenReport_Click()
'Action Code 0 will open the report in preview
'Action Code 1 will print the report to a printer

CrystalReport1.action = 0
'Where CrystalReport1 is the name of the control

End Sub

Cheers

Anthony

 

[valkyrie69]

Thanx.... This works a treat. If you could add the passing of parameters for example to select only details of a field on the current form i would be most grateful It is better to ask for for directions rather than wander blindly... Where am I and why did I ever get into I.T.

 

[GotFish]

Okay, I understand this, makes sense. But, when I try to put the crystal report control on the form it says:
"Thr OLE Server Isn't registered, to register the OLE server, reinstall it"...what does that mean, and how do I do that? Thanks immensely for your help Anthony..