Hi i installed jaspersoft server jasperreports-server-5.5-windows-x64-installer.exe for 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.xml http://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 load what to do?