Problem in Deploying crystal Report On Server

hi all

my Crysatl Report is working Fine in Local machine.. when i tried to deploy on Server its giving Error Message as " Data Base Log On Failed"

While creating CR i gave my Local server Authentication Details and while deploying its not taking server side authentiacation

can any one suggest me wat to do its urgent...?

Re: Problem in Deploying crystal Report On Server

Hope ur using Oracle as database. if So Please check the below mentioned code.

public static ReportDocument ConnectionInfo(ReportDocument rpt, string TableLocation)
{

try
{
ReportDocument crSubreportDocument;
string[] strConnection = ConfigurationManager.ConnectionStrings[("AppConn")].ConnectionString.Split(new char[] { ';' });
Database oCRDb = rpt.Database;
Tables oCRTables = oCRDb.Tables;
CrystalDecisions.CrystalReports.Engine.Table oCRTable = default(CrystalDecisions.CrystalReports.Engine.Table);
TableLogOnInfo oCRTableLogonInfo = default(CrystalDecisions.Shared.TableLogOnInfo);
ConnectionInfo oCRConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo();

oCRConnectionInfo.ServerName = strConnection[0].Split(new char[] { '=' }).GetValue(1).ToString();
oCRConnectionInfo.Password = strConnection[2].Split(new char[] { '=' }).GetValue(1).ToString();
oCRConnectionInfo.UserID = strConnection[1].Split(new char[] { '=' }).GetValue(1).ToString();

for (int i = 0; i < oCRTables.Count; i++)
{
oCRTable = oCRTables[i];
oCRTableLogonInfo = oCRTable.LogOnInfo;
oCRTableLogonInfo.ConnectionInfo = oCRConnectionInfo;
oCRTable.ApplyLogOnInfo(oCRTableLogonInfo);
oCRTable.Location = TableLocation + "." + oCRTable.Location;
}

for (int i = 0; i < rpt.Subreports.Count; i++)
{
{
crSubreportDocument = rpt.OpenSubreport(rpt.Subreports[i].Name);
oCRDb = crSubreportDocument.Database;
oCRTables = oCRDb.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table aTable in oCRTables)
{
oCRTableLogonInfo = aTable.LogOnInfo;
oCRTableLogonInfo.ConnectionInfo = oCRConnectionInfo;
aTable.ApplyLogOnInfo(oCRTableLogonInfo);
aTable.Location = TableLocation + "." + aTable.Location;
}

}

}
catch (Exception ex)
{
//if (ExceptionPolicy.HandleException(ex, "General"))
// throw;
}
return rpt;
}

The parameter TableLocation U have to pass the Owner name of the Schema. for example

if Your table name is Employee and the Schema user name is HRS. Pass HRS as the TableLocation. coz in Crystal report we are using only the table name.

Hope it hepls

Madhuraj.M

madhurajm@gmail.com

Re: Problem in Deploying crystal Report On Server

Hi,

For CP issue please post your question to this:

http://forums.asp.net/76.aspx/1?Crystal+Reports

You will receive more professional and exact idea from there.