More than 200 000 transactions

[fanie.dry]

Hi Guys,

 

I have a DW with more than 200 000 records in them. Each record being a financial transaction on different merchants. The objective is to create a summary report for a specific merchant. The merchant being our biggest and having more than 200,000 transactions.

 

I've created a Domain from the Data Source for just the specific merchant, to see if I can get the domain as small as possible to work from, but alas the transaction count is still over 200,000. So from the domain I have attempted to create an ad hoc view, which I can create just fine, but can't export it as PDF or use it to create a report, even though the data it returns from the domain is just a summary, group by month, counting the number of transactions per month. So the resultset really is only 1 line per month, which from this data source is only 3 months worth of data. Still it complains about the 200,000 limit.

 

Anyway to get around that?

 

Thanks in advance,

Fanie.

[hozawa]

Login as superuser.

In JasperReports Server menu, select  "Manager" - "Server Settings".

Select "Adhoc settings".

Increase "Ad Hoc Dataset Row Limit" value.

 

[fanie.dry]

Thanks. Also, realized that if I want to make the change permanent I have to make a change in the applicationContext-semanticLayer file.

 

TThanks.