Tabular Reports

[kewldee]

Hi all, I have been modeling in EA for a while but my knowledge on custom reports is very limited. My team has a requirement to create a tabular report as shown below. We need this for all the objects in a package. Any suggestions on what would be an optimum way to get that tabular report from EA? Are there any threads on this topic in this forum that I can go through ?

Any suggestions are appreciated.

Table Columns
Source Multiplicity   Source Role Name   Source Name   Connector Name   Target Role Name   Target Name   Target Multiplicity                  

Thanks
KK

[qwerty]

Maybe you can use a diagram in list view for that?

q.

[Geert Bellekens]

If you are only looking for an export of this info I would suggest using an SQL search.
You can export the results of a search to CSV and then use it in excel.

If you are looking for a nicely formatted table in an RTF/docx/PDF document then you'll have to look at the RTF document generator templates.
With those templates you can also create SQL fragments to get tabular information like this into the document.

Geert

[kewldee]

If you are only looking for an export of this info I would suggest using an SQL search.
You can export the results of a search to CSV and then use it in excel.

If you are looking for a nicely formatted table in an RTF/docx/PDF document then you'll have to look at the RTF document generator templates.
With those templates you can also create SQL fragments to get tabular information like this into the document.

Geert

Thanks for the suggestions. I tried the query builder but the fields in the result set are very limited. I did not see the multiplicity or the role name in the result set field chooser anywhere. So they will not show up ever. In the query builder search, can the fields that display in the result set be customized beyond what's in the field chooser ?

Looks like at this point using fragments in the doc templates is the way to go. I googled but the help available in limited. Any suggestion on where I can find more help on using fragments?

[kewldee]

Maybe you can use a diagram in list view for that?

q.

Thanks for the response. I tried this but the number of columns that display in the list view are again limited. The field chooser does not have fields/columns like multiplicity or role name. Do you know if there is a way to customize list view to include fields like multiplicity etc ? 

[qwerty]

I guess that's fixed. However, you can write your own query representing the results in a list as well. Use the Query Builder to issue an according SELECT.

q.

[kewldee]

Thanks for the responses you two. SQL query search, as suggested above, is the way to go. Best part is - now that I got used to the EA tables, I am able to generate a lot more custom reports with ease.

BTW, sry for the delay in response. Was outta town.

[benc]

Hi Kewldee,

Very late reply - and too late for your project obviously . For others starting out with generating tabular reports in EA - say for a data dictionary and the like - this 2-part webinar shows how to do it with a complete worked example:

Part 1 (Basics)
https://sparxsystems.com/resources/webinar/documentation/data-dictionary-basics/enterprise-architect-document-generation-basics.htm

Part 2 (Style sheets, custom queries and virtual documents)
https://sparxsystems.com/resources/webinar/documentation/generate-enhanced-documentation.html

I hope that helps (someone) 

Ben

[kewldee]

Hi Kewldee,

Very late reply - and too late for your project obviously . For others starting out with generating tabular reports in EA - say for a data dictionary and the like - this 2-part webinar shows how to do it with a complete worked example:

Part 1 (Basics)
https://sparxsystems.com/resources/webinar/documentation/data-dictionary-basics/enterprise-architect-document-generation-basics.htm

Part 2 (Style sheets, custom queries and virtual documents)
https://sparxsystems.com/resources/webinar/documentation/generate-enhanced-documentation.html

I hope that helps (someone) 

Ben

Thanks a lot. These are helpful.

[Rich Anderson]

For stuff like this, I just write a VB.Net program in Visual Studio Community edtion that populates and Excel workbook directly using .NET calls and some simple looping.   I find I can create pretty much anything I want this way.