protected void btnPreview_Click(object sender, EventArgs e)
{
//http://lifereport/ReportServer/Pages/ReportViewer.aspx //url test report
//ReportSearchParam reportParam = UCReportSearch1.GetSearchField();
C004_Calculator calculator = new C004_Calculator();
DateFrom = calculator.SetFormatdate(txtDateFrom.TextDate.ToString(), 0).ToString("yyyy-MM-dd");
//where < จึงต้องใช้ DateTo + 1
DateTo = calculator.SetFormatdateTo(txtDateTo.TextDate.ToString(), 0).ToString("yyyy-MM-dd");
string reportName = "CommissionFBIRate";
string reportPath = "BaaclifeReport";
string ReportServerUrl = ConfigurationSettings.AppSettings["ServerUrl"].ToString();
//string ReportServerUrl = "http://lifeuatdb/ReportServer";
//string ReportServerUrl = "http://lifereport/reportserver";
//lifereport/reportserver (url production) : must open soap webservice port
ReportViewer1.ServerReport.ReportServerUrl = new System.Uri(ReportServerUrl);
//while (ReportViewer.ServerReport.IsDrillthroughReport)
//{
// ReportViewer.PerformBack();
//}
//// Could also be set to the selection of a ListBox.
string strReport = string.Format("/{0}/{1}", reportPath, reportName);
ReportViewer1.ServerReport.ReportPath = strReport;
//string userName = "******";
//string password = "******";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerCredentials();
List <Microsoft.Reporting.WebForms.ReportParameter> parameters = new List <Microsoft.Reporting.WebForms.ReportParameter>();
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("AreaCode", ddlRegion.SelectedValue.ToString()));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("UpperDivision", ddlProvince.SelectedValue.ToString()));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("Division", ddlBranch.SelectedValue.ToString()));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("AreaCodeName", ddlBranch.SelectedItem.Text));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("UpperDivisionName", ddlProvince.SelectedItem.Text));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("PlanCategory", ddlPlan.SelectedValue.ToString()));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("PlanCategoryName", ddlPlan.SelectedItem.Text));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("PlanCode", ddlCategory.SelectedValue.ToString()));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("PlanCodeName", ddlCategory.SelectedItem.Text));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("StartDate", DateFrom));
DateTime endDate = DateTime.Now;//reportParam.EndDate.Value.AddDays(1).AddMilliseconds(-1);
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("EndDate", DateTo));
bool isBranch = true;//BaacLifeUtil.checkBranch(division);
//if (isBranch)
//{
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("DivisionName", "division.DivisionName"));
//}
//else
//{
// parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("DivisionName", "reportParam.DivisionCodeName"));
//}
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("IsBranch", isBranch.ToString()));
ReportViewer1.ServerReport.SetParameters(parameters);
ReportViewer1.ServerReport.Refresh();
}
protected void btnPreview_Click(object sender, EventArgs e)
{
System.Threading.Thread.CurrentThread.CurrentCulture = us;
System.Threading.Thread.CurrentThread.CurrentUICulture = us;
//ReportSearchParam reportParam = UCReportSearch1.GetSearchField();
C004_Calculator calculator = new C004_Calculator();
DateFrom = calculator.SetFormatdate(txtDateFrom.TextDate.ToString(), 0).ToString("yyyy-MM-dd");
//WHERE < จึงต้องใช้ DATETO + 1
DateTo = calculator.SetFormatdateTo(txtDateTo.TextDate.ToString(), 0).ToString("yyyy-MM-dd HH:mm:ss");
string reportName = WebConfigurationManager.AppSettings["reportName"].ToString();
string reportPath = WebConfigurationManager.AppSettings["reportPath"].ToString();
string ReportServerUrl = WebConfigurationManager.AppSettings["ServerUrl"].ToString();
ReportViewer1.ServerReport.ReportServerUrl = new System.Uri(ReportServerUrl);
//****------ REPORT NOTE :
//1.http://lifereport/ReportServer/Pages/ReportViewer.aspx //url test report
//2.string ReportServerUrl = "http://lifeuatdb/ReportServer";
//3.string ReportServerUrl = "http://lifereport/reportserver";
//4.lifereport/reportserver (url production) : MUST OPEN SOAP WEBSERVICE PORT
//while (ReportViewer.ServerReport.IsDrillthroughReport)
//{
// ReportViewer.PerformBack();
//}
// COULD ALSO BE SET TO THE SELECTION OF A LISTBOX.
string strReport = string.Format("/{0}/{1}", reportPath, reportName);
ReportViewer1.ServerReport.ReportPath = strReport;
//string userName = "******";
//string password = "******";
ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerCredentials();
List <Microsoft.Reporting.WebForms.ReportParameter> parameters = new List <Microsoft.Reporting.WebForms.ReportParameter>();
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("AreaCode", ddlRegion.SelectedValue.ToString()));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("UpperDivision", ddlProvince.SelectedValue.ToString()));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("Division", ddlBranch.SelectedValue.ToString()));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("AreaCodeName", ddlBranch.SelectedItem.Text));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("UpperDivisionName", ddlProvince.SelectedItem.Text));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("PlanCategory", ddlPlan.SelectedValue.ToString()));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("PlanCategoryName", ddlPlan.SelectedItem.Text));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("PlanCode", ddlCategory.SelectedValue.ToString()));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("PlanCodeName", ddlCategory.SelectedItem.Text));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("StartDate", DateFrom));
//DateTime endDate = DateTime.Now;//reportParam.EndDate.Value.AddDays(1).AddMilliseconds(-1);
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("EndDate", DateTo));
bool isBranch = true;
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("DivisionName", ddlBranch.SelectedItem.Text));
parameters.Add(new Microsoft.Reporting.WebForms.ReportParameter("IsBranch", isBranch.ToString()));
ReportViewer1.ServerReport.SetParameters(parameters);
ReportViewer1.ServerReport.Refresh();
lblRemark.Visible = true;
System.Threading.Thread.CurrentThread.CurrentCulture = th;
System.Threading.Thread.CurrentThread.CurrentUICulture = th;
}