Skip to Content
author's profile photo Former Member
Former Member

JRC XI R2 Change Database Connection Sample

This Sample will also work with JRC XI R1.

This sample demonstrates how to change the database that a report uses at runtime in the JRC.
NOTES: To help determine what connection properties need to be changed at runtime through code, create
a copy of your original report and use the Crystal Reports designer to change this report to new datasource
manually. Then use the jrc_display_connection_info helper sample to compare the connection information
between the original report and the copy of that report pointing at the new datasource.
The connection information properties from the output generated by the jrc_display_connection_info
sample that are different in the report pointing at the new datasource from the original can
then be set through code to help ensure that the database connection properties are changed correctly.

________________________________________________________________

FILES

jrc_change_database_connection.jsp
jrc_change_database_connection.rpt
CrystalReportViewer.jsp

________________________________________________________________

INSTALLATION

1. Setup an application context on your application server to host a web application. For assistance with setting up and deploying a web application using the Java Reporting Component, refer to this whitepaper:

http://support.businessobjects.com/communityCS/TechnicalPapers/cr_xi_r2_jrc_deployment.pdf.asp
/>
2. Extract the contents of this folder into your web application's context root.

3. In a browser window, launch the file jrc_change_database_connection.jsp as follows:

http:// : / /jrc_change_database_connection.jsp

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 07:08 AM

    Is there supposed to be a zip file associated with this article? Perhaps this one? http://support.businessobjects.com/communityCS/FilesAndUpdates/crxi_r2_jrc_web_samples.zip.asp

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.