Crystal Reports error (RESOLVED)

[divined]

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 :


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

[divined]

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.