#IzendaAdHocReports table

##About

When using DatabaseAdHocConfig, Izenda reports saves report definitions to the database. By default, this is the table name that Izenda uses. You can use SavedReportsTable to specify a different table name. Izenda will create the table for you, but in the event that something fails, here is the SQL script that will generate the table.

##SQL 2012 Table Script

CREATE TABLE [dbo].[IzendaAdHocReports] (
    [Name]                 NVARCHAR (255)  NULL,
    [Xml]                  NTEXT           NULL,
    [CreatedDate]          DATETIME        NULL,
    [ModifiedDate]         DATETIME        NULL,
    [TenantID]             NVARCHAR (255)  NULL,
    [IzendaAdHocReportsID] INT             NULL,
    [ReportSourceID]       INT             NULL,
    [Thumbnail]            VARBINARY (MAX) NULL
);

##Izenda FORMS plugin

The Izenda FORMS plugin uses a unique process to generate the pixel-perfect forms that the report viewers see. To do this, it needs a special column in the database. Here is the table script with the new column added.

###SQL 2012 table script

CREATE TABLE [dbo].[IzendaAdHocReports] (
    [Name]                 NVARCHAR (255)  NULL,
    [Xml]                  NTEXT           NULL,
    [CreatedDate]          DATETIME        NULL,
    [ModifiedDate]         DATETIME        NULL,
    [TenantID]             NVARCHAR (255)  NULL,
    [IzendaAdHocReportsID] INT             NULL,
    [Form]                 NVARCHAR (MAX)  NULL,
    [ReportSourceID]       INT             NULL,
    [Thumbnail]            VARBINARY (MAX) NULL
);

###Alter table script

And here is an SQL statement to add the field to an existing table.

ALTER TABLE [dbo].[IzendaAdHocReports]
ADD [Form] NVARCHAR (MAX)  NULL

Izenda Logo