Page 1 of 1

Converting Reports to use SQL

Posted: Tue Jun 22, 2004 11:46 am
by Chris_Barnes
Hi,____We have been using R&R XBase for many years and are now in the process of developing an SQL Based version of our software. Is it possible to simply convert our exisitng reports to point to an SQL Database with the same table names? ____Or will we , as I suspect, have to re-write the reports?____Thanks

=> RE: Converting Reports to use SQL

Posted: Wed Jun 23, 2004 8:49 am
by kfleming
You do not need to re-write the reports. You can use the RRCNVRT.EXE Report Converter that is found in the R&R Utilities program group.____Select the radio button RRW to RSW (Xbase to Windows SQL) then select your Xbase report and press Convert. R&R will ask you to select an ODBC data source and then will do the conversion.____When you open the report in SQL, you may first see an error "Cannot open master table. Try a different data source?" Answer No to this question. It will then ask "Re-select master table?" Answer Yes and you will see the SQL table list. Select the correct table and away you go. You may also need to repeat this process for each related table and will also likely need to edit any joins to select the correct matching fields.____But once this is done once and saved, the report will run against the SQL tables.____How much conversion cleanup is required depends on the individual report. But if your data structures are as they were in Xbase, it should not be too difficult to do the conversion.____Regards,__Kathleen__R&R Support