We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Embedding a Crystal report in a JSP page without RAS or ASP?

mahmoud_
mahmoud_ asked
on
Medium Priority
1,230 Views
Last Modified: 2007-12-19
Hello Guys,

I'm trying to embedd a Crystal Report within a JSP page; and there is very little out there which tells you how do this without using RAS (Report Application Server). Apparently there is a way to embedd reports into JSP pages using a link (http://www.utdallas.edu/~pxm034000/files/hyperlink.html) instead of the RAS method, although the documentation on this is next to non existant. To use the link mathid apparently I need:

 - A Web Server (Apache, IIS, etc.)
 - A JSP Server (Tomcat, Jrun, etc.)
 - Seagate Page Server
 - Seagate Web Component Server

And the actual link is:

<A HREF = "http://servername:8080/report.rpt?init=java">Report</A>

My questions are:

1. Is apache tomcat a web and a JSP server? Or do I need to install a seperate Web Server other than tomcat?
2. What is a "Seagate Page Server"?
3. What is a "Seagate Web Component Server"?
4. Has anyone actually got this to work?
5. What are the main pro\cons of this method as opposed to using RAS?

I use Apache Tomcat 4.1.2, j2sdk1.4.1, winXP, crystal reports version 9

Thanks.
Comment
Watch Question

Mick BarryJava Developer
CERTIFIED EXPERT
Top Expert 2010

Commented:
> 1. Is apache tomcat a web and a JSP server?

both

> 2. What is a "Seagate Page Server"?
> 3. What is a "Seagate Web Component Server"?

http://www.dnjonline.com/articles/tools/iss15_tools2.html

Commented:
I believe that Cristal reports has some .jar files to do what you want without any Seagate thing. have you seen the Doc on CrystalReports page?

http://www.businessobjects.com/products/dev_zone/java/default.asp?ref=devzone_main

Javier

Author

Commented:
Will these jar files totally replace the need to install Crystal reports on the server?

Also I cant find any documentation on how to use these jar files ... do you have any tips on how to use these jar files?

Author

Commented:
I put all the jar files in the WEB-INF\lib folder and I downloaded the "begin_here.zip" sample application. I also put the jar files in the D:\Program Files\Common Files\Crystal Decisions\2.0\jars folder and added that folder to the system path - but everytime I try to run the sample application I get a string of errors (16 of them) about all these missing com.crystaldecisions objects. Do you know what Im doing wrong?

Commented:
To tell you the truth, Nope but seems like that you don't have all the jars.
can you unjar the files and look if that pack is inthere?
Javier
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
I am using tomcat but I managed to the get passed the first problem, I can now use all the com.crystal objects - looks like jarasa was right, I didnt have all the jar files.

The problem now is that in the AlwaysRequiredSteps.jsp file there is a section where you have to specify the ip address of the server that RAS is running on, eg:

// Set the RAS Server to be used for the service
ra.setReportAppServer("127.0.0.1");

I tried to put the up ip address of the server Im working off, but it still complains with the below error:

org.apache.jasper.JasperException: Unable to connect to the server: 192.168.2.43.

I know ASP can do it, so there must be some way of getting it to work with JSP without the RAS server .... maybe I have to manually convert all the ASP code to JSP and do com calls from java to some dll file ??
Mick BarryJava Developer
CERTIFIED EXPERT
Top Expert 2010

Commented:
> I know ASP can do it

How does the ASP achieve it?

Commented:
Well, but as Kenneth sais you must have the Report Application Server Installed somewhere.

Javier

Author

Commented:
Some how ASP can do things like:

Set session("oApp") = Server.CreateObject("CrystalRuntime.Application.9")

It knows were to find "CrystalRuntime.Application.9" & it can call the Server.CreateObject object\method without having to specify anything. There must be some registry key or something somewhere that ASP knows about thats tells it where some dll that contains this stuff ....

I just have the standard Crystal report designer installed and I downloaded some asp samples from:

http://support.businessobjects.com/communityCS/FilesAndUpdates/aspxmps9.exe.asp

I stuck the first example ("begin_here.zip") in the wwwroot folder and it just worked, first time without any configuration, jar files or RAS. The crsystal report (with a sub report) displayed the first time I tried to run it - why cant JSP do that :(


Oh well, if no one knows how this is done, I will just split the point to all to have answered and walk away with my tale between my legs :( It must be some Microsoft\Crystal conspricy to marginalise Java ...
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Mick BarryJava Developer
CERTIFIED EXPERT
Top Expert 2010
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.