Liveware Publishing Support Forum

Kathleen,____SQL 9^s lack of library support has caused us to have to rework the way our application integrates reports. No big problems except one. some of our reports are "User Reports". These won^t open correctly in v. 9 once they are saved to rsw files from the rp6 library. When trying to open them in the developer, we get a SQL error indicating that the "objects" (tables) can^t be found and asking if we want to select a different data source or edit the select statement. We tried that and it still won^t open.____I don^t get it. We^re using the same SQL DSN on the report as when it was in the library.____Are you aware of any problems with User Reports converting from a library or otherwise in v9? I^m actually able to save the report to a rsw file from the library without an error, but then when I close the developer and reopen it and try to open the rsw, I get the error.____The tables are referenced in the select statement solely with their name, such as "Items" without any reference to the database name or owner (dbo).____The select statement runs fine in SQL Query Manager (SQL Server 2000).____Max

Please ignore this post. I discovered a problem with my DSN that only cropped up with User reports, not Auto reports. Thanks

Sigh of relief that you found it!____Kathleen__R&R Support