Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Calling Crystal Report having Stored Procedure in c#.net

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".

Former Member
replied

OK, so you are using RAS. That being the case, the query should have been posted to the .NET Development - BusinessObjects Enterprise, BusinessObjects Edge, Crystal Reports Server forum. Searching that forum should provide quite a bit of help on RAS. Also see the article [How to use the RAS SDK .NET with In-process RAS Server|https://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/10b840c0-623f-2b10-03b5-9d1913866b32&overridelayout=true].

[Programming the RAS Insight 2007|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b050afe0-2fa5-2b10-658d-98f214ba6a4a]

[Developer Library|https://www.sdn.sap.com/irj/boc/sdklibrary]

[This|https://wiki.sdn.sap.com/wiki/display/BOBJ/NETRASSDK+Samples] wiki provides links to RAS sample and may be of help in the future.

Ludek

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question