Reselect Data Source R&R 8.1SQL

[Terry_Carter]

Opening previous reports created with 8.1 SQL/MMSQL7 sucessfully with 8.1 SQL/MSSQL2000 seems to depend upon whether "Use ANSI quoted identifiers" in ODBC was ticked (or not).____If the setting is different, then either the database or all the tables have to be reselected.____Is there any way around this

[kfleming]

When you open a report we always look for the explicitly named tables as they were saved with the report.____Can you turn on the identifier in your 2000 data source to get things to be the same?____Another kludge that might work would be to try converting the report to an RRW file and then back to an RSW file using the conversion wizard (RRSQLWIZ.EXE) rather than the plain converter so that you could try to re-map table names. (Though this might in the end be just as much work as just re-selecting tables when opening in the SQL designer.____Kathleen__R&R Support