I have followed the "Report Variables" sample in the Visual Basic code folder. My report uses ADO to connect to a SQL Server through a DSN connection.
If I select one table only, my report works fine passing a SQL Query. In the Designer, the table is called "ado". If I uses more than one table, things get very weird, even if they are linked properly. For exampl with two tables, if I select the "SerialNo" column on a report, the "ShipDate" field might show up on the report instead. What is up with that?!?
I have tried setting the location to the Database.dbo.table but then cannot pass the SQLQuery from another area. I've also tried changing the SQL Query to "SELECT *" and then the two linked tables, also just selecting the columns I want from the tables but nothing matters.
What am I doing wrong?
Thanks for any help,
Gary Comstock
If I select one table only, my report works fine passing a SQL Query. In the Designer, the table is called "ado". If I uses more than one table, things get very weird, even if they are linked properly. For exampl with two tables, if I select the "SerialNo" column on a report, the "ShipDate" field might show up on the report instead. What is up with that?!?
I have tried setting the location to the Database.dbo.table but then cannot pass the SQLQuery from another area. I've also tried changing the SQL Query to "SELECT *" and then the two linked tables, also just selecting the columns I want from the tables but nothing matters.
What am I doing wrong?
Thanks for any help,
Gary Comstock