Liveware Publishing Support Forum

Hi,____We are using R&R version 10 and need to convert a few hundred R&R reports to SQL because we are moving from dbf to ADT files.____I have some questions and problems.____1) Will the R&R SQL convertor in version 10+ correctly convert the reports? I have had problems with it in the past (version 9 and 8). It used to report odd errors and basically fall over.____2) I saw a post from last year which stated that native ADT support was being considered. Is this going to appear anytime soon?____3) We have a lot of what I call multi part reports where the first part exports a dbf file, then the cmd file launches part 2 which picks the dbf file and carry^s on basically to allow data bending which is not possible with a single report.____I know with the SQL version, you can still export the dbf file but it would mean that the subsequent parts would not be using the SQL database therefore negating the use of SQL.____Also, because we launch the runtime from an icon, how is it possible to switch from the sql runtime to the xbase runtime whilst running each part?____4) Has anyone else moved lots of reports from dbf to SQL?__If so, what are your experiences.__

What no one has ever dealt with conversion?____Hmmm. Time to look at other reporting tools I think____Thanks

There are two conversion utilities with V10+. The first is a wizard that walks through step by step and the second is RRCNVRT.EXE where you select the report to convert and a destination datasource.__The latter is the simpler way to go.____However using the converted reports against SQL tables depends a lot on the nature of the design of the report and how the structure of the SQL files compares to that of the Xbase ones. Some reports will require few or no changes and others may need major modifications before they can be run in SQL. For example an Xbase reports that includes partial match relations against complex index expressions will need to have those joins edited in SQL. And if you are using any Xbase only functionality such as the RECNO(DBF) function, that would need to be changed as would any relations containing terminate failure actions. Or if your reports use User Defined functions, you would need to have those same functions defined on the SQL side.____Native ADT support is still on the enhancement list but a delivery date is still not determined. ____To sequentially run Xbase and SQL reports, you might want to look at the RapidRunner utility that is included in R&R Version 10+. You can create a run a Rapid Runner set that includes both Xbase and SQL reports.____Kathleen__R&R Support

Ah O.K. Kathleen.____I have been using the wizard up to this point, but I will try the other way first.____Regards____Mike