Hello!
I have a problem with reporting parameters using Birt. I want to create a parameter with a lookupname and an attributename.
I have to type the parameter location, but I want to use the lookup "locations"
I use this way to create the where param clause
if (params["location"].value){
where = where + " AND " + MXReportSqlFormat.createParamWhereClause("UPPER(location)", reportContext.getParameterValue("location").toUpperCase());
}
And, I used the lookup locations and the attribute name location. Then, when I select the parameter to preview the report, it returns nothing! I tried to create the where param clause in many ways, but I think it's just a little detail to make it work.
Can someone help me please?
My best regards!
Calil.
