Regarding excel sheet datasource of subreport

0

Hi,

I am new to iReports and currently i am using iReport 4.0.2.Please someone help me in my query

I have a main report which has a subreport in it.The subreport retreives data from excel sheet.I followed following steps to retreive data

1..In subreport properties i chose connection type as datasource expression.

2.In datasource expressioni wrote new net.sf.jasperreports.engine.data.JRXlsDataSource(new File("path of xls file"))

When i compile subreport individually it gives report correctly but when i try to retreive data through main report it gives me following error

Error filling print...net.sf.jasperreports.engine.JRException:Unknown Column name:XYZ

 

Thanks and Regards

 

rashmi_prabhu's picture
Joined: May 29 2011 - 11:18pm
Last seen: 3 years 5 months ago

2 Answers:

0
Subreport accepts excel column names as Column0, Column1,Column2 only when you are using excel datasource. You cannot give any other column name like XYZ etc.,
madhukiran's picture
Joined: May 20 2009 - 1:53am
Last seen: 2 weeks 4 days ago
0
madhukiran's picture
Joined: May 20 2009 - 1:53am
Last seen: 2 weeks 4 days ago
Feedback
randomness