Converting Reports

rbuser

Is there any way to convert all the reports which was developed using shazam
report to Report builder reports ?

digitalmetaphors

There is no converter that we are aware of. You could extract the SQL text
from the queries you build with shazaam and dynamically create query
dataviews in DADE. Then assign the SQLtext directly to the dataviews. The
syntax will be to extract the datamodule form the report, then add a
dataview, then get the TdaSQL object from the dataview. Then set the
SQLText property. You'll also need to set EditSQLAsText to true on the
TdaSQL object. However, this will eliminate the ability to use the query
tools in DADE.

Here is a demo which extracts the SQL object and creates objects in code and
allows the query tools to be supported without editing the SQLText property.
http://www.digital-metaphors.com/tips/ExtractSQLObject.zip


Cheers,

Jim Bennett
Digital Metaphors