Dataset filter that supports no values

akk2

Is there anyway to have a report filter which supports no values? My issue is that I have to send many values to a report from a java application, or, I'd like to be able to pass no values and do it for the entire data. Any way to do this?

In other words, in the filters section of the dataset, I can create a filter with the 'in' and the parameter, but is there any way for me to say: "[param] is null or myField in [param]"?

I'm trying to put as expression "params["id"].value == null || row["sid"]" (or variations of) with operator 'in' and my param, but with the eclipse report preview that doesn't seem to work, I either always get all values or no values...

Thanks!

mwilliams

You can write an expression for each side of the expression, so you could do something like:

if (params["id"].value == null){
null;
}
else{
row["sid"];
}

IN

if (params["id"].value == null){
"{null}";
}
else{
params["id"].value;
}

Not certain on the syntax of (null); in the second expression since I didn't try it. Let me know if this doesn't work.