Book a Demo

Author Topic: SQL Procedures in RTF Reports  (Read 2844 times)

Cat Walker

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
SQL Procedures in RTF Reports
« on: June 18, 2010, 08:43:17 pm »
It is easy to import SQL stored procedures into EA. ;D
I'm having a nightmare trying to report the body of the stored procedure SQL into a report. Anyone clued up?

Refinements to request. When EA reverse engineers stored procedures, any descriptions you've added to the model element are lost. So I nest the stored procedure in a component element, and alongside the procedure I also nest an analysis time diagram of the logic in the procedure. So my model package is structured with a set of components representing the analysis time procedures, each with a diagram of the logic and then the reverse engineered procedure itself.

I want to report these one-by-one with the name, description, diagram and SQL code. Should be simple, yeh? I have found it to be not so.  :'(
« Last Edit: June 24, 2010, 06:28:24 pm by Catwalker »