Exporting SQL Developer Reports/Grids to PDF

thatjeffsmith SQL Developer 5 Comments

Tell Others About This Story:

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.

Related Posts

Tell Others About This Story:

Comments 5

  1. Hi Jeff,

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

    Thanks!

      1. thatjeffsmith Post
        Author
  2. 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

    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *