• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 557
  • Last Modified:

Real Time Reporting With Crystal Reports Viewer for Eclipse

Does anybody know if it is possible to use Crystal Reports Viewer for Eclipse as part of a real time reporting java app (i.e. live querying or cached refrehsed querying of database ) and what would be the practacalities of offering this app to 20+ users?

The standalone windows application viewer for Crystal Reports does not offer this functionality without the crystal reporting server supporting it that I am aware.
0
RBCHARNLEY
Asked:
RBCHARNLEY
  • 6
  • 4
1 Solution
 
mlmccCommented:
What version of Crystal?

You should be able to build a Java application and use the viewer.  It should be possible to have as many users as you desire for the application.

mlmcc
0
 
RBCHARNLEYAuthor Commented:
Visual advantage 2008.

It wasn't clear in your answer whether the datasource for the java app that has the crystal viewer for eclipse embedded could refresh from a live data source via OBDC connect etc. Would you use ODBC to link the two?
0
 
mlmccCommented:
I don't use Eclipse, so I don't know about that one.  It should be similar to the Crystal viewers and can be added to the application.

As far as I know it can be refreshed.  The Crystal viewer that come with Crystal can be refreshed from the application.

mlmcc
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
RBCHARNLEYAuthor Commented:
The Crystal viewer that come with Crystal can be refreshed from the application.

Dosen't this require crystal enterprise server? Or do you mean the reporting application?
0
 
mlmccCommented:
No it doesn't require Crystal Enterprise.  

As I stated I have never used Crystal for Eclipse so I don't know about that version or its viewer.  The viewer that comes with the full versiion of Crystal or the VS.Net versiion can be refreshed from the viewer or through the application that runs the viewer.

mlmcc
0
 
RBCHARNLEYAuthor Commented:
Just a simple scenarion to make sure I understand what you are saying! Sorry to be so slow but this is contary to what I was told elsewhere hence why I was looking at the embedded viewer option.

You have a spreadsheet running on a network drive that is the datasource for an *.rpt crystal report file.

A user is viewing that report. Somebody updates and saves the spreadsheet. The user closes the viewer and re-opens it. The report reflects the new data?
0
 
mlmccCommented:
It should.

mlmcc
0
 
RBCHARNLEYAuthor Commented:
"A user is viewing that report. Somebody updates and saves the spreadsheet. The user closes the viewer and re-opens it. The report reflects the new data?"

I am going to do some tests to see if this is the case and report back.
0
 
RBCHARNLEYAuthor Commented:
Hi,

I have done a little investigation and setup a sample report in Crystal Reports 2008.

Within the designer product "Crystal Reports 2008" the data source does refresh live in preview mode.

However, using the Crystal Reports 2008 viewer the data source does not refresh live to the reports data source.

I have yet to see if a live link works in when Crystal Viewer in embedded as part of Eclipse. I will report back.
0
 
RBCHARNLEYAuthor Commented:
I have finally found a proof of concept on real-time binding datasources to the viewer in .net and also translated this to the eclipse plugin.

http://69.10.233.10/KB/aspnet/CrystalReport_DotNET2005.aspx

I accept the comment that .net can be used to make a crystal report in real time and the eclipse plugin. However this cannot be done with the desktop viewer without crystal reports server.

Also to note on the SAP website the company state:

"Both the .Net and Java runtime engine are intended for use in applications with low scalability requirements. We reserve the right to deny technical support when these runtime engines are used in scenarios with demanding scalability requirements. Learn more in the Crystal Reports 2008 Component Engine Scalability white paper in the SAP Developer Network (Log-in required). "

http://store.businessobjects.com/store/bobjamer/DisplayProductDetailsPage/productID.110949700



0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now