The new preference, Include select statement in views reports, for reporting in Data Modeler 4.2EA includes the SQL statement used for the query to the report.

ea2_14

To generate a report on views select Table Views report template:

ea2_10

If the preference has not been set the report would look something like this:

ea2_12

And if it has been set it might look something like this:

ea2_11

The report will show the SQL statement for the view in the new Select Statement field in a report template for Table Views.

 

 

Advertisements