Skip to Content
0
Former Member
Apr 13, 2009 at 07:44 AM

Calling Crystal Report having Stored Procedure in c#.net

174 Views

Hi,

This is the first time i am calling the crystal report(Version 9.2 or Crystal Report 2008 any version is ok) that has stored Procedure through C#.net. While setting the DBLOGON i am getting "The table could not found" error. Would it possible tosend some peace of code ?

The Code iam using to set the log on information.

htConnectionInfo = ParseConnectionString(objBaseDAL._oracleConnection);

ConnectionInfo connectionInfo = new ConnectionInfo();

connectionInfo.ServerName = htConnectionInfo["SERVERNAME"].ToString();

connectionInfo.DatabaseName = "";

connectionInfo.UserID = htConnectionInfo["USERID"].ToString();

ConnectionInfo.Password = htConnectionInfo["PASSWORD"].ToString();

Tables tables = reportDocument.Database.Tables;

foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)

{

tableLogonInfo = table.LogOnInfo;

tableLogonInfo.ConnectionInfo = connectionInfo;

_ table.ApplyLogOnInfo(tableLogonInfo);_

* table.Location = tableLogonInfo.TableName; -


*

}

table.Location i am getting the error that "The table could not found".