In Ad hoc editor can you create a filter for a summary field

[awoliver777]

I have created an ad hoc report which groups a list of expense by recipient name and then summarizes the amount field. I would like to add a filter to the report that shows only recipients with amounts greater than $1000. How do you does this in the ad hoc editor?

[NandiniBC]

goto repository

Edit Ad-hoc report (not "OPEN")

goto controls tab and add input control.

regards,

Sonata software

 

[mdahlman]

No, it cannot be done today. You could create a filter to leave out all individual expenses less than some value. But you cannot filter on the aggregated totals.

You could achieve this by editing the report in iReport. The limitation isn't on domains; the limitation is on the Ad Hoc GUI.

Regards,
Matt

[awoliver777]

Thanks, I was afraid that might be the answer. I also opened this as a ticket in JasperSupport to see if they had any work arounds for this. I'll update this thread if they do.