General information
Category:
Database DAO/RDO/ODBC/ADO
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?
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only