Hi,

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 ?

Thanx

Mike

Select the SQL option in the command properties.
Ex: SELECT empno,empname,dept FROM emp WHERE empno=?

and in the next page select the datatype of the parameter

if it is number select Integer