have problems with distinct counts

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-pro\WEB-INF\applicationContext-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?

dima_1's picture
2
Joined: Mar 25 2014 - 8:39am
Last seen: 8 years 6 months ago

1 Answer:

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

VanyaC's picture
84
Joined: May 17 2011 - 3:56pm
Last seen: 8 years 5 months ago
Feedback