lexx_pangcats

Actually I already used the three types of virtualizer still didn't help my problem. The "out of memory" error occured during export. My jasperprint object have 7,984 no. of pages. tnx.

Hi dwfletcher, Can you please share to me code snippets on how you handle large jasperprint object when generating huge report? tnx.

Hey Good day! Just want to followup to this forum, is this still alive? Or the question had been answered? If yes, I would like to know. Thanks.

Hi teodord, Just want to followup the question of ilira. In my case Im using JDBC2.0 driver and my database is SQL Server 2005. But I never used subreport it just a plain report using Chart. My report retrieved 100,000 or more records. I encountered this error when I run the report using iReport. Thanks.

hi guilo, thanks for the reply. your ideas are great.this solve my issue. but it looks messy if i've to create 60 parameters. Because in my case, there's a posibility that the number of characters inside the parameter could be in 240,000. and i think 4,000 characters only allowed to stored in every parameters. that would result to 60 parameters will be created.

what i mean is how to modify a parameter value before using it in the query. for example i have: $P{parameter1} = "1,2,3,...................100". and my i query: select * from table where col = ${parameter1} But before I execute the query i want to change the value of the parameter. Just like for example, when the number of characters of the parameter $P{parameter1} is greater than 8000 then im going to cut down the value of the parameter to not greater than 8000.

Hi all, I have a few question on how to customize Stacked bar char y-axis label. For example I would like to set the y-axis label of the chart from 0 to 24 only, coz the maximum value of the data is 24. My first attemp was to used the customizer class and its solved my problem but the processing was took too long especially if I have a large amount of data to retrieve. So may I know what the other solutions aside of using a customizer class? Or can you give an idea on how to used 100 % Stacked bar chart? Maybe it will help to solve this issue. Tnx.

Hi all, Does anyone know how to modify parameter value before using it to select query? Because I just want to filter any values from parameter. I know we can do it in the server side(java code) but the limitations are I'm not allowed to modify any codes. So all I have to do is to depend what values are send through the parameter. Hope you understand my issue. Tnx.