marcoDev

Hi, In my report when I set 'ignore pagination = true' my report display blank page. When I change this flag 'ignore pagination = false' they are filling report. In my report query if add a limit row then report is filled (whith ignore pagination = true). I cannot to add a pagination because when I export report in Excel, I don't want a pagination. filling report ----> PDF export (ignore pagination) ----> EXCEL export (ignore pagination) Report contains 8000 rows, may be too many in one page (Acrobat reader)!!! Help me please.

I solved my problem at using views in my database, it' s easier than add mutiple sub-report. The filling report is 10s + 10s for my sql report query Think.

hi, I did not use Java or Groovy scriplet. I have already think about temporary table, but I don't know if it's possible with jasper. -- 1.6s by element (sub-report) repeated 8 times by row for 8000 rows --> 1.6*8000 (extrapolation) thanks. Post edited by: marcoDev, at: 2007/02/19 11:51

hi, I'm a newbee with jasper report and ireport. I have a problem when i run a subreport inside master report. Each subreport take too many time, may be 200ms. For exemple : I have a master report with 8 subreport (one subreport = one sql query) and one subreport = 200ms All subreports inside a band detail, runtime 200*8=1600ms, it' enormous! I need help for optimization (SQL ok) Thinks.

hi, I'm a newbee with jasper report and ireport. I have a problem when i run a subreport inside master report. Each subreport take too many time, may be 200ms. For exemple : I have a master report with 8 subreport (one subreport = one sql query) and one subreport = 200ms All subreports inside a band detail, runtime 200*8=1600ms, it' enormous! I need help for optimization (SQL ok) Thinks.