dima_1 Posted March 25, 2014 Share Posted March 25, 2014 Hi i installed jaspersoft server jasperreports-server-5.5-windows-x64-installer.exefor 30 evaluation connected it to aws redshift.And have problems with distinct counts. I saw in the forum that i need to cahnge jasperserver-proWEB-INFapplicationContext-adhoc-dataStrategy.xmlhttp://community.jaspersoft.com/wiki/unexpected-results-andor-performance-issues-group-summaries-ad-hoc-v50-and-later but when i opened it there is already<bean class="com.jaspersoft.ji.adhoc.strategy.AggregateConfig"> <property name="name" value="DistinctCount"/> <property name="functionName" value="distinctCount"/> <!-- distinct count not currently mapped directly to sql func --> <property name="calcMethod" value="sqlUnionAll"/> And still the distinct calculation works in memory of jaspersoft after long data loadwhat to do? Link to comment Share on other sites More sharing options...
VanyaC Posted April 24, 2014 Share Posted April 24, 2014 You can try the following:<bean class="com.jaspersoft.ji.adhoc.strategy.AggregateConfig"> <property name="name" value="DistinctCount"/> <property name="functionName" value="distinctCount"/> <!-- distinct count not currently mapped directly to sql func --> <property name="calcMethod" value="sqlGroupBy"/> 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