dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
39.25k stars 3.4k forks source link

Not Able to Generate PDF Where the ER Diagram Fits On One Page #22354

Closed lm-cgodwin closed 8 months ago

lm-cgodwin commented 8 months ago

Description

I created an ER diagram that contains 21 tables. When I generate a PDF from this ER diagram, the diagram is rendered on multiple pages instead of one page. Prior to generating the PDF, I changed the page orientation to Landscape and the Paper size to A3. Is there a way to generate a PDF of an ER diagram that fits on one page?

DBeaver Version

DBeaver Enterprise 23.3

Operating System

Windows 11

Database and driver

  1. MS SQL Server 2019
  2. MS SQL Server (PRO)

Steps to reproduce

  1. Click the Print icon that is displayed in the bottom right toolbar.
  2. Once the Printing from Win32 application modal appears, select the following options:
    • Printer: Microsoft Print to PDF
    • Orientation: Landscape
    • Click More Settings link
    • Once Printing Preferences modal appears, click the Advanced... button
    • Once the Microsoft Print to PDF Advanced Document Settings modal appears, select A3 for Paper Size option.
  3. Click the Print button
  4. Provide a file name for the PDF file and click the Save button. Expected outcome; ER diagram within the PDF document is rendered on one page Actual outcome: ER diagram within the PDF document is rendered on multiple pages. Scheduling ER Diagram Printing_Preferences Microsoft Print To PDF Advanced Document Settings

Additional context

No response

ShadelessFox commented 8 months ago

Hello @lm-cgodwin,

As a workaround, you can export to PNG and then manually add that PNG to your PDF. Otherwise, you can print PNG directly.

image

ShadelessFox commented 8 months ago

I just realized that we have a dedicated option for changing how the diagram is fit:

image

Please let me know if it helps.

lm-cgodwin commented 8 months ago

@ShadelessFox, that worked! Thank you so much for all of your help!

ShadelessFox commented 8 months ago

Since the issue is resolved, I will close the ticket.

nasrulhazim commented 5 months ago

I just realized that we have a dedicated option for changing how the diagram is fit:

image

Please let me know if it helps.

works like a charm! thank you!