コード例 #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            CrystalReport_tkLoaiMonAn rpt = new CrystalReport_tkLoaiMonAn();

            rpt.Site = this.Site;
            return(rpt);
        }
コード例 #2
0
        public void SetDataSource(CrystalReport_tkLoaiMonAn report, string serverName, string databaseName)
        {
            //  Set the connection for the main report.
            report.DataSourceConnections[0].SetConnection(serverName, databaseName, true);

            TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
            ConnectionInfo connectionInfo = new ConnectionInfo();

            CrystalDecisions.Shared.TableLogOnInfo tlicurrent = new CrystalDecisions.Shared.TableLogOnInfo();

            foreach (CrystalDecisions.CrystalReports.Engine.Table table in report.Database.Tables)
            {
                connectionInfo.DatabaseName       = databaseName;
                connectionInfo.ServerName         = serverName;
                connectionInfo.IntegratedSecurity = true;
                tableLogonInfo = table.LogOnInfo;
                tableLogonInfo.ConnectionInfo = connectionInfo;
                tableLogonInfo = table.LogOnInfo;
                tableLogonInfo.ConnectionInfo.ServerName = serverName;
                table.ApplyLogOnInfo(tableLogonInfo);

                table.Location = tableLogonInfo.ConnectionInfo.DatabaseName + ".dbo." +
                                 table.Location.Substring(table.Location.LastIndexOf(".") + 1);
            }
        }
コード例 #3
0
        private void crystalReportViewer1_ReportRefresh(object source, CrystalDecisions.Windows.Forms.ViewerEventArgs e)
        {
            DTO.fThongKeLoaiMonAnDTO fthongkeloaimonan = new DTO.fThongKeLoaiMonAnDTO();
            DataTable table = fthongkeloaimonan.LayDS_LOAIMA();
            CrystalReport_tkLoaiMonAn report = new CrystalReport_tkLoaiMonAn();

            report.SetDataSource(table);
            crystalReportViewer1.ReportSource = report;
        }
コード例 #4
0
 private void frmThongKeLoaiMonAn_Shown(object sender, EventArgs e)
 {
     try
     {
         DTO.fThongKeLoaiMonAnDTO fthongkeloaimonan = new DTO.fThongKeLoaiMonAnDTO();
         DataTable table = fthongkeloaimonan.LayDS_LOAIMA();
         CrystalReport_tkLoaiMonAn report = new CrystalReport_tkLoaiMonAn();
         report.SetDataSource(table);
         crystalReportViewer1.ReportSource = report;
     }
     catch (Exception)
     {
     }
 }