General discussion

Locked

How to call Crystal Reports from Access

By venkata.perugu ·
Pl. can anyone tell me how to call Crystal Reports (8.5) from ACCESS 2000?.

Thanks a lot in advance

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

How to call Crystal Reports from Access

by Miss Kitty In reply to How to call Crystal Repor ...

First you must add a Crystal Report Control and a CRViewer Control to your project (you do this under projects and then references. Then you can add the code below.
Dim crxApplication As New CRAXDRT.Application
Public Report As CRAXDRT.Report
Dim crxDatabaseTable As CRAXDRT.DatabaseTable
Dim crxParameterField As CRAXDRT.ParameterFieldDefinition
Dim crxFormulaField As CRAXDRT.FormulaFieldDefinition

strReport = ("G:\ACCESS\SIS\RPTRSG02\" & frmMain.GetFileName & " CUST ALL DATES.rpt")
Set Report = crxApplication.OpenReport(strReport, 1)
frmViewer.Show vbModal

Add a new form and put a CRViewer control on it then code it as follows:

Option Explicit

Private Sub Form_Load()
'Screen.MousePointer = vbHourglass
CRViewer.ReportSource = frmCustReports.Report
CRViewer.ViewReport
End Sub

Private Sub Form_Resize()
CRViewer.Top = 0
CRViewer.Left = 0
CRViewer.Height = ScaleHeight
CRViewer.Width = ScaleWidth
End Sub
Private Sub Form_Unload(Cancel As Integer)
Hide

End Sub

If you need anymore info, email me at:
covcat@riverstonegrp.com
I'll be glad to help you.
Cathy

Collapse -

How to call Crystal Reports from Access

by Miss Kitty In reply to How to call Crystal Repor ...

sorry, I just reread your question again and saw that you want to call crystal from access not from VB. I don't know if this can be done. I know that you can link to an access database when you set up a crystal report but not the other way.
Cathy

Collapse -

How to call Crystal Reports from Access

by venkata.perugu In reply to How to call Crystal Repor ...

The question was auto-closed by TechRepublic

Collapse -

How to call Crystal Reports from Access

by fernstar In reply to How to call Crystal Repor ...

WHY WOULD YOU?
Access has a report gerator as good if not better than Crystal Reports!

Use the tool provided and save yourself time and effort.

Collapse -

How to call Crystal Reports from Access

by venkata.perugu In reply to How to call Crystal Repor ...

The question was auto-closed by TechRepublic

Collapse -

How to call Crystal Reports from Access

by venkata.perugu In reply to How to call Crystal Repor ...

This question was auto closed due to inactivity

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums