Title:
Bug 73474:(Watson Migration Closure)could generate reports based on layouts of iReport
| View in TrackerStatus/Resolution/Reason: Closed/Deferred/
Reporter/Name(from Bugbase): Pedro Silva / Pedro Claudio (Pedro Claudio)
Created: 11/03/2008
Components: Reporting, CFReport
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Normal / Unknown
Locale/System: English / Platforms All
Vote Count: 2
Problem:
could generate reports based on layouts of iReport.
<cfreport type="jasperreport" datasource="dsn" username="x" password="x" src="file.jrxml">
<Cfreportparam....>
</cfreport>
Method:
<cfscript>
DriverManager = Server.getClass().forName("coldfusion.sql.JdbcImpl").newInstance();
DriverManager.setDriver("com.mysql.jdbc.Driver");
DriverManager.setUrl("jdbc:mysql://localhost:3306/pcsilva");
DriverManager.setPassword("root");
DriverManager.setUsername("root");
Connection = DriverManager.getConnection();
Connection.setUseUnicode(true);
Connection.setCharacterEncoding("utf8");
parameters = {ReportTitle="pcsilva Teste"};
JasperManager = Server.getClass().forName("net.sf.jasperreports.engine.JasperManager").newInstance();
JasperDesign = JasperManager.loadXmlDesign("#ExpandPath('teste.jrxml')#");
JasperReport = JasperManager.compileReport(JasperDesign);
JasperPrint = JasperManager.fillReport(JasperReport,parameters,Connection);
JasperManager.printReportToPdfFile(JasperPrint,"#ExpandPath('.')#\teste.pdf");
</cfscript>
Result:
nothing
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3036574
External Customer Info:
External Company:
External Customer Name: Pedro Claudio
External Customer Email: 52BF13DC4456EC7B992016B6
External Test Config: 11/03/2008Attachments:
Comments: