Crystal Report with ASP.NET & C#

 /////////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);  

কোন মন্তব্য নেই:

একটি মন্তব্য পোস্ট করুন