Dear ASP.Net,
Update my last posting, i have already succesfull to change my server
setting but another problem appear on deployment computer. Crystal
Report cannot set CR parameter. On development computer everything is
fine.
string ServerName = ConfigurationManager.AppSettings["Server"].ToString();
string UserID = ConfigurationManager.AppSettings["User ID"].ToString();
string Password = ConfigurationManager.AppSettings["Password";].ToString();
string DatabaseName = ConfigurationManager.AppSettings["Database";].ToString();
ReportDocument rptDoc = new ReportDocument();
string reportPath = "";
switch (ReportType)
{
case "DO_SORTED":
reportPath = Server.MapPath(";DeliveryOrderDoSorted.rpt");
rptDoc.Load(reportPath);
rptDoc.SetParameterValue(0, DoID);
rptDoc.SetParameterValue(1, SoID);
break;
case "DO_FINISHED":
reportPath = Server.MapPath(";DeliveryOrderDoFinished.rpt");
rptDoc.Load(reportPath);
rptDoc.SetParameterValue(0, DoID);
rptDoc.SetParameterValue(1, SoID);
break;
}
//rptDoc.SetDatabaseLogon(UserID, Password, ServerName, DatabaseName);
DataSourceConnections dsConnection = rptDoc.DataSourceConnections;
IConnectionInfo connectInfo = dsConnection[0];
connectInfo.SetConnection(ServerName, DatabaseName, UserID, Password);
MemoryStream objStream = new MemoryStream();
objStream =
(MemoryStream)rptDoc.ExportToStream(ExportFormatType.PortableDocFormat);
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.BinaryWrite(objStream.ToArray());
Response.End();
objStream.Dispose();
Best regards,
Surya A. Saputra
.
