Concat report parameter value in filter

I am adding a filter on my report and need to concat the value of 2 report parameters. In the filtration when I build the expression as mentioned below I am getting the following error.
Table (id = 336):
+ The filter definition using expression "row["AGENCY_CLIENT_ID"]" is not valid.
An error happened in data type conversion.
Can not convert the value of NaN to BigDecimal type.

Expression in filter

if(params["ChooseHouseholdMember"].value != '0')
{
params["ChooseHouseholdMember"].value + params["ChoosePrimaryClient"].value
}
else
{
params["ChoosePrimaryClient"].value
}

I tried to use BirtStr.concat as well as Javascript functions but no luck.

Can anyone please help.

Find more posts tagged with

Comments

mwilliams

Hi Pujan,

Can you attach your report design? Maybe that will help. Also, can you expand that error message by clicking on the '+' next to it and post the entire stack in here? What version of BIRT are you using? Thanks.

Pujan

Hello Michael, 
 
Thanks for the response. 
 
I was able to concat the 2 report parameter's value using the following code 
primaryClients = params["ChoosePrimaryClient"].value; 
secondaryClients = params["ChooseHouseholdMember"].value; 
str = new Array(); 
str = str.concat(primaryClients, secondaryClients); 
str; 
 
However - this works when I have value for both parameters since I have used the "IN" operator. But if I have value for "ChoosePrimaryClient" parameter and the "ChooseHouseholdMember" value is "All" then I need to have the filter like 
 
row[Agency_Client_id] IN params["ChoosePrimaryClient"].value And row[Agency_client_id] LIKE '%' (here % refers to ChooseHouseholdMember param) 
 
In order to achieve this I tried to dynamically create the filter using the following code in before factory 
 
if(params["ChooseHouseholdMember"].value[0] == '0') 
{ 
importPackage(Packages.org.eclipse.birt.report.model.api); 
importPackage(Packages.org.eclipse.birt.report.model.api.elements); 
dshandle = reportContext.getReportRunnable().designHandle.getDesignHandle().findDataSet("AchievementTrackingDataSet"); 
filters = dshandle.filtersIterator(); 
while( filters.hasNext() ) 
{ 
filterHandle = filters.next(); 
if( filterHandle.getExpr().indexOf("AGENCY_CLIENT_ID") >= 0 ) 
{ 
origOperator = filterHandle.getOperator(); 
origValue1 = filterHandle.getValue1(); 
fc = StructureFactory.createFilterCond(); 
fc.setExpr("dataSetRow["AGENCY_CLIENT_ID"]"); 
fc.setOperator(origOperator); 
fc.setValue1(origValue1); 
fc.setOperator(DesignChoiceConstants.FILTER_OPERATOR_LIKE); 
params["ChooseHouseholdMember"].value = ' % '; 
fc.setValue2(params["ChooseHouseholdMember"].value); 
dshandle.removeFilter( filterHandle.getStructure() ); 
dshandle.addFilter(fc); 
} 
} 
} 
 
but I am getting error - 
 
Table (id = 336): 
- An exception occurred during processing. Please see the following message for details: 
Invalid Javascript expression: % . 
syntax error 
exception.error ( 1 time(s) ) 
detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:Invalid Javascript expression: % .syntax error

Pujan

Hello Michael,

Please find attached the rpt file.

Thanks
Pujan