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 :
rsListaEpiskeywn, the Recordset, has at least one record in it. What could be the cause of this error?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
thx, in advance
George Papadopoulos




Reply With Quote