Report Writer: ER Relations list

General Questions/Discussions
1

Hi,
I have a ER diagram and I want to generate a documet with report writer.
In this document I want to put the list of Relations and for each relations I want to put the detail.
Can you help me?
I attach some images.

Thanks

EntitySpecDetail.jpg596×580 53.5 KB

EntitySpecDetail.jpg

ERDiagram.jpg

EntitySpec.jpg

2

Hi user,

Thanks for your post. The modelType os relationship is “DBForeignKey”, you can find the sample template below, this sample will show list of Foreign Key Relationships exists in the ERD.

Hope this helps. If there is any further inquiry, please do not hesitate to ask.

Best regards,
Lilian Wong
ForeignKeys.xml

3

Hi Lilian,
This, It’s ok!
Thanks!

I have another question:
I want to generate into document (with report writer) the list of Foreign Key Column Mapping.
Can you help me???

I attach some images.

Thanks.

EntitySpec_2.jpg

EntitySpecDetail_2.jpg

ERDiagram_2.jpg

4

Hi user,

Sorry for my late response. I would like to let you know that we enhanced to show Foreign Key column mapping in the ERD, please install the latest patch which is available in the following link:
http://files2.visual-paradigm.com/200902/Patch/sp2_20090212e/VP_Suite_Windows_3_4_sp2_20090212e.exe

Also, please find the sample template for showing FK column mapping attached in this post, and the image below shows the output with the sample template.

Hope this helps. Feel free to have a post if there is any inquiry.

Best regards,
Lilian Wong

FK_mapping_in_ERD.png526×952 30 KB

FK_mapping_in_ERD.png
ForeignKeys.xml