#IzendaAdHocReports table

##About

When using DatabaseAdHocConfig, Izenda reports saves report definitions to the database. By default, this is the table name that izenda.comes. 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.

##MSSQL 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
);

##Oracle Table Script

BEGIN
    CREATE TABLE IzendaAdHocReports
    ( Name VARCHAR(255) NOT NULL,
      Xml NCLOB,
      CreatedDate DATE,
      ModifiedDate DATE,
      TenantID VARCHAR(255),
      IzendaAdHocReportsID INTEGER,
      ReportSourceID INTEGER,
      Thumbnail BLOB
    );
    COMMIT;
END;

##PostgreSQL Table Script

CREATE TABLE IzendaAdHocReports (
	"Name" varchar(255) NOT NULL,
	"Xml" text,
	"CreatedDate" date,
	"ModifiedDate" date,
	"TenantID" varchar(255),
	"IzendaAdHocReportsID" integer,
	"ReportSourceID" integer,
	"Thumbnail" blob,
);

##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.

###MSSQL 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
);

###Oracle SQL table script

BEGIN
    CREATE TABLE IzendaAdHocReports
    ( Name VARCHAR(255) NOT NULL,
      Xml NCLOB,
      CreatedDate DATE,
      ModifiedDate DATE,
      TenantID VARCHAR(255),
      IzendaAdHocReportsID INTEGER,
      Form NCLOB,
      ReportSourceID INTEGER,
      Thumbnail BLOB
    );
    COMMIT;
END;

###PostgreSQL Table Script

CREATE TABLE IzendaAdHocReports (
	"Name" varchar(255) NOT NULL,
	"Xml" text,
	"CreatedDate" date,
	"ModifiedDate" date,
	"TenantID" varchar(255),
	"IzendaAdHocReportsID" integer,
	"ReportSourceID" integer,
	"Thumbnail" blob,
);

###MSSQL 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

###Oracle Alter table script

Here is the Oracle equivalent of the above alter table script

BEGIN
ALTER TABLE IzendaAdHocReports 
ADD (Form NCLOB);
COMMIT;
END;

###PostgreSQL Alter table script

Here is the PostgreSQL equivalent of the above alter table script

ALTER TABLE IzendaAdHocReports 
ADD Form text;

Izenda Logo