:: Forum >> Version 1 >>

how can i connect Crystal Reports From JSP Or Java

Hello All,
Can Anyone Please tell me about the connection process of the Crystal Reports from JSP Or Java.
Thanks in Advance.
Vijay Addhankki
Wednesday, August 31, 2005
Also one more thing,I am using Tomcat 4.1 as my webserver and SQL Server 2000 as my database,Please tell me how to connect crystal reports from JSP or JAVA
Vijay Addhankki
Wednesday, August 31, 2005
PLease Answer this query ASAP because this is urgent
Vijay Addhankki
Wednesday, August 31, 2005
Hyperlink Option :

Before working on the Integration of Crystal reports with JSP, be sure that you have set up the server correctly :

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

What do we want to achieve ?

Open a Sample.rpt report using JSP.
Passing parameters into report using JSP

In most of the cases ,we will see that the JSP Page lies on some other server ;whereas the reports that have to be fetched are available on the different server. Then,how will our Server recognize that a call made for the report lies on the different server? It can be noticed that the servers will be addressed by different port numbers.So,for example our JSP page is called using Port:80 ;then our reports can be invoked using Port :8080.This point can be clearly seen in our example as we have referred to : http://servername:8080/report.rpt




OPEN SAMPLE.RPT REPORT USING JSP : Here, is a Sample Code(Sample.jsp). Here,we are trying to call a report report.rpt from within a JSP page. You can have some piece of code prior or after the <A>..</A> tag.You will also notice the use of init=java .It indicated that we are trying to call the report on the browser using the Java Viewer.

<HTML>
<HEAD>
<TITLE> CALLING REPORT WITHIN A JSP PAGE WITH SAVED DATA </TITLE>
</HEAD>
<BODY>
<A HREF = "http://servername:8080/report.rpt?init=java">Report</A>
</BODY>
</HTML>
}



PASSING PARAMETERS INTO REPORT USING JSP : Here, is a Sample Code(Sample.jsp). Here,we are trying to call a report report.rpt from within a JSP page. You can have some piece of code prior or after the <A>..</A> tag.The two parameter values ,namely,FirstParameterValue and the SecondParameterValue are the name of the fields in an HTML form .

<HTML>
<HEAD>
<TITLE> CALLING REPORT WITHIN A JSP PAGE WHERE USERS PASS PARAMETERS TO THE REPORT </TITLE>
</HEAD>
<BODY>
<A HREF ="http://servername:8080/report.rpt?init=java&prompt0=<% request.getParameter
("FirstParameterValue")%>&prompt1=<%=request.getParameter("SecondParameterValue")%>">
Report</A>
</BODY>
</HTML>


Dinesh Kumar
Thursday, November 16, 2006
Hi Dinesh,

I was wondering if you had any idea how to make a report show up in the browser itself using JSP. Feel free to answer here so others may benefit, or you can contact me at (321)948-3227 or mcupples@cloudspace.com. I also use MSN at cupplesm@hotmail.com and AIM at mcupples1.

Thanks,
Matt
Matthew Cupples
Friday, December 15, 2006
how should i connect sqlserver 2000 database using jsp ,i know to connect oracle using jsp .please helpme its very urgent


thanks inadvance......
Naveen
Monday, February 5, 2007
active widgets subject?!
Pc (from Brazil)
Wednesday, February 7, 2007
I wants to create crystal report by using jsp . pls suggest me.
manas
Saturday, June 9, 2007
Please talk active widgets subject here.
Tiger
Tuesday, July 3, 2007
I want to print only two digits after the decimal point in jsp but i am using the double.Please give soluion for my query to kasim.ayoob@gmail.com. Thanks
Mohamed Ayoob
Tuesday, August 7, 2007



This topic is archived.

Back to support forum

Forum search