Results 1 to 2 of 2

Thread: Crystal Reports error (RESOLVED)

  1. #1

    Thread Starter
    Hyperactive Member divined's Avatar
    Join Date
    Aug 2004
    Location
    Thessaloniki, Greece
    Posts
    447

    Resolved Crystal Reports error (RESOLVED)

    Hello everybody

    I have created a Crystal Reports report using the RDC. Then I feed the report with a Recordset. When I try to set it to a Crystal Reports viewer control I get the error.

    Cannot determine the queries necessary to get data for this report. This is the code I`m using :

    Code:
      CrystalReport_episkeyhKlinikhs.Database.SetDataSource rsListaEpiskeywn, 3, 1
      
      Set p1 = CrystalReport_episkeyhKlinikhs.ParameterFields.GetItemByName("Title")
      p1.AddCurrentValue (rsYphresia.Fields("Yphresia").Value)
      
    
      Set p2 = CrystalReport_episkeyhKlinikhs.ParameterFields.GetItemByName("DateStart")
      p2.AddCurrentValue (strGlobalDateStartEuropeanFormat)
      
      Set p3 = CrystalReport_episkeyhKlinikhs.ParameterFields.GetItemByName("DateEnd")
      p3.AddCurrentValue (strGlobalDateEndEuropeanFormat)
      
      
      Set p4 = CrystalReport_episkeyhKlinikhs.ParameterFields.GetItemByName("Klinikh")
      p4.AddCurrentValue (strGlobalKwd_Klinikhs)
        
     
      crViewer1.ReportSource = CrystalReport_episkeyhKlinikhs
      
      
      CrystalReport_episkeyhKlinikhs.AutoSetUnboundFieldSource crBMTName
      
     
      crViewer1.ViewReport
    rsListaEpiskeywn, the Recordset, has at least one record in it. What could be the cause of this error?

    thx, in advance

    George Papadopoulos
    Last edited by divined; Jun 27th, 2005 at 12:33 AM.
    SteadFast!

  2. #2

    Thread Starter
    Hyperactive Member divined's Avatar
    Join Date
    Aug 2004
    Location
    Thessaloniki, Greece
    Posts
    447

    Re: Crystal Reports error

    Actually, it seemed to be some intricate and slight error in the report. I copied a working report and then it all fell into place.
    SteadFast!

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