VB6 DataReport and ADO
I've never used the DataReport and want to display/print some parametrized queries from SQL Server at run-time, such as ".. WHERE EmpId = <variable>".
Q_1: Is there a way to generate a recordset and subsequently display it via DataReport ? I generate a lot of recordsets for the HFlexGrids in my software, but somehow I cannot do it with the DataReport.
Q_2: If I have to use the DataEnvironment, how can I parametrize my query so that it can use run time parameters ?