<p>This Sample will also work with JRC XI R1. </p><p>This sample demonstrates how to change the database that a report uses at runtime in the JRC.<br />NOTES: To help determine what connection properties need to be changed at runtime through code, create<br />a copy of your original report and use the Crystal Reports designer to change this report to new datasource<br />manually. Then use the jrc_display_connection_info helper sample to compare the connection information <br />between the original report and the copy of that report pointing at the new datasource. <br />The connection information properties from the output generated by the jrc_display_connection_info <br />sample that are different in the report pointing at the new datasource from the original can <br />then be set through code to help ensure that the database connection properties are changed correctly. <br /><br />________________________________________________________________ <br /><br />FILES<br /> <br />jrc_change_database_connection.jsp <br />jrc_change_database_connection.rpt<br />CrystalReportViewer.jsp<br /><br />________________________________________________________________ <br /><br />INSTALLATION<br /><br />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:<br /><br />http://support.businessobjects.com/communityCS/TechnicalPapers/cr_xi_r2_jrc_deployment.pdf.asp<br /><br />2. Extract the contents of this folder into your web application's context root.<br /><br />3. In a browser window, launch the file jrc_change_database_connection.jsp as follows: <br /><br />http://<computer name>:<port number>/<web app>/jrc_change_database_connection.jsp <br /></p>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.