/////////Namespace
using CrystalDecisions.Shared;
using CrystalDecisions.Reporting;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.CrystalReports.Engine;
//////
//////Method in Class
public void MethodName4CR (string ServerName, string DBName, string UID, string Passwd, string CRReportPath, string ParameterFieldName, Int32 ParameterValue, CrystalDecisions.Web.CrystalReportViewer rptViwer)
{
CRViwerName.ParameterFieldInfo.Clear();
CRViwerName.ReportSource = CRReportPath;
ParameterFields oParameter = CRViwerName.ParameterFieldInfo;
ParameterField oDT = new ParameterField();
oDT.Name = ParameterFieldName;
ParameterDiscreteValue oParameterValue= new ParameterDiscreteValue();
oParameterValue.Value = ParameterValue;
oDT.CurrentValues.Add(oParameterValue );
oParameter.Add(oDT);
ConnectionInfo conn = new ConnectionInfo();
conn.ServerName = ServerName;
conn.DatabaseName = DBName;
conn.UserID = UID;
conn.Password = Passwd;
foreach (TableLogOnInfo ValInCR in CRViwerName.LogOnInfo)
{
ValInCR.ConnectionInfo = conn;
}
}
///////////////////////////Method Call in UI
ObjectofClasss.MethodName4CR("odbcname", "dbname", "userid", "passwd", reportpath, "parameterName", ParameterValue, CRViewerName);
Crystal Report with ASP.NET & C#
এতে সদস্যতা:
মন্তব্যসমূহ (Atom)