on 2012 Mar 30 3:39 PM
We have a need to create documentation for the reports we have running in Enterprise. The documentation needs to contain the tables, fields ans sql of the reports, so it can be searched for database schema changes. Does anyone know of a tool that can assist in this effort?
Request clarification before answering.
Hi Mike,
If you have a developer available you can get this info quite easily using our .NET or Java SDK's.
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Debi and Mike,
Go to sap.help and you'll find the SDK help files
And you can find samples here:
http://wiki.sdn.sap.com/wiki/x/JQBmBQ
home page for SDK help is here:
http://scn.sap.com/community/crystal-reports-for-visual-studio/content
Search .NET SDK forum, lots of info how to use various Controllers to get the Report Object Collection and the SQL Statement.
If any questions have your developer post to that forum.
Thanks again
Don
Mike,
Database \ Show SQL query ? The Database Expert Data window lists the tables...
Once upon a time, Crystal had a function to list the tables and fields used in a report. I do not see it any longer.
Debi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.