Multi-Lookup Birt Report Parameter in Maximo 7

I was wondering if anyone got the Mulit-Lookup functioning on your BIRT reports for Maximo 7? Our company is currently running Maximo 7.1.1.7 and I am able to create reports in BIRT using the drag and drop method after I have established the data source and data sets. I was able to create a multi-value Report Parameter in birt and when I select one value it will report successfully but selecting more than one value yields only the first choice in the list. When I import this same report into Maximo the same thing happens, I select one value it reports fine, if I select more than one value it returns the first value of the list and that is all. Is there a way in BIRT to set it up to take multiple values that understand what Maximo is giving it? I also wonder if I need to upgrade my BIRT Report designer as I am still using 2.1.2 and not 2.3.2.

Thanks for any input you can give me. ^_^

Find more posts tagged with

Comments

Preethisha

hi silerfun,
I am also facing the same error. but i got the solution. After importing reports in parameter section u must check the Mulilookupenbled box.then u can select more values.

Thanks
Subbulakshmi

Silerfun

<blockquote class='ipsBlockquote' data-author="'Preethisha'" data-cid="75790" data-time="1302612496" data-date="12 April 2011 - 05:48 AM">
hi silerfun, 
I am also facing the same error. but i got the solution. After importing reports in parameter section u must check the Mulilookupenbled box.then u can select more values. 
 
Thanks 
Subbulakshmi </blockquote>
 
Really? I did this in Maximo but the report only returned the first value in the selection not the other one's I selected. What else could it be do you think? Can I get a copy of your report so I can look at the xml? Maybe I missed something.

Silerfun

Another person in this form suggested to do this 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/17685-request-parameter/page__s__6e49d63d3bfdc15cb3387345ceef30bb'>Select parameters in Maximo Report</a> 
 
and that worked for me.

cpatel

You can try this one. It worked for me. It creates every parameter with individual OR statement like (problemcode like '122') OR (problemcode like '123'). Try below code in open method of the dataset.

var sqlParams = new String();

if (params["problemcode"].value){
params["problemcode"] = params["problemcode"].replace("=" , "").toUpperCase();

sqlParams += " and " + MXReportSqlFormat.createParamWhereClause("workorder.problemcode",params["problemcode"]);
}

wwilliams

Check the multi lookup enabled box, save and generate the request page. This works for me everytime. Maximo 7.5, worked the same in version 6.

-W