Example #1
0
        public void Fill(object sender, RoutedEventArgs e)
        {
            this.reportViewer.Reset();

            Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
            Data.ProductDS ProductDS = new Data.ProductDS();

            ProductDS.BeginInit();

            Data.ProductDSTableAdapters.InventorySummaryTableAdapter InventorySummaryTableAdapter = new Data.ProductDSTableAdapters.InventorySummaryTableAdapter();

            DataTable dt = new DataTable();

            if (ReportPanel.Branch != null)
            {
                dt = InventorySummaryTableAdapter.GetDataByBranch(ReportPanel.StartDate, ReportPanel.EndDate, CurrentSession.Id_Company, ReportPanel.Branch.id_branch);
            }
            else
            {
                dt = InventorySummaryTableAdapter.GetDataByDate(ReportPanel.StartDate, ReportPanel.EndDate, CurrentSession.Id_Company);
            }

            reportDataSource1.Name  = "InventorySummary"; //Name of the report dataset in our .RDLC file
            reportDataSource1.Value = dt;                 //SalesDB.SalesByDate;
            this.reportViewer.LocalReport.DataSources.Add(reportDataSource1);
            this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports.InventorySummary.rdlc";

            ProductDS.EndInit();

            this.reportViewer.Refresh();
            this.reportViewer.RefreshReport();
        }
Example #2
0
        public void Fill(object sender, EventArgs e)
        {
            int id_item = sbxItem.ItemID;

            if (id_item > 0)
            {
                this.reportViewer.Reset();

                Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
                Data.ProductDS ProductDS = new Data.ProductDS();

                ProductDS.BeginInit();

                Data.ProductDSTableAdapters.stockflowTableAdapter stockflowTableAdapter = new Data.ProductDSTableAdapters.stockflowTableAdapter();

                //fill data
                stockflowTableAdapter.ClearBeforeFill = true;
                DataTable dt = stockflowTableAdapter.GetData(id_item, CurrentSession.Id_Company);

                reportDataSource1.Name  = "StockFlow";    //Name of the report dataset in our .RDLC file
                reportDataSource1.Value = dt;
                this.reportViewer.LocalReport.DataSources.Add(reportDataSource1);
                this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports.StockFlow.rdlc";

                ProductDS.EndInit();

                this.reportViewer.Refresh();
                this.reportViewer.RefreshReport();
            }
        }
Example #3
0
        public void Fill(object sender, RoutedEventArgs e)
        {
            this.reportViewer.Reset();

            Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
            Data.ProductDS ProductDS = new Data.ProductDS();

            ProductDS.BeginInit();

            Data.ProductDSTableAdapters.PriceListTableAdapter PriceListTableAdapter = new Data.ProductDSTableAdapters.PriceListTableAdapter();

            DataTable dt = new DataTable();

            dt = PriceListTableAdapter.GetDataBy();

            reportDataSource1.Name  = "ItemPriceList"; //Name of the report dataset in our .RDLC file
            reportDataSource1.Value = dt;              //SalesDB.SalesByDate;
            this.reportViewer.LocalReport.DataSources.Add(reportDataSource1);
            this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports.ItemPriceList.rdlc";

            ProductDS.EndInit();

            this.reportViewer.Refresh();
            this.reportViewer.RefreshReport();
        }
Example #4
0
        public void Fill(object sender, RoutedEventArgs e)
        {
            this.reportViewer.Reset();

            Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
            Data.ProductDS ProductDB = new Data.ProductDS();

            ProductDB.BeginInit();

            Data.ProductDSTableAdapters.StockFlowDimensionTableAdapter StockFlowDimensionTableAdapter = new Data.ProductDSTableAdapters.StockFlowDimensionTableAdapter();

            DataTable dt = new DataTable();

            if (ReportPanel.Branch != null)
            {
                dt = StockFlowDimensionTableAdapter.GetDataByBranch(CurrentSession.Id_Company, ReportPanel.Branch.id_branch, ReportPanel.StartDate, ReportPanel.EndDate);
            }
            else
            {
                dt = StockFlowDimensionTableAdapter.GetDataBy(CurrentSession.Id_Company, ReportPanel.StartDate, ReportPanel.EndDate);
            }

            //ReportParameter[] parameters = new ReportParameter[x+1];

            reportDataSource1.Name  = "StockFlowDimension"; //Name of the report dataset in our .RDLC file
            reportDataSource1.Value = dt;                   //SalesDB.SalesByDate;
            this.reportViewer.LocalReport.DataSources.Add(reportDataSource1);
            this.reportViewer.LocalReport.ReportEmbeddedResource = "Cognitivo.Reporting.Reports.StockFlowDimension.rdlc";
            //parameters[0] = new ReportParameter("name1", value1);
            //parameters[0] = new ReportParameter("name1", value1);
            //parameters[0] = new ReportParameter("name1", value1);
            //parameters[0] = new ReportParameter("name1", value1);
            //parameters[0] = new ReportParameter("name1", value1);
            //this.reportViewer.LocalReport.SetParameters("EndDate", dtEndDate, false);

            ProductDB.EndInit();

            this.reportViewer.Refresh();
            this.reportViewer.RefreshReport();
        }