RE: Reports generation issues

[dave ch，修改在11 年前。]

Hi all,

I am using LR 6.1. We are getting some problems on Reports generation.
Actually we have under taken 2 approaches but we haven't succeeded till yet.

First approach was: We have downloaded a war (aperte-reports-ui-1.2a) , installed and deployed that war. We got five portlet. By using i-report tool we have customised. But when we are trying to generate any report (suppose in xml or pdf) we are getting NULL instead of any value.

Second approach: We have downloaded a war(jasper server portlet) and did the same. Here we are getting only 1 portlet. But when we are trying to generate any report we are getting the same issue.

Anybody cud tell me which approach is better and any solution for this problem.

Any help will be highly appreciated.

Thanks in advance
Dave

[Priyanka Dhingra，修改在11 年前。]

Hi dave,

I have used ireport so i can tell about that only.....
if you are getting null values then there are some jars that are missing....

[Rashmi Agnihotri，修改在11 年前。]

Priyanka Dhingra:

Hi dave,

I have used ireport so i can tell about that only.....
if you are getting null values then there are some jars that are missing....

Thanks Priyanka..

Can u please tell me the jars needed????

Thanks,
RAshmi Agnihotri

[dave ch，修改在11 年前。]

Thanks Priyanka,

While i am trying to generate using aperte-reports-ui-1.2a approach, i am getting stuck since i am getting null as my result.
As u said : "if you are getting null values then there are some jars that are missing....". Could u please intimate me which jars am i missing.

Warm Regards,

Dave

[Priyanka Dhingra，修改在11 年前。]

Hi
please refer to this:-
http://jasperforge.org/uploads/publish/ireportwebsite/IR%20Website/ir_deploying_reports.html
the jar that is generally forgotten is "poi.jar". so, take care of adding that

[dave ch，修改在11 年前。]

Hi Priyanka,

Thanks for your quick response.

Priyanka Dhingra:

please refer to this:-
http://jasperforge.org/uploads/publish/ireportwebsite/IR%20Website/ir_deploying_reports.html
the jar that is generally forgotten is "poi.jar". so, take care of adding that

I have added all of the above jars still i am getting the same Null value as my result. Kindly tell me if i am missing any thing else. How had you achieved yours resulting reports?
Any help will be highly appreciated.

Warm regards
Dave

[Priyanka Dhingra，修改在11 年前。]

Hi,

I prepared xls report. so used

JRBeanCollectionDataSource reportList = new JRBeanCollectionDataSource(objectList);
JasperReport report = JasperCompileManager.compileReport(session.getPortletContext().getRealPath("/report/myreport.jrxml"));
				JasperPrint print = JasperFillManager.fillReport(report,new HashMap(), reportList);
OutputStream os = resourceResponse.getPortletOutputStream();
				JRXlsExporter exporterXLS = new JRXlsExporter();				

code and then
worked on ireport..configuring which all columns i need..

[Ken Stubbings，修改在11 年前。]

I know this is somewhat old now but I was trying to do the same thing as you yesterday and it looks to me like your problem is with the datasource setup rather than missing jars.

You need to check that you are referenceing a datasource in your jrxml file for the report that has been defined in your context.xml file in your tomcats conf directory.

eg:
jrxml contains -

	<parameter name="datasource" class="java.lang.String">
		<parameterdescription>java:comp/env/jdbc/mydatabase</parameterdescription>
	</parameter>

conf/contex.xml contains -

    <resource name="jdbc/mydatabase" auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="8" maxIdle="4" password="thepassword" type="javax.sql.DataSource" url="jdbc:mysql://127.0.0.1:3306/databasename" username="user" />