Large Reports + Schedule to File System

[bhushan_makade]

Hi All,

We are using  jasper server 3.5 for generating and scheduling the reports from our application.

But we have requirement of scheduling large reports like having row count of 1 million records.

When we tried to generate or run such a report from jasper server ,

• It takes lot of time and then just gives outofmemory error. We need to increase the JVM memory size.
• Apart from this, we came to know about SwapFileVirtualizerFactory in the similar thread.

<bean id="fileVirtualizerFactory" class="com.jaspersoft.jasperserver.api.engine.common.service.impl.SwapFileVirtualizerFactory">

        <property name="maxSize" value="400"></property>

        <property name="directory" value="${java.io.tmpdir}"></property>

    </bean>

but there is some more configuartion given in that thread which we are not able to find in the jasperserver files

Following is what we are searching for:

jasperreports.properties

Use these settings...

 

net.sf.jasperreports.governor.max.pages.enabled=true

net.sf.jasperreports.governor.timeout.enabled=true

net.sf.jasperreports.jdbc.concurrency=readOnly

net.sf.jasperreports.jdbc.fetch.size=-2147483648

net.sf.jasperreports.jdbc.holdability=close

net.sf.jasperreports.jdbc.result.set.type=forwardOnly

Please let us know if such a configuration is possible in jasperserver 3.5.

 Apart from this, once the report is scheduled, we can just receive it in emails.But emails have size limits so we can not send large reports through emails. So we need to make changes in jasper server such that the generated report can be stored in File System instead of  email or db repository.

    We could find lot of related threads but no concrete solution for this.

So, please reply if you have done something similar to this and any help in this regard will be appreciated.

Thanks in advance.