stegmann Posted February 7, 2015 Share Posted February 7, 2015 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 Link to comment Share on other sites More sharing options...
marianol Posted February 9, 2015 Share Posted February 9, 2015 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? Link to comment Share on other sites More sharing options...
stegmann Posted February 10, 2015 Author Share Posted February 10, 2015 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. Link to comment Share on other sites More sharing options...
stegmann Posted February 28, 2015 Author Share Posted February 28, 2015 any idea on this? would be really great and helpful tosolve. Thanks a lot! Link to comment Share on other sites More sharing options...
Scott Andersen Posted May 31, 2017 Share Posted May 31, 2017 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now