Data Reports through ODBC

[Cyberseduct]

I am using vb6 Data Report using an ODBC connection. My reports that are static (i.e, Reports generated directly from the database without passing any parameter) is OK. The problem is when I try to insert a parameter in the SQL builder it is not being accepted. The same thing works correctly with a connection string but not with an odbc connection. What may be the problem? How can i overcome this as the reports will be on network?

thanks for your help

 

[MikeBronner]

I have done several reports using variables myself. this is how I basically set uyp my database queries:

adoRecord.Source = &quot;SELECT * FROM Table WHERE Datafield = &quot; & variable1 & &quot; AND Date <= #&quot; & datevariable & &quot;#&quot;

that of course is just an example of an SQL query. hope this helps a bit Best Regards and many Thanks!
Michael G. Bronner X-)

&quot;Beer is proof that God wants us to be happy.&quot; Ben Franklin