Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB Databases
|
Pro VB Databases Advanced-level VB coding questions specific to using VB with databases. Beginning-level questions or issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 8th, 2005, 12:28 AM
Registered User
 
Join Date: Feb 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to g-mey
Default export crystal report with oracle db in VB

I create one standard exe file.

Then I add in a crystal report file with
oracle ODBC connection named as CrystalReport1
Together I add a crystal report viewer.

When I run the program, I got this error
"Server has not yet been opened"

This is the command to export the report out to pdf.

Private Sub Command1_Click()
Dim Report As New CrystalReport1
filedb = App.Path

With Report
.ExportOptions.ODBCDataSourceName = "DSNname"
.ExportOptions.ODBCDataSourceUserID = "Username"
.ExportOptions.ODBCDataSourcePassword = "Password"
.ExportOptions.FormatType = crEFTPortableDocFormat
.ExportOptions.DestinationType = crEDTDiskFile
.ExportOptions.DiskFileName = filedb & "VehicleExp.pdf"
.Export False
End With

End Sub
---------------------------------------

anybody please help me to solve this problem..
thanks


~G-mey~





Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Crystal Report Programatically Harinder.Dhamija ASP.NET 2.0 Basics 0 July 20th, 2007 08:28 AM
problem with oracle & crystal report with Vb abhijhegde Beginning VB 6 1 May 3rd, 2007 12:03 PM
Export Crystal Report to PDF aarunlal ASP.NET 2.0 Professional 1 June 28th, 2006 01:18 PM
Display Vietnamese in Crystal Report(DB Oracle) Christian_tm Crystal Reports 0 June 14th, 2006 02:49 AM
Crystal Report export problem kalyanb BOOK: Professional Crystal Reports for VS.NET 0 December 3rd, 2004 03:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.