<p><COPIED FROM BETA FORUMS> </p><p>Hi all,<br />I have recently entered into crystal reports integration with JSP. I have designed a report by selecting ODBC(RDO) and what ever the data source I have in my system. <br />Now I need to pass data base info dynamically to that report from JSP. Here one important thing is I desinged the report and it's sub reports by connecting to only one data source. In this scenario I am able to pass all below conncetion information dynamically and able to view report.<br /><br />Connection URL: jdbc:oracle:thin:@SERVERNAME:1521:SID<br />Class name : oracle.jdbc.driver.OracleDriver<br />Username; user<br />Password: pwd<br /><br />Code for passing connection info to main report<br />--
<br /> Tables mainTableCollection = (Tables)rptDoc.getDatabaseController().getDatabase().getTables();<br /> ITable originalTableMain = null;<br /> ITable newTableMain = null;<br /> for(int j = 0;j < mainTableCollection.size();j+
)<br /> {<br /> originalTableMain = mainTableCollection.getTable(j);<br /> PropertyBag pBag = originalTableMain.getConnectionInfo().getAttributes();<br /> System.out.println("QE_ServerDescription (dsn) is : "pBag.get("QE_ServerDescription"));<br /> newTableMain = mainTableCollection.getTable(j);<br /> ConnectionInfo ci = (ConnectionInfo)newTableMain.getConnectionInfo();<br /><br /> PropertyBag logonProps = new PropertyBag();<br /> logonProps.put("Database Class Name","oracle.jdbc.driver.OracleDriver");<br /> logonProps.put("Connection URL","jdbc:oracle:thin:@SERVERNAME:1521:SID");<br /> PropertyBag pb = new PropertyBag();<br /> pb.put(PropertyBagHelper.CONNINFO_CRQE_LOGONPROPERTIES ,logonProps);<br /> pb.put(PropertyBagHelper.CONNINFO_DATABASE_DLL ,"crdb_jdbc.dll");<br /> ci.setAttributes(pb); <br /><br /> ci.setUserName("myuser");<br /> ci.setPassword("mypwd");<br /> newTableMain.setConnectionInfo(ci);<br /> rptDoc.getDatabaseController().setTableLocation(originalTableMain, newTableMain);<br /> System.out.println(" User Name : "
originalTableMain.getConnectionInfo().getUserName());<br /> System.out.println(" Password : "originalTableMain.getConnectionInfo().getPassword());<br /> }<br /> <br />For sub reports:<br />
<br />IStrings subreportNames = rptDoc.getSubreportController().getSubreportNames();<br /> if(subreportNames.size() != 0)<br /> {<br /> for (int i = 0; i < subreportNames.size(); i++ )<br /> {<br /> <br /> ISubreportClientDocument subreportClientDoc = rptDoc.getSubreportController().getSubreport(subreportNames.getString(i));<br /> Tables oTablesCollection = (Tables)subreportClientDoc.getDatabaseController().getDatabase().getTables();<br /> ITable originalTable = null;<br /> ITable newTable = null;<br /> for(int j = 0;j < oTablesCollection.size();j+)<br /> {<br /> originalTable = oTablesCollection.getTable(j);<br /> PropertyBag pBag = originalTable.getConnectionInfo().getAttributes();<br /> System.out.println("Property Bag - charging broker condtion : "pBag);<br /> System.out.println("QE_ServerDescription (dsn) - sub reports : "pBag.get("QE_ServerDescription"));<br /> newTable = oTablesCollection.getTable(j);<br /> ConnectionInfo ci = (ConnectionInfo)newTable.getConnectionInfo();<br /> <br /> PropertyBag logonProps = new PropertyBag();<br /> logonProps.put("Database Class Name","oracle.jdbc.driver.OracleDriver");<br /> logonProps.put("Connection URL","jdbc:oracle:thin:@SERVERNAME:1521:SID");<br /> PropertyBag pb = new PropertyBag();<br /> pb.put(PropertyBagHelper.CONNINFO_CRQE_LOGONPROPERTIES ,logonProps);<br /> pb.put(PropertyBagHelper.CONNINFO_DATABASE_DLL ,"crdb_jdbc.dll");<br /> ci.setAttributes(pb); <br /><br /> ci.setUserName("myuser");<br /> ci.setPassword("mypwd");<br /> newTable.setConnectionInfo(ci);<br /> subreportClientDoc.getDatabaseController().setTableLocation(originalTable, newTable);<br /> System.out.println("User Name : "originalTable.getConnectionInfo().getUserName());<br /> System.out.println("Pass word : "+originalTable.getConnectionInfo().getPassword());<br /> <br /> }<br /> }<br /> }<br /> <br /><br /><br />Up to this no problems for me. Now I have another reports which was also designed by ODBC(RDO) and main report and all sub reports are pointing to same data source except one sub report. This sub report is pointing to other data source.<br />As above mentioned code I tired to send connection information. But I am getting follwing error.<br /><br />com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The Report Application Server failed.-- Error code:-2147482651 Error code name:failed<br /><br />I don't know why it is coming........!!!!!!!!<br />if any body has any solution for this problem please provide me. It's very urgent for me.<br /><br />So simply, the problem is "HOW TO PASS DATA BASE INFO TO THE REPORT WHEN SUB REPORT IS CONNECTED TO DIFFERENT DATA SOURCE THAN MAIN REPORT"<br /><br />thanks in advance<br /><br />Rgds,<br />surya,<br />eMail Id : yerram.surya-sekhar@hp.com<br />suryasekhar_yerram@yahoo.co.in</p>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.