Author Message

Setup:Crystal Report 8.5, vb6, ado 2.7, xp, access table

A distributed report to a client get the error:
"file could not be found: "PromoKey" at location: "PromoKey".

    rs.Open sSQL, cn, adOpenKeyset, adLockOptimistic, adCmdText
    Screen.MousePointer = vbHourglass

      Report.Database.SetDataSource rs, 3, 1
     CRViewer1.EnableExportButton = True
     CRViewer1.EnableRefreshButton = True
     Report.ReportTitle = "Report from " & FromDate & " to " & ToDate

    CRViewer1.ReportSource = Report

The access table name is PromoKey.
I seems Crystal wants the file in the same location or is trying to used
saved information.  If I'm passing it the recordset, does Set Location or ?
still have to be made?

Len Latimer

Mon, 29 Aug 2005 07:52:48 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Help needed with RunAddon, "Database Refresh Shape", auto refresh

2. Why doesn't refresh always refresh?

3. Refreshing without Refresh-Button

4. Refreshing without Refresh-Button

5. Data Report Refresh (not refreshing)

6. Why doesn't refresh always refresh?

7. Refreshing recordset without .Refresh

8. How to refresh the list of modules

9. Refreshing a form

10. refresh data sources

11. Problem with form refresh code

12. Refreshing really slow...


Powered by phpBB® Forum Software