private void cB_To_SelectionChangeCommitted(object sender, EventArgs e) { int from = Convert.ToInt32(cB_From.SelectedValue), to = Convert.ToInt32(cB_To.SelectedValue); if (from > to) { cB_From.SelectedIndex = 0; cB_To.SelectedIndex = 0; from = Convert.ToInt32(cB_From.SelectedValue); to = Convert.ToInt32(cB_To.SelectedValue); } DA_Uplate.getUplate_by_Year_statistika(dt_Uplate, from, to); this.rV_Uplate_matrix.RefreshReport(); this.rV_Uplate_Chart.RefreshReport(); }
private void frm_StatistikaPoslovanja_Load(object sender, EventArgs e) { DA_Uplate.getUplate_by_Year_statistika(dt_Uplate, 2000, DateTime.Today.Year); dt_izvorniPodaci = dt_Uplate.DefaultView.ToTable(); //tabela za filtriranje(jednom dobavljamo podatke iz baze) //YEAR TAB statistika_Uplate_MatrixDataTableBindingSource.DataSource = dt_Uplate; ReportDataSource rds = new ReportDataSource("DS_statistika_Uplate", statistika_Uplate_MatrixDataTableBindingSource); rV_Uplate_matrix.LocalReport.DataSources.Add(rds); rV_Uplate_Chart.LocalReport.DataSources.Add(rds); this.rV_Uplate_matrix.RefreshReport(); this.rV_Uplate_Chart.RefreshReport(); DataTable dt = dt_Uplate.DefaultView.ToTable(true, "Year"); // Distinct values; cB_From.DataSource = dt; cB_From.DisplayMember = "Year"; cB_From.ValueMember = "Year"; DataView dv = new DataView(dt); // Pravim DataView da bih mogao sortirati tabelu dv.Sort = "Year DESC"; // Sortiranje cB_To.DataSource = dv.ToTable(); cB_To.DisplayMember = "Year"; cB_To.ValueMember = "Year"; //MONTH TAB cb_monthYears.DataSource = dv.ToTable(); cb_monthYears.DisplayMember = "Year"; cb_monthYears.ValueMember = "Year"; yearMonthTab = Convert.ToInt32(cb_monthYears.SelectedValue).ToString(); ReportDataSource rdsMonth = new ReportDataSource("DS_UplateMonths", DS_UplateMonth_BS); rv_MonthTab.LocalReport.DataSources.Add(rdsMonth); rv_MonthTab.LocalReport.SetParameters(new ReportParameter("SingleYear", yearMonthTab)); cb_monthYears_SelectionChangeCommitted(null, null); //DAY TAB cB_Year_DayTab.DataSource = dv; cB_Year_DayTab.DisplayMember = "Year"; cB_Year_DayTab.ValueMember = "Year"; DataTable dtDay = dt_Uplate.DefaultView.ToTable(true, "Month"); DataView dvDay = new DataView(dtDay); dvDay.Sort = "Month ASC"; cB_Month_DayTab.DataSource = dvDay; cB_Month_DayTab.DisplayMember = "Month"; cB_Month_DayTab.ValueMember = "Month"; ReportDataSource rdsDay = new ReportDataSource("DS_Uplate_Day", DS_UplateBindingSource); rV_DayTab.LocalReport.DataSources.Add(rdsDay); yearDayTab = Convert.ToString(cB_Year_DayTab.SelectedValue); monthDayTab = Convert.ToString(cB_Month_DayTab.SelectedValue); rV_DayTab.LocalReport.SetParameters(new ReportParameter("SingleMonth", monthDayTab)); rV_DayTab.LocalReport.SetParameters(new ReportParameter("SingleYear", yearDayTab)); cB_Year_DayTab_SelectionChangeCommitted(null, null); }