Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

crystal report export function not working in crxi

Status
Not open for further replies.

Lhuffst

Programmer
Jun 23, 2003
503
US
thread222-1299003

I have a vb6 app using crystal reports 9.0. Due to upgrades in software within company, I have to upgrade the crystal reports to xi (would go 2008 but vb6 doesn't support this version). I have opened and saved a couple reports in xi (report1.rpt, report2.rpt)

If I open them directly in cr, the export works fine.
If I run them via the vb code, all functions EXCEPT for the export work.
I copied & registered the dlls to C:\Program Files\Business Objects\Common\3.5\bin
but now am stuck on what to try next. Does anyone see what I"m doing wrong or have to change? Thanks lhuffst

Code:
[bold]Private Sub CRViewer91_Clicked(ByVal x As Long, ByVal Y As Long, EventInfo As Variant, UseDefault As Boolean)[/bold]

    Dim CrViewerEventInfo As CRVIEWER9LibCtl.CRVEventInfo 'Create an object that traps the CRViewer event info.
    
    Set CrViewerEventInfo = EventInfo 'Pass the EventInfo info to the CrVEventInfo object.
    If Not isBlank(CrViewerEventInfo) Then
        MsgBox CrViewerEventInfo.Text, , "Z o o m" 'If the event text (or what field was clicked on) is not empty then display it in a Message Box.
    End If

End Sub

[bold]Private Sub Form_Load()
On Error GoTo Err:[/bold]
 Set crReport = appl.OpenReport(g_RptName)

hold = UCase(Util_GetUserName)

With crReport.Database.Tables(1).ConnectionProperties
   .Item("password") = "xxxxxxxxxx"
End With
       
  
    CrystalReport1.ReportFileName = g_RptName
    CrystalReport1.WindowShowGroupTree = False
    CrystalReport1.WindowState = crptMaximized
    
  
            
   
   g_RptName = g_RptPath & g_RptName
    'Debug.Print g_RptName		'Correct path and report name is returned

    
   crReport.EnableParameterPrompting = True
    
    CRViewer91.ReportSource = crReport 'Sets the Report source of the CrViewer to the Report object we created.
    CRViewer91.EnableCloseButton = True
    CRViewer91.DisplayBorder = True
    CRViewer91.EnableNavigationControls = True
    CRViewer91.EnableStopButton = True
    CRViewer91.EnableRefreshButton = True
    CRViewer91.DisplayToolbar = True
    CRViewer91.Zoom 100       'zoom to preview window
    '9/19/07 changed for swr ec091917-2 ljh
    CRViewer91.EnableExportButton = True

Exit Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top