How to call Crystal reports using JSP

[crystalbeginner15]

I am using cr11. Appreciate your help.

Thank you.

 

[synapsevampire]

Check out:

http://support.businessobjects.com/communityCS/FilesAndUpdates/crxi_jrc_jsp_samples.zip.asp

-k

 

[crystalbeginner15]

Where do I get the crystaldecision classes from?
Please help.

 

[IdoMillet]

The runtime components come with the Developer version of Crystal.

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[crystalbeginner15]

I didn't understand what you said.

 

[dsWA]

Hi,

The CR Java classes are preovided with the Developer Edition of Crystal Reports. You will not have the Java classes if you purchased the Professional Edition.

Once installed, they will be placed in the "Program Files\Common Files\Business Objects\3.0\java\lib".



Derek Stobbart
Business Objects Consultant - Perth, Western Australia

 

[crystalbeginner15]

I have 15 report to be access by the user on the web so
I have to write 15 jsp to display on web or is there any other approach to do.

Thank you.

 

[dsWA]

I would write the JSP to accept the report name through a query string variable. Then create a second JSP that lists the report names. When a user clicks on the report name you call your original JSP passing the relevant report name.

Your report name listing JSP might pull report names from file names in a specific directory, or from entries in a database...

If you have the budget, you might want to look at Crystal Reports Server XI, as this automates all of this for you already - no programming necessary.



Derek Stobbart
Business Objects Consultant - Perth, Western Australia

 

[crystalbeginner15]

I have followed all the steps to call CR from JSP but when I run the report I get the error "Unsupported JNDI object"

Please help.

Thank you

 

[mckang]

This snippet is from the package crxi_jrc_jsp_samples.zip in the file jrc_set_subreport_parameters\Readme.txt:

3. To configure a JNDI connection to the sample report (which uses an ODBC connection to the Xtreme Sample Database), add following entry to your web.xml file:

<env-entry>
<env-entry-name>jdbc/Xtreme Sample Database 11</env-entry-name>
<env-entry-value>!sun.jdbc.odbc.JdbcOdbcDriver!jdbcdbc:Xtreme Sample Database 11</env-entry-value>
<env-entry-type>java.lang.String</env-entry-type>
</env-entry>

This very important detail is buried in a very unlikely place, so it's no wonder ppl are having trouble with this basic set up. Business Objects should display the above prominently.

I'm using Netbeans 4.1 w/ Tomcat 5 on WinXP. I tested it out to connect to a local MS Access file and to a remote Oracle server (making the appropriate changes to the above). As far as I am able to see, the above web.xml entry isthe ONLY thing you need to communicate with your database source. Namely, changes to CRConfig.xml, setting database sources in your Tomcat/admin, or "Control Panel->Administrative Tools->Database Sources" don't do a thing.