Reporter Setup:

1. Install the Reporter class where your application server knows about it.
2. A profile is kept on the server in a properties file (reporterConfig.properties). The first time the class is run, this properties file is created with default values.
3. Note the URL in the example is the default site and port information on my box. Your url will differ for your web site. The key is the QueryString ?list_properties. http://localhost:8080/reporter/reporter?list_properties is the URL that allows you to edit the properties. You can change the ("showadmin") property to "no" so only those in the know can edit the profiles in the properties file. Yet durring setup, it is handy if it is on the page.
4. Now the page allows you to maintain:
   • the look of the page, text, graphics, colors and style.
   • the connections ( driver, prefix, dbuserId ,dbpassword) You may wish to use the Oracle driver. where db1.denveronline.com is your IP for your server. And if you changed the default port from 1521 then you will want to change that as well. And of course the particular space is most likely not prod.
     • driver oracle.jdbc.driver.OracleDriver
     • prefix jdbc:oracle:thin:@db1.denveronline.com:1521:prod
   • the sql for the report currently : tablelist.sql_1 through _3 but you can add new ones at the bottom. It is just SQL. It is executed and the result set is analyzed and displayed.
   • tablelist.query_1 through n allows the navigation text.