Crystal Reports and Access

[valkyrie69]

Can anyone tell a non programmer how to incorporate crystal reports into an access database i can see that there are crystal report controls but have been unable to make them function. It is better to ask for for directions rather than wander blindly... Where am I and why did I ever get into I.T.

 

[moontube]

Hi Val,

Crystal Reports works well with Access. I used Access for all the examples in my book, Crystal Reports 9 for Dummies. The book explains how to use Crystal Reports in simple terms.

Allen G. Taylor
(moontube)

 

[MrWilly]

if you have Crystal Developer installed on the machine running the Access database, viewing reports with the ActiveX viewer is rather simple...

If you are planning on coding in VB: go here:

http://support.crystaldecisions.com/library/kbase/articles/c2009907.asp

If you just want to use the ActiveX objects in an Access form,

1. Place the Crystal Report Control on a form and set the "ReportFileName" property = to your C:\...file path\report.rpt (it will allow you to browse for it.)
Here you can set any additional properties you may need.

2. Place a Command Button on the form, cancel the wizard, and put the this in the On Click() event(no brackets):

Private Sub [commandbuttonname]_Click()
[CRReportControlName].PrintReport
End Sub


This should get you started...but please keep in mind, distributing these reports to users only running Access is a whole different can of worms...
If you're looking to allow others to view reports, it's easiest to create them in Access...