https://addons.mozilla.org/en-US/firefox/addon/live-http-headers/

Follow the guide to install the add-on (it’s pretty simple to install)

Go to the OIA Report URL where you are about to run the report. Before pressing the ‘run’ button to run your report… go to TOOLS - LIVE HTTP HEADERS within Firefox (This will open up a new window, which will allow you to see the http information passing to the app server within the http header). Request for the report with the date range parameters. You will see something like this when executed correctly

It shows that it is passing 2 string values. 2 first rows show the values, the { } brackets reference those values

c0-e1=string:08%2F01%2F2011 c0-e2=string:08%2F02%2F2011 c0-param1=Object_Object:{startDate:reference:c0-e1, endDate:reference:c0-e2}

This means that the ‘startDate’ and ‘endDate’ is being passed Go into ireports and design your

For testing purposes, I created a SQL script below which I used in the ireport wizard.

SELECT name, period
FROM rbacxservice.ID_CERTS WHERE period
between to_date ('08%01%2001', 'mm/dd/yyyy')
AND to_date ('08%01%2011', 'mm/dd/yyyy')

Note: '08%2F01%2F2011' is getting passed through within the string though to test this in SQL it has to be '08%01%2011’ not '08%2F01%2F2011'

When you have your report working and connected to the OIA database, go to the right hand side and add a new parameter called endDate and startDate

Put the values in as ‘string’ When go to the report query to look at the query you have created

SELECT name, period
FROM rbacxservice.ID_CERTS WHERE period
between to_date ('08%01%2001', 'mm/dd/yyyy')
AND to_date ('08%01%2011', 'mm/dd/yyyy')

SELECT name, period
FROM rbacxservice.ID_CERTS WHERE period
between to_date ($P{startDate}, 'mm/dd/yyyy')
AND to_date ($P{endDate}, 'mm/dd/yyyy')

Save and push through to OIA and watch it work

About the author