Saving current status of the report

The following sample code shows you how to execute a report and save its status into a saved report. You will need to create an ASCX user control where you place the user control CMSReporting\DisplayReport.ascx with ID set to "displayReportControl". The code behind will look like this:

 

[C#]

 

using System.Data;

 

protected void Page_Load(object sender, EventArgs e)

{

   // Create a new data table with parameters

   DataTable dtp = new DataTable();

   dtp.Columns.Add("ModifiedSince", typeof(DateTime));

 

   object[] parameters = new object[1];

   parameters[0] = new DateTime(2006, 1, 1);

 

   dtp.Rows.Add(parameters);

 

   // Disable loading parameters from basic form

   displayReportControl.LoadFormParameters = false;

 

   // Choose report code name

   displayReportControl.ReportName = "RecentlyModifiedDocuments";

      

   // Set custom parameters

   displayReportControl.ReportParameters = dtp.Rows[0];

      

   // Reload data with new parameters

   displayReportControl.ReloadData(false);

      

   // SaveReport() returns 0 if some problem occured or

   // SavedReportID of the successfully saved report

    displayReportControl.SaveReport();

}

 

protected override void Render(HtmlTextWriter writer)

{

   base.Render(writer);

}