BIRT 2.1.2 Report Input parameters

I have created a new custom report using BIRT 2.1.2.
For this report I have input parameters for startdate, enddate, siteid, status, etc.
I have successfully imported the report and I can run it in Maximo v7.
However the report's input parameters don't seem to take any effect, i.e.: If I inputonly today's date as start and end date the report still gives me a month's records. If I select the report for only one site, the report give me the records for all sites.

The out-of-the-box reports' input parameters work like a charm (i.e.: case_volume_sum.rptdesign).

Can someone let me know what I could have skipped in setting this correctly?

Thanks,

sgavriel

Find more posts tagged with

Comments

Virgil Dodson

Hi sgavriel,

Are you creating input parameters in the dataset? Generally, (for typical SQL queries) you put some question marks in your query... and then input parameters are created for you that you just need to assign a value... Then you can add a default value... or link them to report parameters (created in the Data Explorer window).

Dragunov

This is possibly a problem of passing of parameters from maximo to BIRT. I dont think there will be any problem with query. It just takes the parameters that it was provided from maximo parameter window. 
 
You can verfiy your parameters passed from maximo by logging it 
To enable logging of report params see this IBM link 
<a class='bbc_url' href='http://www-01.ibm.com/support/docview.wss?uid=swg21319606'>IBM - Debugging BIRT Report parameters</a>

sgavriel

Can you please provide any link(s) explaining how to configure properly these input parameters? It has to work correctly in birt designer 2.1.2 first before importing the report in Maximo 7.

I saw tcr_style_guide.pdf and on page 82 onwards it shows some very interesting ways of using input parameters, though it doesn't clearly explain how.

Thanks,

sgavriel

SpaceMan

Here's a link for pdf on reports, chapter 5 is about parameters: 
 
<a class='bbc_url' href='http://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.mam.doc_7.1/pdf/mam71_report_dev_guide.pdf'>http://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.mam.doc_7.1/pdf/mam71_report_dev_guide.pdf</a> 
 
 
Most the time I access my parameters in my Dataset. 
 
Ex: 
 
sqlText = "Select status, Count(*) RecCount" 
+ " from workorder " 
+ " left join fincntrl f on workorder.fincntrlid = f.fincntrlid " 
+ " left join person p on workorder.supervisor = p.personid" 
+ " where " + params["where"] 
+ " and workorder.istask=0" 
+ " and workorder.historyflag=0" 
+ " and upper(workorder.status) = '" + params["status"] + "' as status " 
;