i have this statement

strSQL = "SHAPE {SELECT * FROM TMP_ProductionPayment ORDER BY Shift, KnitterID} AS Payment COMPUTE Payment, SUM(Payment.Payment) AS SumPayment BY Shift"

i generate it in the dataenviroment.

and made a report of this object, then i clean up the datasource of the report.

at run-time i create a recordset from the shape statement

Set rs = cnCKMatrixShape.Execute(strSQL)

'I want to set the datasource of the report to the rs variable

Set rptKnitterPayment.DataSource = rs

but this does not work.

what do i have to do in order to make the report work using the rs variable?