have problems with distinct counts

[dima_1]

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?

[VanyaC]

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"/>