protected void Drp_shop_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
    {
        if (Drp_shop.SelectedValue.ToString() != "0")
        {
            AFLAC_New_Add_List report = new AFLAC_New_Add_List();
            string             search = Drp_shop.SelectedItem.Text;
            if (Drp_shop.SelectedValue.ToString() != "")
            {
                Telerik.Reporting.Filter filter1 = new Telerik.Reporting.Filter();

                filter1.Operator   = Telerik.Reporting.FilterOperator.Equal;
                filter1.Expression = "=Fields.Shop";
                filter1.Value      = search;
                report.Filters.Add(filter1);
            }
            ReportViewer1.Visible = true;
            ReportViewer1.Report  = report;
        }
    }
        private void SetReportParameters(Report resultReport)
        {
            foreach (var relColumn in ParentToChildSubReportDTO.SubsColumnsDTO)
            {
                //if (parentRelationship.MastertTypeEnum == Enum_MasterRelationshipType.FromForeignToPrimary)
                //    if (relColumn.FirstSideColumnID == null)
                //        continue;

                ReportParameter parameter = new ReportParameter();
                parameter.Name = relColumn.ParentEntityListViewColumnRelativeName;
                parameter.Type = ConvertParameterType(relColumn.ParentEntityListViewColumnType);
                resultReport.ReportParameters.Add(parameter);
                //اگر الیاس داشته باشند چه؟ باید از پرنت الیاسها هم در نظر گرفته شود
                var filter = new Telerik.Reporting.Filter();
                filter.Expression = string.Format("= Fields.{0}", relColumn.ChildEntityListViewColumnRelativeName);
                filter.Operator   = Telerik.Reporting.FilterOperator.Equal;
                filter.Value      = string.Format("= Parameters.{0}.Value", relColumn.ParentEntityListViewColumnRelativeName);
                resultReport.Filters.Add(filter);
            }
        }
        private InstanceReportSource GenerateReport()
        {
            var typeName   = "Orchestrator.Reports.rptDriverTime, Orchestrator.Reports";
            var reportType = Type.GetType(typeName);
            var report     = (IReportDocument)Activator.CreateInstance(reportType);

            report.ReportParameters.ElementAt(0).Value = dteStartDate.SelectedDate.Value.Date;
            report.ReportParameters.ElementAt(1).Value = dteEndDate.SelectedDate.Value.Date;
            report.ReportParameters.ElementAt(2).Value = cboDriver.SelectedValue;

            if (!rbDefault.Checked && txtHoursGreaterThan.Value.HasValue)
            {
                var seconds = (int)txtHoursGreaterThan.Value * 3600;

                if (rbDrive.Checked)
                {
                    Telerik.Reporting.Filter driveFilter = new Telerik.Reporting.Filter();
                    driveFilter.Expression = "=Sum(Fields.DriveDuration)";
                    driveFilter.Operator   = Telerik.Reporting.FilterOperator.GreaterThan;
                    driveFilter.Value      = "=" + seconds.ToString();
                    report.Reports.ElementAt(0).Groups.ElementAt(1).Filters.Add(driveFilter);
                }

                if (rbSpreadOver.Checked)
                {
                    Telerik.Reporting.Filter spreadOverFilter = new Telerik.Reporting.Filter();
                    spreadOverFilter.Expression = "=Sum(Fields.AvailabilityDuration) + Sum(Fields.WorkDuration) + Sum(Fields.DriveDuration)";
                    spreadOverFilter.Operator   = Telerik.Reporting.FilterOperator.GreaterThan;
                    spreadOverFilter.Value      = "=" + seconds.ToString();
                    report.Reports.ElementAt(0).Groups.ElementAt(1).Filters.Add(spreadOverFilter);
                }
            }

            return(new InstanceReportSource {
                ReportDocument = report
            });
        }