Невозможно запустить rptvwrclinicwsieapointmentcount.localreport.subreportprocessing += new subreportprocessingeventhandler(subreport_appointmentmonthcount); событие
При создании вложенного отчета через RDLC в C# asp.net в веб-приложении я обнаружил ошибку, связанную с
RptVwrClinicWsieApointmentCount.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(Subreport_AppointmentMonthCount);
Я попробовал следующий ниже упомянутый код... Пожалуйста, подскажите мне, что еще мне нужно, чтобы удалить следующую ошибку :-
Что я уже пробовал:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Globalization;
using System.IO;
using System.Configuration;
using System.Data.SqlClient;
using Microsoft.Reporting.WebForms;
namespace Theraplan
{
public partial class ClinicWiseAppointmentCount : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FillClinicList();
//FillTherapistList(ddlClinicNames.SelectedValue.ToString());
}
}
private void FillClinicList()
{
try
{
TCA_Appointment_DLL objDLL = new TCA_Appointment_DLL();
DataTable dtClinic = null;
dtClinic = objDLL.getClinicList();
ddlClinicNames.DataSource = dtClinic;
ddlClinicNames.DataValueField = "Clinic Id";
ddlClinicNames.DataTextField = "Clinic Name";
ddlClinicNames.DataBind();
ddlClinicNames.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", ""));
ddlClinicNames.ClearSelection();
ddlClinicNames.SelectedIndex = 0;
// ddlClinicNames_SelectedIndexChanged(null, null);
}
catch (Exception ex)
{
}
}
protected void GenerateReports_Click(object sender, EventArgs e)
{
ShowReport();
}
private void ShowReport()
{
//Reset
RptVwrClinicWsieApointmentCount.Reset();
//ddlClinicNames.Text,
DataTable dt = GetData(Convert.ToDateTime(txtStartDatetime.Text), Convert.ToDateTime(txtEndDatetime.Text));
RptVwrClinicWsieApointmentCount.Reset();
RptVwrClinicWsieApointmentCount.LocalReport.ReportPath = "ClinicWiseAppointmentCount.rdlc";
ReportDataSource rds = new ReportDataSource("ClinicWiseAppintmentCountDataSet", dt);
RptVwrClinicWsieApointmentCount.LocalReport.DataSources.Add(rds);
RptVwrClinicWsieApointmentCount.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(Subreport_AppointmentMonthCount);
RptVwrClinicWsieApointmentCount.LocalReport.Refresh();
//DataSource
//Added For Sub Reports
//Added For Sub Reports
//Path
//Parameter
ReportParameter[] RptParamsss = new ReportParameter[]
{
// new ReportParameter("CLINIC_ID",ddlClinicNames.Text),
new ReportParameter("START_DATETIME",Convert.ToDateTime(txtStartDatetime.Text).ToString()) ,
new ReportParameter("END_DATETIME", Convert.ToDateTime(txtEndDatetime.Text).ToString())
};
//Refresh
RptVwrClinicWsieApointmentCount.LocalReport.SetParameters(RptParamsss);
RptVwrClinicWsieApointmentCount.LocalReport.Refresh();
}
//Added for Sub Reports
//void localReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e)
//{
// e.DataSources.Add(new ReportDataSource("AppointmentsMonthCount", SqlDs_RefsReportsSub));
//}
void Subreport_AppointmentMonthCount(object sender, SubreportProcessingEventArgs e)
{
string CLINIC_ID = e.Parameters["CLINIC_ID"].Values[0].ToString();
string THERAPIST_ID = e.Parameters["THERAPIST_ID"].Values[1].ToString(); ;
//TextBox1.Text, TextBox2.Text
DataTable AppointmentMonthCountSubreport = GetDataSubReport(CLINIC_ID, THERAPIST_ID);
ReportDataSource ds = new ReportDataSource("AppointmentsMonthCount", AppointmentMonthCountSubreport);
//ds.DataSourceId = "ObjectDataSource1";
//ds.Name = "AppointmentsMonthCount";
e.DataSources.Add(ds);
// e.DataSources.Add(new ReportDataSource("AppointmentsMonthCount",(object) AppointmentsMonthCountDataSet.SP_TCA_GET_APPOINTMENT_COUNT_BY_MONTHDataTable));
}
//Added For Sub Reports
private DataTable GetData(DateTime START_DATETIME, DateTime END_DATETIME)
{//string CLINIC_ID,
DataTable dt = new DataTable();
string conString = ConfigurationManager.ConnectionStrings["TCAConnectionStringNew"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
SqlCommand cmd1 = new SqlCommand("SP_TCA_GET_APPOINTMENT_CLINICWISE", con);
cmd1.CommandType = CommandType.StoredProcedure;
// cmd1.Parameters.Add("@CLINIC_ID", SqlDbType.NVarChar).Value = CLINIC_ID;
cmd1.Parameters.Add("@START_DATETIME", SqlDbType.DateTime).Value = START_DATETIME;
cmd1.Parameters.Add("@END_DATETIME", SqlDbType.DateTime).Value = END_DATETIME;
SqlDataAdapter adp = new SqlDataAdapter(cmd1);
adp.Fill(dt);
con.Close();
}
return dt;
}
private DataTable GetDataSubReport(string CLINIC_ID, string THERAPIST_ID)
{
DataTable dt = new DataTable();
string conString = ConfigurationManager.ConnectionStrings["TCAConnectionStringNew"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
SqlCommand cmd1 = new SqlCommand("SP_TCA_GET_APPOINTMENT_COUNT_BY_MONTH", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@CLINIC_ID", SqlDbType.NVarChar).Value = CLINIC_ID;
cmd1.Parameters.Add("@THERAPIST_ID", SqlDbType.NVarChar).Value = THERAPIST_ID;
SqlDataAdapter adp = new SqlDataAdapter(cmd1);
adp.Fill(dt);
con.Close();
}
return dt;
}
}
}
OriginalGriff
Какая ошибка?
Есть сообщение?