0
Posted on 6:12 AM by Softminer and filed under ,

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 ;

0
Responses to ... Crystal Report in Visual studio 2003