Wrox Programmer Forums
|
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 August 15th, 2004, 02:04 AM
Registered User
 
Join Date: Aug 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default vb-crystal report error 20599

Hi all

I am in desperate situation now.
I just took over a VB application maintanace and am in a loss now.
As i have not touch VB for 4 years and first time seeing crystal report. I am having a rather tough time.

The report printing has encountered error.. the lines of code are as follows:



If pDBConnect Then cryReport.Connect = strCnn

 If strSqlQuery <> "" Then cryReport.SQLQuery = strSqlQuery
  If pDiscardSaveData Then
    cryReport.DiscardSavedData = True
  Else
    cryReport.DiscardSavedData = False
  End If
  cryReport.Destination = crptToWindow
  cryReport.WindowState = crptMaximized
  If strFilter <> "" Then cryReport.SelectionFormula = strFilter
  intError = cryReport.PrintReport (<== error occur!)


for your information, strCnn is a string formulated earlier when the application starts, the contents are

strCnn = "dsn=easdev;uid=easadmin;pwd=ava2002;dsq=easde v;"

as far as i am concerned, the details are correct.
Will be be any incompatibilty issue if the applications runs in WinXP, or win98?
I am using VB 6, crystal report is 8.5


any help is greatly appreciated!







Similar Threads
Thread Thread Starter Forum Replies Last Post
simple report and crystal report in vb.net saket123 .NET Framework 2.0 0 August 13th, 2008 06:55 AM
VB with crystal report monika.vasvani VB Databases Basics 1 June 3rd, 2008 10:51 AM
pls help me out..runtime error 20599 archana007 SQL Server 2000 2 April 5th, 2006 06:14 PM
How to use Crystal Report 9 with VB hafizfarooq Crystal Reports 0 May 8th, 2005 03:02 PM
please very urgent (runtime error 20599) subramani Crystal Reports 2 November 3rd, 2004 05:49 AM





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