Reports are one of my favorite features. If you don’t use them in SQL Developer, please read this.
The user interface for user defined reports is very simple in SQL Developer. Maybe even, too simple?
Sometimes I tell folks to save and/or copy their reports around. And it’s not exactly apparent how to do this at first glance. Of course, once you’ve done it once, it’s very obvious. As a product manager, sometimes it’s easy to forget what the tool looks like from the outside.
If You Want To Give Someone Else Your Report(s)
Just save it, and have them open it.
Either way, the output is a single XML file.
If I send that file to someone, all they need to do is in the reports tree, open it where they want the report or reports to go.
So if I wanted to give someone this set of reports I created for my KScope14 presentation on SQL Developer Reports, it’s just one click for me, and one click for the person I’m sharing it with.
Moving Reports Around In SQL Developer
You can’t edit the canned reports we ship, but you CAN copy them down to the user defined reports. Or, maybe you want to make a copy of a report and branch it into a new version.
Just copy and paste.
Now, where do you want to put it?
And here’s my new report.
All of your reports are saved in one XML file. You can find this file in your OS $USER$ directory. Feel free to play with the underlying XML if you want, but you’re on your own at that point. There is at least a couple of cool tricks you can pull off though 🙂