protected void store1_Refresh(object sender, StoreRefreshDataEventArgs e)
{
DataTable tb = SPDayReportWrapper.GetClientGroupPriceReport(ClientGroupID, Convert.ToDateTime(dfReportStartDate.DateField.Value).Date, Convert.ToDateTime(this.dfReportEndDate.DateField.Value).Date);
store1.DataSource = tb;
store1.DataBind();
}
private void BindData()
{
DataTable tb = SPDayReportWrapper.GetClientGroupPriceReport(ClientGroupID, StartDate.Date, EndDate.Date);
ReportDataSource rds = new ReportDataSource("DataSet1", tb);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
SPClientGroupWrapper clientGroupWrapper = SPClientGroupWrapper.FindById(ClientGroupID);
ReportParameter rpName = new ReportParameter();
rpName.Name = "ReportClientGroupName";
rpName.Values.Add(clientGroupWrapper.Name);
ReportParameter rpStartDate = new ReportParameter();
rpStartDate.Name = "ReportStartDate";
rpStartDate.Values.Add(StartDate.ToShortDateString());
ReportParameter rpEndDate = new ReportParameter();
rpEndDate.Name = "ReportEndDate";
rpEndDate.Values.Add(EndDate.ToShortDateString());
ReportViewer1.LocalReport.SetParameters(
new ReportParameter[] { rpName, rpStartDate, rpEndDate });
ReportViewer1.LocalReport.Refresh();
}
