JasperReport Parameter

[iamthegopala]

hi..i am using jasperReport in my java application.. i want to pass parameters from my code, the entire where condition from code.

now i am using $P!{whereCondition}.

in my java code,

parameterMap.put("whereCondition", "category_id=3 AND subcategory_id=1  ");

but this is not working,it is showing a blank report.is there any problem in my code?please help me,,

[mgeise]

You may want to try $P!{whereCondition} instead of $P!{wherecondition} as it is case sensitive.

[iamthegopala]

thanks. actually that was a mistake in my question.i have edited it..please help me to solve this issue

[mgeise]

The answer is now marked as the best answer, implying that this was the solution. Did you find the problem? What this it? or do you still need help? If you still need help, I would need to see the actual query from the report as well as any logging you may have that shows the generated query or any errors that are thrown.

[iamthegopala]

yes i found the solution..the problem was with the column name..