# Help!This is a little but odd problem!Please help me!

Posted by Fai on August 09, 1999 at 15:35:19:

TRANSFORM Sum((TotalCost))
SELECT format((CompleteDate),'mm/yyyy')
FROM OrderRecord LEFT JOIN Customer ON OrderRecord.CustID=Customer.CustID

where CompleteDate between ? and ?

GROUP BY format((CompleteDate),'mm/yyyy')
PIVOT (DeptCode);

The above code is success when the first ? replace from #1/1999# and the second ? replace from #9/1999#

The DataType of Param1 is AdDate and the HostDataType of Param1 is Date(VT_DATE) and
that of Param2 is the same.
Then, I insert the value of parameter as follow and then open datareport
DataEnvironment1.CrossTable Format(#1/1/1999#, "mm/yyyy"), Format(#1/9/1999#, "mm/yyyy")
DataReport3.Show

The DataReport3 return error message called "Failed getting Rowset from current data source"
How can I fix this problem?
Thank you very much!

Follow Ups: