SavedReportsTable

default

markdown

#SavedReportsTable

[[_TOC_]]

##About

Gets or sets the name of the database table that will be used to store reports when running in [[DatabaseAdHocConfig|http://wiki.izenda.com/FAQ/Storing-Reports#Database-Mode]] mode. The table will be created on the database specified with the [[connection string|http://wiki.izenda.com/Integration/Tutorials/connect-to-the-database]] unless a [[SavedReportsDriver|http://wiki.izenda.com/Guides/Izenda-AdHoc-Driver#c)-Saving-Reports-with-Fusion]] is also specified. In that case, the table will be created using the connection specified by that driver. The [[SavedReportsDriver|http://wiki.izenda.com/Guides/Izenda-AdHoc-Driver#c)-Saving-Reports-with-Fusion]] requires [[Fusion|http://wiki.izenda.com/Guides/Izenda-AdHoc-Driver#Izenda-Fusion-Driver]] to be able to use. The table will be created with the following structure:

Name: [[SavedReportsTable|/API/CodeSamples/SavedReportsTable]]

Columns:
* Name: The report's name.
* Xml: The report's XML definition.
* CreatedDate: The date the report was first created.
* ModifiedDate: The date the report was last modified/updated.
* TenantID: The report's tenant ID (this is dependent on the user who created the report. See [[CurrentUserTenantID|/API/CodeSamples/CurrentUserTenantID]] for more info.)
* IzendaAdHocReportsID: not used internally.
* ReportSourceID: not used internally.
* Thumbnail: The serialized image data for the thumbnail saved for this report. This can be avoided when [[GenerateThumbnails|/API/CodeSamples/GenerateThumbnails]] is set to false.
* Form: Contains the HTML definition of any form that is associated with the report.

**Default Value:** IzendaAdHocReports

##Global.asax (C♯)

```csharp
//main class: inherits DatabaseAdHocConfig or FileSystemAdHocConfig
public class CustomAdHocConfig : Izenda.AdHoc.DatabaseAdHocConfig
{
  // Configure settings
  // Add custom settings after setting the license key and connection string by overriding the ConfigureSettings() method
  public static void InitializeReporting() {
    //Check to see if we've already initialized.
    if (HttpContext.Current.Session == null || HttpContext.Current.Session["ReportingInitialized"] != null)
      return;
    AdHocSettings.LicenseKey = "INSERT_LICENSE_KEY_HERE";
    //Creates a connection to Microsoft SQL Server
    AdHocSettings.SqlServerConnectionString = "INSERT_CONNECTION_STRING_HERE";
    AdHocSettings.AdHocConfig = new CustomAdHocConfig();
    AdHocSettings.CurrentUserName = "MyReportsTable"; //The relevant setting
    HttpContext.Current.Session["ReportingInitialized"] = true;
  }
}
```

##Global.asax (VB.NET)

```visualbasic
'main class: inherits DatabaseAdHocConfig or FileSystemAdHocConfig
Public Class CustomAdHocConfig
    Inherits Izenda.AdHoc.DatabaseAdHocConfig

Shared Sub InitializeReporting()
        'Check to see if we've already initialized
        If HttpContext.Current.Session Is Nothing OrElse HttpContext.Current.Session("ReportingInitialized") IsNot Nothing Then
            Return
        'Initialize System
        AdHocSettings.LicenseKey = "INSERT_LICENSE_KEY_HERE"
        AdHocSettings.SqlServerConnectionString = "INSERT_CONNECTION_STRING_HERE"
        AdHocSettings.AdHocConfig = New CustomAdHocConfig()
        AdHocSettings.SavedReportsTable = "MyReportsTable" 'The relevant setting
        HttpContext.Current.Session("ReortingInitialized") = True
    End Sub
End Class
```

Uploading file...

Header

Sidebar

![Izenda Logo](http://izenda.com/wp-content/uploads/2014/12/IzendaNewLogoBlueTR.png)

---

* [[Izenda 7 Series Documentation|https://www.izenda.com/docs/]]
* [[Release Notes]]
* [[Upgrade Best Practices|FAQ/Izenda-Update-Best-Practices]]
* [[FAQ]]
* [[Tutorials]]
* [[The Izenda API|/API/AdHocConfig]]
* [[The AdHocSettings class|/API/AdHocSettings]]
* [Developer Links and Guides](/Guides/Developer-Links-and-Guides)
* [[Known Issues]]

---

* <a href="http://www.izenda.com" rel="nofollow" target="_blank">Izenda Website</a>
* [Product Video](https://www.youtube.com/watch?v=X3-yWFq0w5A)
* <a href="http://www.izenda.com/blog" rel="nofollow" target="_blank">Izenda Blog</a>
* <a href="http://www.izenda.com/company/" rel="nofollow" target="_blank">About Us</a>
* <a href="http://www.izenda.com/contact-us/" rel="nofollow" target="_blank">Contact Us</a>

---
* [Guide To Report Design](/Guides/ReportDesign)
* [Making Custom Forms Video](http://www.youtube.com/watch?v=5b2axJlgdFs)

---

* [[Acknowledgements]]

Edit message:

Cancel

Editing SavedReportsTable

Header

Sidebar