Monday, April 16, 2007

Interactive Reports part 3

The next step to having all these great reports in xml files would be to organize them. This one is the simplest by far. The name of the folder is split on the / and sub folders are made. This is very handy when a report gets into 100s of lines of xml since the reports can now be stored in multiple files but foldered together in the tool. Like in sqldev the "Data Dictionary Reports -> Database Administration -> Sessions -> Session Reports" report which allows kill/trace sessions is over 500 lines by itself and in a separate file.


<folder>
<name><![CDATA[my/great/report]]></name>
<display>.....</display>
</folder>



2 comments:

ArKZoYD said...

Kris,

Your threads are very useful as you can guess ! Is it possible to create click able reports ?

Gregory

Kris Rice said...

What do you mean by clickable? Drill down or context menus or something else? Context menus are in this blog and drill downs are discussed here in an article Sue wrote http://www.oracle.com/technology/oramag/oracle/07-may/o37sql.html