Thursday, November 13, 2008

Crystal Report in Visual studio 2003

ReportDocument CrReport = new ReportDocument();

CrReport.Load("report\\report.rpt");

ParameterFields ParamFields=new ParameterFields();


ParamField=new ParameterField();

ParameterDiscreteValue spValue1=new ParameterDiscreteValue();

ParamField.ParameterFieldName ="@field";

ParamField.ParameterType = CrystalDecisions.Shared.ParameterType.StoreProcedureParameter;

spValue1.Value = value;

ParamField.CurrentValues.Add(spValue1);

ParamFields.Add(ParamField);


TableLogOnInfo myTableLogonInfo = new

CrystalDecisions.Shared.TableLogOnInfo();


myTableLogonInfo = CrReport.Database.Tables[0].LogOnInfo;

myTableLogonInfo.ConnectionInfo.ServerName = "Servername";

myTableLogonInfo.ConnectionInfo.DatabaseName = "DB";

myTableLogonInfo.ConnectionInfo.UserID = "sa";

myTableLogonInfo.ConnectionInfo.Password="pass";


CrReport.Database.Tables[0].ApplyLogOnInfo( myTableLogonInfo);

CrystalReportViewer1.ParameterFieldInfo = ParamFields;

CrystalReportViewer1.ReportSource = CrReport ;

No comments:

Post a Comment