Migration CR6 to CR7: Reports don′t work anymore 
Author Message
 Migration CR6 to CR7: Reports don′t work anymore

Im using the report engine through the automation object (crpeauto.dll).
While the reports worked fine with CR6, they dont with CR7, using the same
VB code (see below).

I always get the error "cannot access first record".

In the Seagate Knowledgebase I read about the recordset being out of scope
or getting destroyed. The tip trying it with .readrecords immediately after
.setprivatedata resumed in the same error.

I realized the report format has changed, so I saved the reports in the new
format and I also updated the database driver (pdsmon.dll) which had the
effect, that I can see the reports in the preview pane (of the Crystal
Report Designer), but it had no effect on my previous problem...

Anyone got any ideas???

Thanks for your help
Bernd

Well, there goes my code (RS is defined globally as DAO.Recordset and has
been set (forwardonly-type)):

    Dim ReportDb As CRPEAuto.Database
    Dim ReportTables As CRPEAuto.DatabaseTables
    Dim ReportTable As CRPEAuto.DatabaseTable

    Set Report = AppForm.App.OpenReport(ReportFileName)
    Set ReportDb = Report.Database
    Set ReportTables = ReportDb.Tables
    Set ReportTable = ReportTables.Item(1)
    ReportTable.SetPrivateData 3, RS
    Report.DiscardSavedData

    Set ReportView = Report.Preview(, , , , , WS_VISIBLE, Me.hwnd)



Mon, 20 Aug 2001 03:00:00 GMT  
 Migration CR6 to CR7: Reports don′t work anymore
What I forgot to say:

While opening the report, the menubar of my VB App(MDI) is disappearing.
Closing the form (container for my report), its reappearing again...

Bernd



Mon, 20 Aug 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. drop-downs don't work anymore

2. Right$ ,left$ mid$ don't work anymore

3. Frame in IE 30 don't work anymore

4. Migration to VS 2003 worked though I don't know why

5. from CR6 to CR7

6. From CR6 to CR7

7. CR7/CR6: Are the fundamentals the same?

8. Don't get post anymore

9. TextOut and Print don't work in PictureBox on Access Report

10. CR8 html reports don't work

11. printing reports don't work

12. Don't see all my Access 8.0 Queries in CR6.0

 

 
Powered by phpBB® Forum Software