Sparx Systems Forum

Enterprise Architect => Suggestions and Requests => Topic started by: fwoolz on June 04, 2010, 11:37:09 am

Title: SQL in RTF templates?
Post by: fwoolz on June 04, 2010, 11:37:09 am

When working with the RTF report generator, I have often found myself wishing that I could plunk an SQL query between template tags to get just the elements and fields I want given the context set by the tag, in the order I want them, and then feed them into, say, a table with RTF merge fields acting as placeholders for the results of the query. My only recourse to date has been either to a) get as close as I can with the RTF generator and "settle;" or b) go outside of EA and access the underlying RDBMS directly.

Does anyone second this?

Thanks,
Fred W

Title: Re: SQL in RTF templates?
Post by: Paolo F Cantoni on June 04, 2010, 01:20:55 pm

Hi Fred,

Can you expand on this?  I'm not clear what you're requesting...

How would this be different from using a bespoke query to select the elements via virtual document?

Paolo

Title: Re: SQL in RTF templates?
Post by: fwoolz on June 05, 2010, 05:13:26 am

I was thinking of something with a bit more flexibility, e.g. a bit of programmatic code mixed with pure SQL, that would allow the report to adapt, as it were, to the results as they are being generated. Maybe a better description would be scripting + SQL embedded in a report template.

Cheers,
Fred W