i have this problem ...

 

i'm designing report with crystal report 2008

at design time i connect to a db oracle 10

 

i have writed this code to change dbms in runtime

 

CrystalDecisions.ReportAppServer.DataDefModel.ConnectionInfo rcConnectionInfo = rptcd.DatabaseController.GetConnectionInfos(null)[0].Clone(true);

CrystalDecisions.ReportAppServer.DataDefModel.PropertyBag rcLogonInfo = (CrystalDecisions.ReportAppServer.DataDefModel.PropertyBag)rcConnectionInfo.Attributes["QE_LogonProperties"];


rcConnectionInfo.UserName = _DBUser;
rcConnectionInfo.Password = _DBPwd;

rcConnectionInfo.Attributes["QE_ServerDescription"] = _DBServer;

/*

rcConnectionInfo.Attributes["QE_DatabaseName"] = "";
rcConnectionInfo.Attributes["Database DLL"]="crdb_oracle.dll";
rcConnectionInfo.Attributes["QE_DatabaseType"]="Server Oracle ";
rcConnectionInfo.Attributes["QE_SQLDB"]="1";
rcConnectionInfo.Attributes["SSO Enabled"] = "0";
*/

rcLogonInfo["Server"] = _DBServer;

/*

rcLogonInfo["Trusted_Connection"] = "false";
*/

rcConnectionInfo.Attributes["QE_LogonProperties"] = rcLogonInfo;

rcConnectionInfo.Kind = CrystalDecisions.ReportAppServer.DataDefModel.CrConnectionInfoKindEnum.crConnectionInfoKindCRQE;

// metodo 1

foreach (CrystalDecisions.ReportAppServer.DataDefModel.Table tbl in rptcd.DatabaseController.Database.Tables)

{ 
rptcd.DatabaseController.ModifyTableConnectionInfo(tbl.Name,rcConnectionInfo);
}
 

rptcd.DatabaseController.GetConnectionInfos(null).Remove(0);
rptcd.DatabaseController.GetConnectionInfos(null).Insert(0, rcConnectionInfo);

but when i open report... the data don't change

for the out i use a pdf document with byte stream with the follow procedure

 

byte[] ExportReportTo(CrystalDecisions.ReportAppServer.ClientDoc.ISCDReportClientDocument reportClientDocument, FormatoReport formato)

{
CrReportExportFormatEnum rasReportExportFormat;

switch (formato)

{
case FormatoReport.PDF:

rasReportExportFormat = CrReportExportFormatEnum.crReportExportFormatPDF;

break;

default:

rasReportExportFormat = CrReportExportFormatEnum.crReportExportFormatPDF;

break;

}
PrintOutputController rasPrintOutputController = reportClientDocument.PrintOutputController;

CrystalDecisions.ReportAppServer.CommonObjectModel.ByteArray tempByteArray = rasPrintOutputController.Export(rasReportExportFormat, 0);

byte[] byteStreamOutput = tempByteArray.ByteArray;

return byteStreamOutput;

}

 

NB: in watch the rptcd and the relative tables ConnectionInfo is changed but in render the dbms is the same.. :(

there is some flag at design time that not allow change of dbms ?

 

what's the trouble ?

 

pls it's URGENT !!!