SQL Problems

[Thomas_Ruschak_(Guest)]

I^m trying to convert some old RR5 reports to RR9 (v9.0.009) SQL.____I have a SQL Server with tables corresponding to the old dbf files. I have converted the RR5 reports to an RR9 XBase report, just to make sure it works, which it does.____Now, I try and use the Report Conversion Wizard to change the RRW report over to an RSW. It wants to know if I want to use existing tables or change platforms. The help says: ____"Select Change platform if you have tables in a different platform that match the Xbase tables your .RRW reports are based on and would like the .RSW reports to be based on these new tables."____That^s what I want, so I choose change platform. I then tell it to use an existing data source, and choose my SQL Server from the drop-down list.____It prompts me to log in, and I do.____It asks me if I want to use existing table/field names. Some field names had to change slightly when I moved the tables to SQL Server (conflicts with SQL Server reserved words), so I choose "change table or column names"____I then select the RRW file.____It then lists the new/old tables. When I right click on a new table to change the fields, it lists both the old & new with the new field names, which makes no sense to me, so I just tell it to convert. It gives me the following output:____Report Conversion Wizard, Friday, April 26, 2002 11:21__********************************************************************************__Data source: TOM1100__ODBC driver: SQL Server____<<<< Report: Balance Sheet.rsw >>>>____WARNING Index: The report uses a master index. The report may need to be modified to specify the order in which records are processed.____WARNING Scope: The high scope value "ÿ" cannot be converted. Scopes can be implemented in R&R using filters.____RELATION:__ Related file: GL_LINEG.NTX__ Linking field: GROUP__ Index file: GL_LINEG.NTX__ Tag: None__WARNING Index: The report uses an index file. The key expression for this index will be converted to an SQL join condition.____RELATION:__ Related file: GL_ACCTL.NTX__ Linking field: LINE_ITEM__ Index file: GL_ACCTL.NTX__ Tag: None__WARNING Index: The report uses an index file. The key expression for this index will be converted to an SQL join condition.____ERROR Relation: The relation contains a partial join, which is not directly supported in R&R. See "Partial Joins" in the help file for ways to modify the report to support this feature.____RELATION:__ Related file: GL_TXG.NTX__ Linking field: GL_NO__ Index file: GL_TXG.NTX__ Tag: None__WARNING Index: The report uses an index file. The key expression for this index will be converted to an SQL join condition.____********************************************************************************__ Reports processed: 1__ Reports converted: 1______When I go to open the report in the designer, it wants me to reselect the master table. If I tell it I don^t want to, it doesn^t load the report, so I try to reselect it. I pick the table from the drop down list and it says:____DB access: The connection, statement, or query handle you provided is not valid.____Then:____Table contains no supported fields____Then:____Table contains no supported fields: "SLSCO1P2.SLS."GL_GROUP"____Then:____Library error (cannot open file) reading report C:RR9Balance Sheet.rsw____What am I doing wrong?____HELP!____Thanks,__Tom____

[Mike_Grace_(Guest)]

I am having the same problem.____

[kfleming]

I think that Tom and I were able to resolve this one outside of the forum.____If you can email one of your problem reports to me, I can tell you how to get around the problems you are seeing.____If you need to re-map field/table names in SQL let me know that as well.____Kathleen__R&R Support__kfleming@livewarepub.com