I am using VB6 with crystal reports 9.
I have this SQL statement as a command in crystal reports.
SELECT DISTINCT Samplepoint, TestType, SUM(Result)
FROM Daily WHERE Result <> 'none'
GROUP by SamplePoint, TestType
On my VB form, the user will select two dates to search between, and only results that occur between those two dates will be displayed on the crystal report.
How would I do this?
Can VB change the crystal report SQL command at runtime?
Many Thanks
