Calling a crystal report from swing form
Hello,
I am calling a report (created in crystal reports) from swings GUI, report is called successfully without errors but information displayed in reports is missing while those values are displayed in views when i see from data base ( mysql):Kindly help me in this regard , following is the code:
public static void showViewer ()
{
CallReport viewerFrame = showViewerFrame ();
boolean success=false;
try {
success = viewerFrame.showReport();
} catch (SQLException ex) {
//Logger.getLogger(TestReport.class.getName()).log(L evel.SEVERE, null, ex);
}
if (!success) {
viewerFrame.closeViewer ();
}
}
static CallReport showViewerFrame ()
{
CallReport viewerFrame = new CallReport();
viewerFrame.setVisible (true);
// Start the viewer
viewerFrame.reportViewer.start ();
return viewerFrame;
}
private boolean showReport () throws SQLException
{
reportClientDocument = new ReportClientDocument ();
conn = new DBConnection();
stmt = new DBStatement();
try {
resultSet = (stmt.getStatement(conn.getConnection())).executeQ uery(QUERY);
} catch (SQLException ex) {
Logger.getLogger(CallReport.class.getName()).log(L evel.SEVERE, null, ex);
}
try {
reportClientDocument.setReportAppServer(ReportClie ntDocument.inprocConnectionString);
reportClientDocument.open(REPORT_PATH, OpenReportOptions._openAsReadOnly);
} catch (ReportSDKException e) {
}
String tableAlias = reportClientDocument.getDatabaseController().getDa tabase().getTables().getTable(0).getName(); reportClientDocument.getDatabaseController().setDa taSource(resultSet, tableAlias, "tableAlias");
if (reportClientDocument != null) {
setReportSource ();
return true;
}
}
catch (ReportSDKException e)
{
String localizedMessage = e.getLocalizedMessage ();
int errorCode = e.errorCode ();
String message = localizedMessage + "\nError code: " + errorCode;
JOptionPane.showMessageDialog (CallReport.this, message, title, JOptionPane.WARNING_MESSAGE);
}
}
