Система бизнес-аналитики Stimulsoft | Форум

Код: Выделить всё

private int number = -1; //номер отчета

protected void Page_Load(object sender, EventArgs e)
{
   number = Параметр_страницы_0;
   if (StiViewer.IsImageRequest) return;

   ShowReport(this.number);
}


protected void ShowReport(int number)
{

        StiReport report = null;
        switch(number)
        {
            case -1:
                break;
						case 32:
                report = InitReport(number);
                if (report != null)
                {
                    DataTable dt1 = new DataTable("Registr");
                    DataTable dt2 = new DataTable("Date");
                    DataTable dt3 = new DataTable("ValueProgress");

                    DataSet ds = new DataSet();
                    ds.Tables.Add(dt1);
                    ds.Tables.Add(dt2);
                    ds.Tables.Add(dt3);

                    SqlDataReader dr1 = GetReport_RegistrDocument(Параметр_страницы_1);
                    dt1.Load(dr1, LoadOption.OverwriteChanges);

                    SqlDataReader dr2 = GetReport_DateRegistrDocument();
                    dt2.Load(dr2, LoadOption.OverwriteChanges);

                    SqlDataReader dr3 = GetReport_ValueProgressRegistrDocument();
                    dt3.Load(dr3, LoadOption.OverwriteChanges);

                    report.RegData(ds);
                    
                    PrepareViewer(report, StiViewer);
                 }
                 break;
             case 33:
                report = InitReport(number);
                if (report != null)
                {
                    report.Dictionary.Variables["ProjectName"].Value = "ла-ла-ла"
                    report.Dictionary.Variables["StageName"].Value = "ла-ла-ла"
                    report.Dictionary.Variables["ps"].Value = Параметр_страницы_1;
                    report.Dictionary.Variables["cat"].Value = Параметр_страницы_2;
                    report.Dictionary.Variables["voidtype"].Value = Параметр_страницы_3;

                    report.Dictionary.Synchronize();
                    report.Compile();
                    PrepareViewer(report, StiViewer);
                }
                break;
            default:
                throw new Exception("Отчета с таким номером не существует");
                break;
        }
    }

}

    protected Stimulsoft.Report.StiReport InitReport(int number)
    {
        Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport();
        switch (number)
        {
            case -1:
                break;
            case 33:
                report.Load(HostingEnvironment.MapPath("~/docsinside/reports_site/DocExecutionByProjectComposition.mrt"));
                break;
            case 34:
                report.Load(HostingEnvironment.MapPath("~/docsinside/reports_site/la-la-la.mrt"));
                break;
                
            default:
                throw new Exception("Отчета с таким номером не существует");
        }
        return report;
    }

    protected void PrepareViewer(StiReport report, StiWebViewer viewer)
    {
        viewer.ServerTimeOut = new TimeSpan(0, 5, 0);
        report.Render(false);

        viewer.Report = report;
    }