Using Access form as Crystal Reports viewer 
Author Message
 Using Access form as Crystal Reports viewer

Crystal (at has a white paper on using a Visual Basic 6
form to house the Crystal Reports Viewer.  This viewer brings up a selected
Crystal report in preview mode, and allows it to be printed or exported to a
variety of file types.

I've tried this out in VB6 and it works fine.  However, I'm more comfortable
programming in the Access environment.  I would like to develop a simple
front end to allow a client to print numerous reports off of their
SQL Server 2000 database.

When I check all 9 Crystal references in either Access 97 or Access 2000,
then apply the same VB6 code (see below) to a form, the viewer does come up,
only occupying about 25% of the screen, and it can't be made larger.  Also,
there are no print or other buttons on the viewer toolbar.  I can make
changes to the viewer ActiveX object, but the changes are not saved.

Here's the code suggested by Crystal Decisions for VB6:

Dim CRxApp As New CRAXDRT.Application
Dim crxrpt As CRAXDRT.Report

Private Sub Form_Load()
    'use the OpenReport method of the Application object
    Set crxrpt = CRxApp.OpenReport("c:\crystal\running totals.rpt")

    CRViewer1.ReportSource = crxrpt

End Sub

I would appreciate any thoughts on how to make this work in Access.


Mon, 10 Nov 2003 10:29:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Using Crystal Reports Viewer with Microsoft Access

2. blank report using web using Web Forms Viewer

3. Passing Parameters from C# to Crystal Report / Crystal Report Viewer

4. Problem using crystal report viewer

5. Mouse Scroller on Crystal Reports Viewer Form?

6. Report displayed using Crystal ActiveX viewer shows blank pages after scroll to last page

7. using Crystal Report Viewer control

8. Using PgUp and PgDn keys in the Crystal Report Viewer

9. ActiveX Problem Using Crystal Reports Viewer

10. Access denied to Crystal Report\viewers

11. Crystal 9 and the Crystal report viewer OCX.

12. Invalid Report Source Error in Crystal Report Viewer


Powered by phpBB® Forum Software