Adding Custom Summary / Aggregate Function to AdHoc

[stegmann]

Hello,

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 http://community.jaspersoft.com/wiki/adding-standard-deviation-ad-hoc , but this example does not work in 5.6 version)

Thanks a lot for your help,

Philipp

 

 

[marianol]

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?

 

 

[stegmann]

Thanks.

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]

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

solve. Thanks a lot!

[Scott Andersen]

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

http://community.jaspersoft.com/wiki/how-add-custom-function-ad-hoc-view-calculated-measurefield-functions-list