{"id":173,"date":"2006-06-01T15:38:31","date_gmt":"2006-06-01T22:38:31","guid":{"rendered":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/06\/01\/reporting-in-60-seconds\/"},"modified":"2006-06-01T15:38:31","modified_gmt":"2006-06-01T22:38:31","slug":"reporting-in-60-seconds","status":"publish","type":"post","link":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/06\/01\/reporting-in-60-seconds\/","title":{"rendered":"Reporting in 60 seconds with Oracle XE"},"content":{"rendered":"

Ok, well maybe not 60 seconds but more like 5 minutes. <\/p>\n

Some great news today from Pentaho.\u00a0 Pentaho has purchased proprietary software for visually building reports and donated it to the open source community.\u00a0 The full text of the announcement is here<\/a>:<\/p>\n

\"\"<\/p>\n

\u00a0More on this in a later post… Let’s get to the bits.<\/p>\n

Much of what I’ve been hearing in the marketplace is the perception that Open Source has hidden costs in terms of usability and the technical savvy needed of users.\u00a0 <\/p>\n

\n

Let us try and challenge this assumption and see how "productive" we can be building a simple database driven report.<\/p>\n<\/blockquote>\n

Download the Report Designer here and unzip it to a directory of your choosing.\u00a0 There’s zero installation required (you’ll need Java on your computer, but that’s pretty prevalent these days).\u00a0 Double click on the bat file (or .sh if you’re using linux).<\/p>\n

\"\"<\/p>\n

When the product launches you’ll notice a panel that allows you drag and drop elements onto the canvas in an easy to use fashion.\u00a0 I’m sure additional tutorials will come on this blog and Pentaho.org but suffice to say, this is an interface which is easy enough to just "figure out" by playing with it.<\/p>\n

\"\"<\/p>\n

The "RED" circle is our palette and the "BLUE" area is our canvas.<\/p>\n

Let’s get going and start our report!<\/strong><\/p>\n

    \n
  1. Launch the Report Wizard
    \"\"<\/li>\n
  2. Select the option that indicates that you will use your own dataset, a JDBC dataset
    \"\"<\/li>\n
  3. Enter in the connection information and driver location for your database.\u00a0 I keep the latest Oracle Express edition (a Free version of the Oracle database) around.
    Note:\u00a0 You don’t have to do anything special with the JDBC driver (put it in a lib directory or anything).\u00a0 All you have to do is show the wizard where the .jar file is.<\/em>
    \"\"
    I’m using the HR schema which comes with the Oracle database for testing\/sample purposes.<\/li>\n
  4. Navigate to find the "EMPLOYEES" and "DEPARTMENT" tables.\u00a0 Enter in a simple SQL query that contains the data of interest and use the very handy Preview Option to make sure you’re getting the results desired.
    \"\"
    Feel free to just copy and paste if you are using XE as well:
    select
    d.department_name "Department Name",
    e.first_name "First Name",
    e.last_name "Last Name",
    e.phone_number "Phone Number"
    from
    employees e, departments d
    order by d.department_name<\/em><\/li>\n
  5. You can just click Next<\/strong> on the visible feilds screen:
    \"\"<\/li>\n
  6. Highlight "Department Name" and add it to the grouping and hit "Finish"<\/strong>
    \"\"<\/li>\n
  7. It should return you to the original canvas where you can see the design of your report.\u00a0 From here you can start to add images, lines, change fonts, etc.\u00a0 Have fun exploring the richness of the options available here.
    \"\"<\/li>\n
  8. Let’s see what it looks like!\u00a0 Click Preview<\/strong> and page through your report!
    \"\"<\/li>\n<\/ol>\n

    That’s it!\u00a0 You’re done!\u00a0 You’ve created a report that can<\/em> be parameterized, hosted, bursted, distributed in just a few minutes.\u00a0 In a follow on blog I’ll show you how to publish this into the Pentaho server (it’s only about 2 more steps). <\/p>\n

    Happy Trails!<\/p>\n","protected":false},"excerpt":{"rendered":"

    Ok, well maybe not 60 seconds but more like 5 minutes. Some great news today from Pentaho.\u00a0 Pentaho has purchased proprietary software for visually building reports and donated it to the open source community.\u00a0 The full text of the announcement is here: \u00a0More on this in a later post… Let’s get to the bits. Much […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[16,10,11],"tags":[],"_links":{"self":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/173"}],"collection":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/comments?post=173"}],"version-history":[{"count":0,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/173\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/media?parent=173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/categories?post=173"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/tags?post=173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}