Toad World® Forums

Model Report in Excel

Hi,
I Wanted To Know, Can TOAD Data Modeller Generate A Report in Excel Format.
I Want All The Table Names And Their Attributes With Their Constraints.
Please Let me Know is There Any Way In TOAD To Get A Report in This Format in EXCEL Sheet.
Thank You
Raman

Hi,

you can generate CSV files from Toad Data Modeler.
Click Model | Reports/XSL Transformation…
New dialog opens. Choose item Entities (CSV) from the first combo box and click Transform.

This will generate a sample CSV file that can be opened in Excel.

The following file will allow you to generate more detailed report:
http://modeling.inside.quest.com/entry.jspa?externalID=2701&categoryID=407

Feel free to modify the XLS file to generate desired output.

Regards,

Vaclav

hi,
Thanks For Giving Me The Reply,But I Want Entities And Their Attributes And Constraints on Them in The Excel Sheet.
Raman

Hi,

you can customize the XSL template easily, or, if you send me more details, ideally sample model and sample report, I will help you.

Term “Constraints” is too general for me. Tables can have check constraints, columns can have check constraints, relationships…

Regards,

Vaclav

hi,
Herewith I Am Attaching My Sample Excel Sheet,How Actually The Report Should Look…
Hope You Could Help Me…
Raman
SAMPLE EXCEL SHEET.xls (17.5 KB)

Hi Raman,

there is a way how to get similar report, but it would require additional effort.
I published an article that shows how to generate word or excel reports via XSL transformation:

http://blogs.inside.quest.com/modeling/2010/12/22/ms-word-and-ms-excel-reports-via-xslt/

Another possibility you have is to use TDM freeware as a viewer for your models.

Regards,

Vaclav