Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: Crystal Report 8 help from within VB.

    I'm writing a program in VB, using the Crystal Report ActiveX component.

    The problem I'm having is that when I go print the report, the information is not current.
    It displays old information from previous prints.

    We have a .rpt file created that suppose to pulls data from an access database.

    All paths are correct.

    Here is the code:

    Code:
        strReportName = "G:\User\COPS\DAILY RUN SCHEDULE.rpt"
         strSelectionFormula = "{DailyJobs.JobDescription} > " & conQuote & conSpaces & conQuote
        
        
        With CrystalReport2
            .ReportFileName = strReportName
            .SelectionFormula = strSelectionFormula
            .Destination = crptToWindow
            .PrintReport
        End With

  2. #2
    Join Date
    Apr 2004
    Posts
    3
    Fix it.

    The problem was in crystal reports itself.
    The path was pointing to another file in another folder.
    Had to open the file in crystal reports to change what database it was pointing to. Also did a refresh and after that everything worked beautifully.

  3. #3
    Join Date
    Apr 2004
    Posts
    3
    you might want to check it again if you are saving data with report (thats why you have to Refresh every time to get new set of data) if you uncheck that option, it'll automatically show you the latest set of data.

  4. #4
    Join Date
    Apr 2004
    Posts
    3
    Yeah, I made sure that option was unchecked.

    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •