Results 1 to 3 of 3
- 05-13-2010, 02:38 PM #1
Member
- Join Date
- May 2010
- Posts
- 2
- Rep Power
- 0
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);
}
}
- 05-13-2010, 03:10 PM #2
Senior Member
- Join Date
- Mar 2010
- Location
- Manila, Philippines
- Posts
- 257
- Rep Power
- 4
I'm afraid we can't help you with just placing your code.
Besides, we don't know the logic you want the program to achieve.
You may post our SSCCE for us to understand better your concern.Every project, package, class, method, variable, syntax, algorithm, etc.
are registered in my memory bank. Thanks to this thread.
- 05-14-2010, 05:59 AM #3
Member
- Join Date
- May 2010
- Posts
- 2
- Rep Power
- 0
Similar Threads
-
unable to import jar files (crystal report 11)
By kishore101 in forum JavaServer Pages (JSP) and JSTLReplies: 0Last Post: 02-25-2009, 07:51 AM -
tips on crystal report
By kishore in forum New To JavaReplies: 1Last Post: 01-20-2009, 03:23 AM -
Crystal Report in Netbeans
By endx in forum NetBeansReplies: 3Last Post: 12-30-2008, 02:05 PM -
Crystal report with JSP
By fred in forum JavaServer Pages (JSP) and JSTLReplies: 3Last Post: 12-17-2008, 08:27 PM -
Crystal Report with Java
By Jack in forum Advanced JavaReplies: 2Last Post: 07-02-2007, 01:39 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks