I'm try to create a jasper report in JasperAssistant for the Eclipse Platform. I know it's possible to set up parameters for each where conditional. However, is there a way that I can set up a parameter as the where conditional. This way I can avoid having static where clause. It will also make it easier for me to construct my own sql queries without having to use a new report.

For example, is it possible for me to do this?
Select name, location from people where $P{pSearchRange}
pSearchRange = " city = 'boston' AND gender = 'male' "

I've been trying to do this, however it doesn't like it when I don't hardcode the column name in the WHERE section.

Can anybody please give me some ideas on how to do this.