Results 1 to 3 of 3

Thread: CR 8.5 type mismatch help!

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2006
    Posts
    2

    CR 8.5 type mismatch help!

    I have some existing code that now fails after upgrading to CR 8.5 (these are old reports!). I know VB but next to nothing about CR. Any help is much appreciated. The offending code is below:

    Dim Report As New CrystalReport1
    Dim CommSub As SubreportObject

    Option Explicit

    Private Sub Form_Load()
    Dim SQL As String
    Dim SQL2 As String
    Dim x As Integer

    Screen.MousePointer = vbHourglass
    -->Set CommSub = Report.Details<-- this FAILS!!!


    Thanks

    Jeff

  2. #2
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: CR 8.5 type mismatch help!

    Details is not a Subreport type. It is a section type
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  3. #3

    Thread Starter
    New Member
    Join Date
    Mar 2006
    Posts
    2

    Re: CR 8.5 type mismatch help!

    I should have posted the rest of the code:

    Set CommSub = Report.Details
    CommSub.OpenSubreport.Database.SetDataSource AdoSub.Recordset, 3, 1

    Since Details is a section, how should the OpenSubreport function be handled? Are different versions of CR this unique?

    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
  •  



Click Here to Expand Forum to Full Width