Adding Custom Summary / Aggregate Function to AdHoc



I am using Jasperserver 5.6 on AWS.

Is there a way to add a custom sql function as an aggregation / summary function to the context menu of a measure in the adhoc. Without using calculated fields/measures in adhoc?

(like this , but this example does not work in 5.6 version)

Thanks a lot for your help,




stegmann's picture
Joined: Jul 18 2013 - 6:50am
Last seen: 3 years 8 months ago

Mmmm looks like with the addition of calculated measures this has moved to other class, so those instruccions may not be valid for the latest releases.

Let me look into it. What fuction are you looking to add?



marianol - 4 years 10 months ago


Ideally I would like to add my own custom SQL Function. Something like "Max(values) / Min(values)" or First(values).

I am using SQl Server and would create a custom SQL Function.


stegmann - 4 years 10 months ago

any idea on this? would be really great and helpful to

solve. Thanks a lot!

stegmann - 4 years 9 months ago

1 Answer:


Here is a link to a wiki article that covers the addition of functions to adhoc..


sandersen's picture
Joined: Feb 19 2014 - 10:16am
Last seen: 10 months 2 weeks ago