Crystal Report Run Error

Posted on 2004-11-11
Last Modified: 2008-01-09
Below is a portion of my code that is supposed to generate an rtf report from Crystal.  I am getting the following error when the code gets to the ".Action = 1" line:  "method action of object crystalctrl failed."  I have gone into the report and verified the told me that the database was up-to-date.  Do you know what else could be causing this problem?

Set crySupRept = New CrystalReport
        With crySupRept
            .DiscardSavedData = True
            .ReportFileName = strReportPath & strReportName
            .ParameterFields(0) = "{RA_Report_AccountSummary_TL.Branch_ID};" & strBranchID & ";True"
            .ParameterFields(1) = "{RA_Report_AccountSummary_TL.Business_Owner_ID};1;True"
            .Destination = crptToFile
            .PrintFileType = crptRTF
           ' .PrintFileName = strReportPath & MonthName(Now()) & " " & strBranchName & "Supervisor Report.rtf"
            .Connect = "ODBC;DSN=Advisory;UID=admin"
            .Action = 1
        End With
Question by:msanzenb
    LVL 10

    Accepted Solution

    look at this article. It explains how to use connect

    Author Comment

    I figured out the problem.  I used another Crystal control and it worked.  Thanks for your help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now