You can save query results or any other grid in SQL Developer as a PDF.

You don’t get much in terms of saying how the generated PDF should look –

And the resulting PDF doc isn't very exciting either.
And the resulting PDF doc isn’t very exciting either.

Said PDF file:

Mostly meh.
Mostly meh.

But I have some important info in here, and it should look a bit nicer.

Save Your Query As A Report

And then format your report, using the PDF properties.

You can set all kinds of properties for the PDF now.
You can set all kinds of properties for the PDF now.

You can set a customer header and footer, define the fonts to be used, if you want shading on the grids, spacing, page orientation, and more.

Once you have it defined – save and refresh your report.

Then run the report, right click in the grid, and export to PDF again.

You’ll notice that the report title, subject, and keywords are already defined.

Not exactly pretty, but an idea of what you can do.
Not exactly pretty, but an idea of what you can do.

You can also embed the fonts in case the user getting the report doesn’t have them so it renders as intended.

More importantly – you can set security options like defining a password required to open the report, and whether or not to allow the data to be copied out.

The PDF exports for reports are only available for grid style reports. For reports having child reports, the export will only grab the parent/master report.

thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

5 Comments

  1. Hi Jeff,

    This is great, but how can I export the reports that I’ve created and import them into another computer?

    Thanks!

    • Sorry, I forgot to mention that I keep my reports organized by folders and I have plenty of such folders! Thanks

    • thatjeffsmith

      Right-click on the folder.

      Save.

      Take that XML file to your new computer.

      Right click on User Defined Reports.

      Open – point to the XML file.

      Your folder and any folders/reports contained on your old computer will now be there.

      Answer in blog format with pics.

  2. Manuel Vargas Reply

    Hi Jeff, I’m able to generate the PDF file but I don’t find where to configure the page orientation, I need to change it to landscape to be able to show all columns in the same page. Thanks

Write A Comment