Пример #1
0
        private void LoadPrintableReports()
        {//EMthod to add data to the request table,it also avoids the database loginig in prompt
            try
            {
                ReportsRequest          reportJobRequests         = new ReportsRequest();
                ProfitableClientsReport profitableClientsReport   = new ProfitableClientsReport();
                PlacementByLabourer     placementByLabourerReport = new PlacementByLabourer();
                HghlyRqstdCtgryRprt     hghlyRqstdCtgryReport     = new HghlyRqstdCtgryRprt();

                reportJobRequests.SetDatabaseLogon($"{Database.serverLoginName}", $"{Database.serverLoginPass}", $"{Database.serverName}", $"{Database.databaseName}");
                profitableClientsReport.SetDatabaseLogon($"{Database.serverLoginName}", $"{Database.serverLoginPass}", $"{Database.serverName}", $"{Database.databaseName}");
                placementByLabourerReport.SetDatabaseLogon($"{Database.serverLoginName}", $"{Database.serverLoginPass}", $"{Database.serverName}", $"{Database.databaseName}");
                hghlyRqstdCtgryReport.SetDatabaseLogon($"{Database.serverLoginName}", $"{Database.serverLoginPass}", $"{Database.serverName}", $"{Database.databaseName}");
                // reportJobRequests.Load(@"C:\Users\T4NY4\source\repos\iJob2019\PROJECT BACKUP\iJob2019 08_05_2019\ReportJobRequests.rpt");

                reportViewerJobR.ReportSource = reportJobRequests;
                reportViewerJobR.Refresh();

                JobPlacementRprtVwr.ReportSource = placementByLabourerReport;
                JobPlacementRprtVwr.Refresh();

                ProfitabelClientViewer2.ReportSource = profitableClientsReport;
                ProfitabelClientViewer2.Refresh();

                RqstPerLabourersReportViewer.ReportSource = hghlyRqstdCtgryReport;
                RqstPerLabourersReportViewer.Refresh();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Пример #2
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            ReportsRequest rpt = new ReportsRequest();

            rpt.Site = this.Site;
            return(rpt);
        }
Пример #3
0
        private void loadRequestReport()
        {
            ReportsRequest reportJobRequests = new ReportsRequest();

            reportJobRequests.SetDatabaseLogon("ijob", "Tanya@dodger12", "ijobsrvr.database.windows.net", "iJobDatabase");

            // reportJobRequests.Load(@"C:\Users\T4NY4\source\repos\iJob2019\PROJECT BACKUP\iJob2019 08_05_2019\ReportJobRequests.rpt");

            reportViewerJobR.ReportSource = reportJobRequests;
            reportViewerJobR.Refresh();
        }