cancel
Showing results for 
Search instead for 
Did you mean: 

Calling Crystal Report having Stored Procedure in c#.net

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member183750
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi Ludek,

I am also trying to use a stored procedure as a datasource and i didnt find any SDK/code examples on how to update stored procedure's parameters using my code.

can you please point me to the right place?

former_member183750
Active Contributor
0 Kudos

Try these:

[Business Objects Developer Library|http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/devsuite.htm]

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

[crsdkt net tutorials cr115|http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/en/CrystalReports_dotNET_SDK/crsdk_samples_aspx/data/crsdk_net_tutorials_115_en.zip]

Sample application downloads:

https://smpdl.sap-ag.de/~sapidp/012002523100006252822008E/net_win_smpl.exe

https://smpdl.sap-ag.de/~sapidp/012002523100006252722008E/csharp_win_smpl.exe

https://smpdl.sap-ag.de/~sapidp/012002523100006252712008E/csharp_web_smpl.exe

https://smpdl.sap-ag.de/~sapidp/012002523100006252812008E/net_web_smpl.exe

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/208edbbf-671e-2b10-d7b5-9b57a832...

More sample links in [this|https://wiki.sdn.sap.com/wiki/display/BOBJ/CrystalReportsfor.NETSDK+Samples] wiki.

There really are many threads and posts on parameters in these forums. Typing in 'parameter" in the search, I get over 7 pages of links(!). See if searching these you find anything of interest. Additionally the [notes|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_ossnotes&query=&adv=true] database and [articles|https://www.sdn.sap.com/irj/sdn/businessobjects-articles]

Ludek

Former Member
0 Kudos

Thank you,

I have already tried these links,

they all update the stored procedure parameters using crystalReportViewer

I didn't find anything on how to update the parameters on the server side using ReportClientDocument API.

former_member183750
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Thank you!

Answers (0)