Problem with editing queries.
Here's how to reproduce:-
1) Start a report designer passing it an odbcconnection object
2) Go to Data -> Add Data Source#
3) Add SQL Query
4) create a query, save it, and check it to use in your report.
5) "Finish" the Data Wizard
6) in the data window expand "data sources" -> "connection" -> "[your query]"
7) Right Click on "[your query]" and click "edit"
8) on "set the name" click next
9) on Enter SQL statement click query builder
There is the problem:-
*on designer, no tables to choose from,
*SQL window is blank
*click results and you get "The ConnectionString Property has not been initialized"
Thanks,
Anthony
Comments