Setting the instance format

In order to set the format for the instance, you must first retrieve the PluginInterface for the report. Continuing from the previous example, you would write:

Report = Reports.Item(1);
var PluginInterface = Report.PluginInterface(""); 

Once you have the PluginInterface, you can set the Format property.

PluginInterface.ReportFormatOptions.Format = 3 //Adobe PDF;

If you choose formats 1, 6, 7, or 8, which are Excel, paginated text, tab separated text, and character separated text respectively, then you must set options that are specific to these formats. For example:

switch(Format)

    {

        case ceFormatTextPaginated:

            PluginInterface.ReportFormatOptions.TextFormatPaginated.LinesPerPage=60;

        break;

        case ceFormatTextTabSeparated:

            PluginInterface.ReportFormatOptions.TextFormatTabSeparated.IsSameDate=true;

            PluginInterface.ReportFormatOptions.TextFormatTabSeparated.IsSameNumber=true;

        break;

        case ceFormatTextCharacterSeparated:

            PluginInterface.ReportFormatOptions.TextFormatCharacterSeparated.IsSameDate = true;

            PluginInterface.ReportFormatOptions.TextFormatCharacterSeparated.IsSameNumber=true;

            PluginInterface.ReportFormatOptions.TextFormatCharacterSeparated.Quote="'";

            PluginInterface.ReportFormatOptions.TextFormatCharacterSeparated.Separator="$$";

        break;

        case ceFormatExcel:

            PluginInterface.ReportFormatOptions.ExcelFormat.BaseAreaType=4; //Details section.

            PluginInterface.ReportFormatOptions.ExcelFormat.HasColumnHeadings=true;

            PluginInterface.ReportFormatOptions.ExcelFormat.IsTabularFormat=true;

            PluginInterface.ReportFormatOptions.ExcelFormat.UseConstColWidth=false;

            PluginInterface.ReportFormatOptions.ExcelFormat.UseWorksheetFunc=true;

        break;

    }

For a description of each property see the, ExcelFormat Object, TextFormatCharacterSeparated Object, TextFormatPaginated Object, and TextFormatTabSeparated Object in the SDK reference. Now that all options are set, you schedule the report normally using the InfoStore. For example:

IStore.Schedule (Reports);

Go to the Example.