Generate a report with 2 sections

[edwarda]

Hi,

I'm generating a report including 2 sections, data in each from different table. So, I create 2 subreports which select data from its own tables, and lay out 2 subreports in the detail band of main report, one after another. But, the result becomes mess-up. The 2-page report keeps repeating to 100 pages, and the 2 sections overlaps each other in each repeat.

Can anyone advise the proper way of doing this? Should I lay out 2 subreports to some other band? I'm using iReport 3.7.2

Thanks for help in advance!

E.D.

 

[slow]

try this:

in the main report use a dummy query similar to this ( I use Oracle!... find something similar for your DB):

select '1' as num drom dual
union
select '2' as num drom dual

on the "print when expression" of the first report set:

new Boolean($F{num}.trim().equals("1"))

on the "print when expression" of the second report set:

 

new Boolean($F{num}.trim().equals("2"))

then put the two subreport in the detail band one on each other.

 

 

_________________________________________

if it works... give me KARMA points please!    : ) 
_________________________________________

listening:  MUSICA NUDA - Sacrifice

 

[edwarda]

Thank you. I'm using Sybase, so, I tried dummy query as:

select '1' as num
union
select '2' as num

It's fine now in iReport. But  when I load all xml/jsper files from JasperEngine. The exception comes up as following. I tried to upgade to jasperreports-3.7.2.jar, but the compliation is failing. I guess I'm in  another trouble!

 

DEBUG [main] (JRVerticalFiller.java:298) Fill 33066941: title
DEBUG [main] (JRVerticalFiller.java:679) Fill 33066941: detail
DEBUG [main] (JRFillDataset.java:747) Fill 33066941: closing query executer
Failed to generate report
net.sf.jasperreports.engine.JRRuntimeException: Unknown hyperlink target 0
        at net.sf.jasperreports.engine.JRHyperlinkHelper.getLinkTarget(JRHyperlinkHelper.java:273)
        at net.sf.jasperreports.engine.base.JRBaseTextField.normalizeLinkTarget(JRBaseTextField.java:317)
        at net.sf.jasperreports.engine.base.JRBaseTextField.readObject(JRBaseTextField.java:381)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at java.io.ObjectStreamClass.invokeReadObject(Unknown Source)
        at java.io.ObjectInputStream.readSerialData(Unknown Source)
        at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
        at java.io.ObjectInputStream.readObject0(Unknown Source)
        at java.io.ObjectInputStream.readObject(Unknown Source)
        at java.util.ArrayList.readObject(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at java.io.ObjectStreamClass.invokeReadObject(Unknown Source)
        at java.io.ObjectInputStream.readSerialData(Unknown Source)
        at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
        at java.io.ObjectInputStream.readObject0(Unknown Source)
        at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
        at java.io.ObjectInputStream.readSerialData(Unknown Source)
        at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
        at java.io.ObjectInputStream.readObject0(Unknown Source)
        at java.io.ObjectInputStream.readArray(Unknown Source)
        at java.io.ObjectInputStream.readObject0(Unknown Source)
        at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
        at java.io.ObjectInputStream.readSerialData(Unknown Source)
        at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
        at java.io.ObjectInputStream.readObject0(Unknown Source)
        at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
        at java.io.ObjectInputStream.defaultReadObject(Unknown Source)
        at net.sf.jasperreports.engine.base.JRBaseReport.readObject(JRBaseReport.java:736)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at java.io.ObjectStreamClass.invokeReadObject(Unknown Source)
        at java.io.ObjectInputStream.readSerialData(Unknown Source)
        at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
        at java.io.ObjectInputStream.readObject0(Unknown Source)
        at java.io.ObjectInputStream.readObject(Unknown Source)
        at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:94)
        at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:264)
        at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:321)
        at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:270)
        at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:260)
        at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:486)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1427)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:729)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:256)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:114)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:911)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:814)
        at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
        at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:421)
        at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:251)
        at com.rbccm.firms.standalone.report.ReportGenerator.generateReport(ReportGenerator.java:104)
        at com.rbccm.firms.standalone.report.ReportGenerator.main(ReportGenerator.java:152)