Sql generated by viewer

[Jan_M._Socorro_(Guest)]

Using:__R&R Report viewer SQL edition 8__SQL Server 2005__VB.net 2008____In the generated SQL query from the Viewer;__Those report that WORK have the User in the where clause without ""__ Example: user1.Table1 ____Those reports that DOES NOT WORK have the User in the where clause with ""__ Exmple: "user1".Table1____This was tested in a computer without R&R fully installed but has all the files required to run a report. But in a computer WITH R&R fully installed all reports work.____The error from R&R:__ The column prefix ^Table1^ does not match with table name or alias name used in the query.____I tired:__ Re-select the tables of the report,but all the users from My Database have ""__ Example: "user1"__ "user2"____Question: __Theres something I can do to remove the "" or iam missing a file from R&R?__ __________

[kfleming]

Are you running the viewer from the same folder as the designer? If not, do you have the file RSWSQL.INI in the viewer folder?____Kathleen__R&R Support

[Charles_(Guest)]

I^m having the same problem since my data source has been converted from sql 2000 to sql 2005. I had to comment out "DataSourceOuterJoinStyle=1" from the ini file because it was using non-ansi joins (ie. =* in the where statement versus using "left outer join") but now I^m having problems with the quotes around everything... "dbo"."table1"