Table 9650 Custom Report Layout

Base Application, Microsoft.Foundation.Reporting

src/Layers/W1/BaseApp/Foundation/Reporting/CustomReportLayout.Table.al1,108 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Foundation.Reporting;using System;using System.Environment;using System.IO;using System.Reflection;using System.Security.AccessControl;using System.Utilities;table 9650 "Custom Report Layout"{    Caption = 'Custom Report Layout';    DataPerCompany = false;#if not CLEAN28#pragma warning disable AL0432    DrillDownPageID = "Custom Report Layouts";    LookupPageID = "Custom Report Layouts";#pragma warning restore AL0432#endif    Permissions = TableData "Custom Report Layout" = rimd;    DataClassification = CustomerContent;    fields    {        field(1; "Code"; Code[20])        {            Caption = 'Code';            ToolTip = 'Specifies the Code.';        }        field(2; "Report ID"; Integer)        {            Caption = 'Report ID';            ToolTip = 'Specifies the object ID of the report.';            TableRelation = AllObjWithCaption."Object ID" where("Object Type" = const(Report));        }        field(3; "Report Name"; Text[250])        {            CalcFormula = lookup(AllObjWithCaption."Object Caption" where("Object Type" = const(Report),                                                                           "Object ID" = field("Report ID")));            Caption = 'Report Name';            ToolTip = 'Specifies the name of the report.';            Editable = false;            FieldClass = FlowField;        }        field(4; "Company Name"; Text[30])        {            Caption = 'Company Name';            ToolTip = 'Specifies the Business Central company that the report layout applies to. You to create report layouts that can only be used on reports when they are run for a specific to a company. If the field is blank, then the layout will be available for use in all companies.';            TableRelation = Company;        }        field(6; Type; Enum "Custom Report Layout Type")        {            Caption = 'Type';            ToolTip = 'Specifies the file type of the report layout. The following table includes the types that are available:';            InitValue = Word;        }        field(7; "Layout"; BLOB)        {            Caption = 'Layout';        }        field(8; "Last Modified"; DateTime)        {            Caption = 'Last Modified';            ToolTip = 'Specifies the date and time of the last change to the report layout entry.';            Editable = false;        }        field(9; "Last Modified by User"; Code[50])        {            Caption = 'Last Modified by User';            ToolTip = 'Specifies the user who made the last change to the report layout entry.';            DataClassification = EndUserIdentifiableInformation;            Editable = false;            TableRelation = User."User Name";            ValidateTableRelation = false;        }        field(10; "File Extension"; Text[30])        {            Caption = 'File Extension';            Editable = false;        }        field(11; Description; Text[250])        {            Caption = 'Description';            ToolTip = 'Specifies a description of the report layout.';        }        field(12; "Custom XML Part"; BLOB)        {            Caption = 'Custom XML Part';        }        field(13; "App ID"; Guid)        {            Caption = 'App ID';            Editable = false;        }        field(14; "Built-In"; Boolean)        {            Caption = 'Built-In';            ToolTip = 'Specifies if the report layout is built-in or not.';            Editable = false;        }        field(15; "Layout Last Updated"; DateTime)        {            Caption = 'Layout Last Modified';            Editable = false;        }    }    keys    {        key(Key1; "Code")        {            Clustered = true;        }        key(Key2; "Report ID", "Company Name", Type)        {        }    }    fieldgroups    {        fieldgroup(DropDown; Description)        {        }    }    trigger OnDelete()    begin        if "Built-In" then            Error(DeleteBuiltInLayoutErr);    end;    trigger OnInsert()    begin        TestField("Report ID");        if Code = '' then            Code := GetDefaultCode("Report ID");        SetUpdated();    end;    trigger OnModify()    begin        TestField("Report ID");        SetUpdated();    end;    var        ImportWordTxt: Label 'Import Word Document';        ImportRdlcTxt: Label 'Import Report Layout';        FileFilterWordTxt: Label 'Word Files (*.docx)|*.docx', Comment = '{Split=r''\|''}{Locked=s''1''}';        FileFilterRdlcTxt: Label 'SQL Report Builder (*.rdl;*.rdlc)|*.rdl;*.rdlc', Comment = '{Split=r''\|''}{Locked=s''1''}';        NoRecordsErr: Label 'There is no record in the list.';        BuiltInTxt: Label 'Built-in layout';#pragma warning disable AA0470        CopyOfTxt: Label 'Copy of %1';#pragma warning restore AA0470        NewLayoutTxt: Label 'New layout';        ErrorInLayoutErr: Label 'The following issue has been found in the layout %1 for report ID  %2:\%3.', Comment = '%1=a name, %2=a number, %3=a sentence/error description.';        TemplateValidationQst: Label 'The RDLC layout does not comply with the current report design (for example, fields are missing or the report ID is wrong).\The following errors were detected during the layout validation:\%1\Do you want to continue?', Comment = '%1 = an error message.';#pragma warning disable AA0470        TemplateValidationErr: Label 'The RDLC layout does not comply with the current report design (for example, fields are missing or the report ID is wrong).\The following errors were detected during the document validation:\%1\You must update the layout to match the current report design.';#pragma warning restore AA0470        AbortWithValidationErr: Label 'The RDLC layout action has been canceled because of validation errors.';        ModifyBuiltInLayoutQst: Label 'This is a built-in custom report layout, and it cannot be modified.\\Do you want to modify a copy of the custom report layout instead?';        NoLayoutSelectedMsg: Label 'You must specify if you want to insert a Word layout or an RDLC layout for the report.';        DeleteBuiltInLayoutErr: Label 'This is a built-in custom report layout, and it cannot be deleted.';        ModifyBuiltInLayoutErr: Label 'This is a built-in custom report layout, and it cannot be modified.';    local procedure SetUpdated()    begin        "Last Modified" := RoundDateTime(CurrentDateTime);        "Last Modified by User" := CopyStr(UserId(), 1, 50);    end;    procedure InitBuiltInLayout(ReportID: Integer; LayoutType: Option): Code[20]    var        CustomReportLayout: Record "Custom Report Layout";        TempBlob: Codeunit "Temp Blob";        DocumentReportMgt: Codeunit "Document Report Mgt.";        OutStr: OutStream;    begin        if ReportID = 0 then            exit;        CustomReportLayout.Init();        CustomReportLayout."Report ID" := ReportID;        CustomReportLayout.Type := "Custom Report Layout Type".FromInteger(LayoutType);        CustomReportLayout.Description := CopyStr(StrSubstNo(CopyOfTxt, BuiltInTxt), 1, MaxStrLen(Description));        CustomReportLayout."Built-In" := false;        CustomReportLayout.Code := GetDefaultCode(ReportID);        CustomReportLayout.Insert(true);        case LayoutType of            CustomReportLayout.Type::Word.AsInteger():                begin                    if not LoadInternalWordLayout(ReportID, TempBlob) then begin                        TempBlob.CreateOutStream(OutStr);                        DocumentReportMgt.NewWordLayout(ReportID, OutStr);                        CustomReportLayout.Description := CopyStr(NewLayoutTxt, 1, MaxStrLen(Description));                    end;                    CustomReportLayout.SetLayoutBlob(TempBlob);                end;            CustomReportLayout.Type::RDLC.AsInteger():                if LoadInternalRdlcLayout(ReportID, TempBlob) then                    CustomReportLayout.SetLayoutBlob(TempBlob);            else                OnInitBuiltInLayout(CustomReportLayout, ReportID, LayoutType);        end;        CustomReportLayout.SetDefaultCustomXmlPart();        CustomReportLayout.SetLayoutLastUpdated();        exit(CustomReportLayout.Code);    end;    /// <summary>    /// Internal resplacement for the soon deprecated Report.WordLayout function. This function will load the internal Word layout for the given report using the virtual table Report Layout List.    /// </summary>    /// <param name="ReportID">Report Id.</param>    /// <param name="TempBlob">Layout will be provided in the blob object if the procedure return true.</param>    /// <returns>True if the layout was loaded.</returns>    local procedure LoadInternalWordLayout(ReportID: Integer; var TempBlob: Codeunit "Temp Blob"): Boolean    var        ReportLayoutList: Record "Report Layout List";        LayoutStream: OutStream;        ExportStatus: Boolean;    begin        ReportLayoutList.SetFilter("Report ID", '=%1', ReportID);        ReportLayoutList.SetFilter("Layout Format", '=%1', ReportLayoutList."Layout Format"::Word);        if not ReportLayoutList.FindFirst() then            exit(false);        TempBlob.CreateOutStream(LayoutStream);        ExportStatus := ReportLayoutList.Layout.ExportStream(LayoutStream);        exit(ExportStatus)    end;    /// <summary>    /// Internal resplacement for the soon deprecated Report.RdlcLayout function. This function will load the internal RDLC layout for the given report using the virtual table Report Layout List.    /// </summary>    /// <param name="ReportID">Report Id.</param>    /// <param name="TempBlob">Layout will be provided in the blob object if the procedure return true.</param>    /// <returns>True if the layout was loaded.</returns>    local procedure LoadInternalRdlcLayout(ReportID: Integer; var TempBlob: Codeunit "Temp Blob"): Boolean    var        ReportLayoutList: Record "Report Layout List";        LayoutStream: OutStream;        ExportStatus: Boolean;    begin        ReportLayoutList.SetFilter("Report ID", '=%1', ReportID);        ReportLayoutList.SetFilter("Layout Format", '=%1', ReportLayoutList."Layout Format"::RDLC);        if not ReportLayoutList.FindFirst() then            exit(false);        TempBlob.CreateOutStream(LayoutStream);        ExportStatus := ReportLayoutList.Layout.ExportStream(LayoutStream);        exit(ExportStatus)    end;    procedure CopyBuiltInReportLayout()    var        ReportLayoutLookup: Page "Report Layout Lookup";        ReportID: Integer;        LayoutSelected: Boolean;    begin        FilterGroup(4);        if GetFilter("Report ID") = '' then            FilterGroup(0);        if GetFilter("Report ID") <> '' then            if Evaluate(ReportID, GetFilter("Report ID")) then                ReportLayoutLookup.SetReportID(ReportID);        FilterGroup(0);        if ReportLayoutLookup.RunModal() = ACTION::OK then begin            if ReportLayoutLookup.SelectedAddWordLayot() then                InitBuiltInLayout(ReportLayoutLookup.SelectedReportID(), Type::Word.AsInteger());            if ReportLayoutLookup.SelectedAddRdlcLayot() then                InitBuiltInLayout(ReportLayoutLookup.SelectedReportID(), Type::RDLC.AsInteger());            LayoutSelected := ReportLayoutLookup.SelectedAddWordLayot() or ReportLayoutLookup.SelectedAddRdlcLayot();            if (not LayoutSelected) and (not ReportLayoutLookup.InitCustomTypeLayouts()) then                MESSAGE(NoLayoutSelectedMsg);        end;    end;    procedure CopyReportLayout(): Code[20]    var        CustomReportLayout: Record "Custom Report Layout";        TempBlob: Codeunit "Temp Blob";    begin        if IsEmpty() then            Error(NoRecordsErr);        CalcFields(Layout, "Custom XML Part");        CustomReportLayout := Rec;        Description := CopyStr(StrSubstNo(CopyOfTxt, Description), 1, MaxStrLen(Description));        Code := GetDefaultCode("Report ID");        "Built-In" := false;        OnCopyRecordOnBeforeInsertLayout(Rec, CustomReportLayout);        Insert(true);        if CustomReportLayout."Built-In" then begin            CustomReportLayout.GetLayoutBlob(TempBlob);            SetLayoutBlob(TempBlob);        end;        if not HasCustomXmlPart() then            SetDefaultCustomXmlPart();        exit(Code);    end;    procedure ImportReportLayout(DefaultFileName: Text)    var        TempBlob: Codeunit "Temp Blob";        FileMgt: Codeunit "File Management";        FileName: Text;        FileFilterTxt: Text;        ImportTxt: Text;    begin        if IsEmpty() then            Error(NoRecordsErr);        if not CanBeModified() then            exit;        case Type of            Type::Word:                begin                    ImportTxt := ImportWordTxt;                    FileFilterTxt := FileFilterWordTxt;                end;            Type::RDLC:                begin                    ImportTxt := ImportRdlcTxt;                    FileFilterTxt := FileFilterRdlcTxt;                end;        end;        OnImportLayoutSetFileFilter(Rec, FileFilterTxt);        FileName := FileMgt.BLOBImportWithFilter(TempBlob, ImportTxt, DefaultFileName, FileFilterTxt, FileFilterTxt);        if FileName = '' then            exit;        ImportLayoutBlob(TempBlob, CopyStr(UpperCase(FileMgt.GetExtension(FileName)), 1, 30));    end;    [Scope('OnPrem')]    procedure ImportLayoutBlob(var TempBlob: Codeunit "Temp Blob"; FileExtension: Text[30])    var        OutputTempBlob: Codeunit "Temp Blob";        DocumentReportMgt: Codeunit "Document Report Mgt.";        DocumentInStream: InStream;        DocumentOutStream: OutStream;        ErrorMessage: Text;        XmlPart: Text;    begin        // Layout is stored in the DocumentInStream (RDLC requires UTF8 encoding for which reason is stream is created in the case block.        // Result is stored in the DocumentOutStream (..)        TestField("Report ID");        OutputTempBlob.CreateOutStream(DocumentOutStream);        XmlPart := GetWordXmlPart("Report ID");        case Type of            Type::Word:                begin                    // Run update                    TempBlob.CreateInStream(DocumentInStream);                    ErrorMessage := DocumentReportMgt.TryUpdateWordLayout(DocumentInStream, DocumentOutStream, '', XmlPart);                    // Validate the Word document layout against the layout of the current report                    if ErrorMessage = '' then begin                        CopyStream(DocumentOutStream, DocumentInStream);                        DocumentReportMgt.ValidateWordLayout("Report ID", DocumentInStream, true, true);                    end;                end;            Type::RDLC:                begin                    // Update the Rdlc document layout against the layout of the current report                    TempBlob.CreateInStream(DocumentInStream, TEXTENCODING::UTF8);                    ErrorMessage := DocumentReportMgt.TryUpdateRdlcLayout("Report ID", DocumentInStream, DocumentOutStream, '', XmlPart, false);                end;        end;        OnImportLayoutBlob(Rec, TempBlob, FileExtension, XmlPart, DocumentOutStream);        SetLayoutBlob(OutputTempBlob);        if FileExtension <> '' then            "File Extension" := FileExtension;        SetDefaultCustomXmlPart();        Modify(true);        SetLayoutLastUpdated();        Commit();        if ErrorMessage <> '' then            Message(ErrorMessage);    end;    procedure ExportReportLayout(DefaultFileName: Text; ShowFileDialog: Boolean): Text    var        TempBlob: Codeunit "Temp Blob";        FileMgt: Codeunit "File Management";    begin        OnBeforeExportReportLayout(Rec, DefaultFileName, ShowFileDialog);        // Update is needed in case of report layout mismatches word layout        // Do not update build-in layout as it is read only        if not "Built-In" then            UpdateReportLayout(true, false); // Don't block on errors (return false) as we in all cases want to have an export file to edit.        GetLayoutBlob(TempBlob);        if not TempBlob.HasValue() then            exit('');        if DefaultFileName = '' then            DefaultFileName := '*.' + GetFileExtension();        exit(FileMgt.BLOBExport(TempBlob, DefaultFileName, ShowFileDialog));    end;    [Scope('OnPrem')]    procedure ValidateLayout(useConfirm: Boolean; UpdateContext: Boolean): Boolean    var        TempBlob: Codeunit "Temp Blob";        DocumentReportMgt: Codeunit "Document Report Mgt.";        DocumentInStream: InStream;        ValidationErrorFormat: Text;    begin        TestField("Report ID");        GetLayoutBlob(TempBlob);        if not TempBlob.HasValue() then            exit;        TempBlob.CreateInStream(DocumentInStream);        case Type of            Type::Word:                exit(DocumentReportMgt.ValidateWordLayout("Report ID", DocumentInStream, useConfirm, UpdateContext));            Type::RDLC:                if not TryValidateRdlcReport(DocumentInStream) then begin                    if useConfirm then begin                        if not Confirm(TemplateValidationQst, false, GetLastErrorText) then                            Error(AbortWithValidationErr);                    end else begin                        ValidationErrorFormat := TemplateValidationErr;                        Error(ValidationErrorFormat, GetLastErrorText);                    end;                    exit(false);                end;        end;        exit(true);    end;    procedure UpdateReportLayout(ContinueOnError: Boolean; IgnoreDelete: Boolean) LayoutUpdated: Boolean    var        ErrorMessage: Text;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeUpdateLayout(LayoutUpdated, IsHandled);        if IsHandled then            exit(LayoutUpdated);        ErrorMessage := TryUpdateLayout(IgnoreDelete);        if ErrorMessage = '' then begin            if Type = Type::Word then                exit(ValidateLayout(true, true));            exit(true); // We have no validate for RDLC        end;        ErrorMessage := StrSubstNo(ErrorInLayoutErr, Description, "Report ID", ErrorMessage);        if ContinueOnError then begin            Message(ErrorMessage);            exit(true);        end;        Error(ErrorMessage);    end;    [Scope('OnPrem')]    procedure TryUpdateLayout(IgnoreDelete: Boolean): Text    var        InTempBlob: Codeunit "Temp Blob";        OutTempBlob: Codeunit "Temp Blob";        DocumentReportMgt: Codeunit "Document Report Mgt.";        DocumentInStream: InStream;        DocumentOutStream: OutStream;        CurrentCustomXmlPart: Text;        StoredCustomXmlPart: Text;        ErrorMessage: Text;    begin        TestCustomXmlPart();        TestField("Report ID");        CurrentCustomXmlPart := GetWordXmlPart("Report ID");        StoredCustomXmlPart := GetCustomXmlPart();        if "Layout Last Updated" > "Last Modified" then            if CurrentCustomXmlPart = StoredCustomXmlPart then                exit(''); // no need to update        GetLayoutBlob(InTempBlob);        if not InTempBlob.HasValue() then            exit('');        InTempBlob.CreateInStream(DocumentInStream);        case Type of            Type::Word:                begin                    OutTempBlob.CreateOutStream(DocumentOutStream);                    ErrorMessage := DocumentReportMgt.TryUpdateWordLayout(DocumentInStream, DocumentOutStream, StoredCustomXmlPart, CurrentCustomXmlPart);                end;            Type::RDLC:                begin                    OutTempBlob.CreateOutStream(DocumentOutStream, TEXTENCODING::UTF8);                    ErrorMessage := DocumentReportMgt.TryUpdateRdlcLayout(                        "Report ID", DocumentInStream, DocumentOutStream, StoredCustomXmlPart, CurrentCustomXmlPart, IgnoreDelete);                end;        end;        SetCustomXmlPart(CurrentCustomXmlPart);        if OutTempBlob.HasValue() then            SetLayoutBlob(OutTempBlob);        SetLayoutLastUpdated();        exit(ErrorMessage);    end;    local procedure GetWordXML(var TempBlob: Codeunit "Temp Blob")    var        OutStr: OutStream;    begin        TestField("Report ID");        TempBlob.CreateOutStream(OutStr, TEXTENCODING::UTF16);        OutStr.WriteText(REPORT.WordXmlPart("Report ID"));    end;    [Scope('OnPrem')]    procedure ExportSchema(DefaultFileName: Text; ShowFileDialog: Boolean) Result: Text    var        TempBlob: Codeunit "Temp Blob";        FileMgt: Codeunit "File Management";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeExportSchema(Rec, DefaultFileName, ShowFileDialog, IsHandled);        if IsHandled then            exit(Result);        TestField(Type, Type::Word);        if DefaultFileName = '' then            DefaultFileName := '*.xml';        GetWordXML(TempBlob);        if TempBlob.HasValue() then            exit(FileMgt.BLOBExport(TempBlob, DefaultFileName, ShowFileDialog));    end;    procedure GetFileExtension() FileExt: Text[4]    begin        case Type of            Type::Word:                FileExt := 'docx';            Type::RDLC:                FileExt := 'rdl';            else                OnGetFileExtension(Rec, FileExt);        end;    end;    procedure GetWordXmlPart(ReportID: Integer): Text    var        WordXmlPart: Text;    begin        // Store the current design as an extended WordXmlPart. This data is used for later updates / refactorings.        WordXmlPart := REPORT.WordXmlPart(ReportID, true);        exit(WordXmlPart);    end;    procedure RunCustomReport()    var        ReportLayoutSelection: Record "Report Layout Selection";    begin        if "Report ID" = 0 then            exit;        ReportLayoutSelection.SetTempLayoutSelected(Code);        REPORT.RunModal("Report ID");        ReportLayoutSelection.ClearTempLayoutSelected();    end;    [Scope('OnPrem')]    procedure ApplyUpgrade(var ReportUpgrade: DotNet ReportUpgradeSet; var ReportChangeLogCollection: DotNet IReportChangeLogCollection; testOnly: Boolean)    var        InTempBlob: Codeunit "Temp Blob";        OutTempBlob: Codeunit "Temp Blob";        TempReportChangeLogCollection: DotNet IReportChangeLogCollection;        DataInStream: InStream;        DataOutStream: OutStream;        ModifyLayout: Boolean;    begin        GetLayoutBlob(InTempBlob);        if not InTempBlob.HasValue() then            exit;        if ReportUpgrade.ChangeCount < 1 then            exit;        Clear(DataInStream);        Clear(DataOutStream);        case Type of            Type::Word:                begin                    InTempBlob.CreateInStream(DataInStream);                    OutTempBlob.CreateOutStream(DataOutStream);                end;            Type::RDLC:                begin                    InTempBlob.CreateInStream(DataInStream, TEXTENCODING::UTF8);                    OutTempBlob.CreateOutStream(DataOutStream, TEXTENCODING::UTF8);                end;        end;        TempReportChangeLogCollection := ReportUpgrade.Upgrade(Description, DataInStream, DataOutStream);        if not testOnly then begin            if TempReportChangeLogCollection.Failures = 0 then begin                SetDefaultCustomXmlPart();                ModifyLayout := true;            end;            if OutTempBlob.HasValue() then begin                SetLayoutBlob(OutTempBlob);                ModifyLayout := true;            end;            if ModifyLayout then                Commit();        end;        if TempReportChangeLogCollection.Count > 0 then            if IsNull(ReportChangeLogCollection) then                ReportChangeLogCollection := TempReportChangeLogCollection            else                ReportChangeLogCollection.AddRange(TempReportChangeLogCollection);    end;    [TryFunction]    local procedure TryValidateRdlcReport(var InStr: InStream)    var        RdlcReportManager: DotNet RdlcReportManager;        RdlcString: Text;    begin        InStr.Read(RdlcString);        RdlcReportManager.ValidateReport("Report ID", RdlcString);    end;#if not CLEAN28    local procedure FilterOnReport(ReportID: Integer)    begin        Reset();        SetCurrentKey("Report ID", "Company Name", Type);        SetFilter("Company Name", '%1|%2', '', StrSubstNo('@%1', CompanyName));        SetRange("Report ID", ReportID);        SetRange("Built-In", false);    end;    [Obsolete('This procedure is obsolete because the lookup page 9650 Custom Report Layouts is obsoleted.', '28.0')]    procedure LookupLayoutOK(ReportID: Integer): Boolean    begin        FilterOnReport(ReportID);        OnLookupLayoutOKOnBeforePageRun(Rec);#pragma warning disable AL0432        exit(PAGE.RunModal(PAGE::"Custom Report Layouts", Rec) = ACTION::LookupOK);#pragma warning restore AL0432    end;#endif    procedure GetDefaultCode(ReportID: Integer): Code[20]    var        CustomReportLayout: Record "Custom Report Layout";        NewCode: Code[20];    begin        CustomReportLayout.SetRange("Report ID", ReportID);        CustomReportLayout.SetFilter(Code, StrSubstNo('%1-*', ReportID));        if CustomReportLayout.FindLast() then            NewCode := IncStr(CustomReportLayout.Code)        else            NewCode := StrSubstNo('%1-000001', ReportID);        exit(NewCode);    end;    [Scope('OnPrem')]    procedure CanBeModified(): Boolean    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCanBeModified(Rec, IsHandled);        if IsHandled then            exit;        if not "Built-In" then            exit(true);        if not Confirm(ModifyBuiltInLayoutQst) then            exit(false);        CopyReportLayout();        exit(true);    end;    [Scope('OnPrem')]    procedure NewExtensionLayout(ExtensionAppId: Guid; LayoutDataTable: DotNet DataTable)    var        Row: DotNet DataRow;        Version: Text;    begin        Row := LayoutDataTable.Rows.Item(0);        if LayoutDataTable.Columns.Contains('NavApplicationVersion') then            Version := Row.Item('NavApplicationVersion');        case Version of            else                HandleW10Layout(ExtensionAppId, Row, LayoutDataTable);        end;    end;    local procedure HandleW10Layout(ExtensionAppId: Guid; Row: DotNet DataRow; LayoutDataTable: DotNet DataTable)    var        CustomReportLayout: Record "Custom Report Layout";        LayoutCode: Code[20];    begin        if not LayoutDataTable.Columns.Contains('Code') then begin            LayoutCode := 'MS-EXT-0000000001';            CustomReportLayout.SetFilter(Code, 'MS-EXT-*');            if CustomReportLayout.FindLast() then                LayoutCode := IncStr(CustomReportLayout.Code);        end else            LayoutCode := Row.Item('Code');        CustomReportLayout.Reset();        CustomReportLayout.Init();        CustomReportLayout.Code := LayoutCode;        CustomReportLayout."App ID" := ExtensionAppId;        CustomReportLayout.Type := Row.Item('Type');        CustomReportLayout."Custom XML Part" := Row.Item('CustomXMLPart');        CustomReportLayout.Description := Row.Item('Description');        CustomReportLayout.Layout := Row.Item('Layout');        CustomReportLayout."Report ID" := Row.Item('ReportID');        CustomReportLayout.CalcFields("Report Name");        CustomReportLayout."Built-In" := true;        CustomReportLayout.Insert();    end;    procedure HasLayout(): Boolean    begin        if "Built-In" then            exit(HasBuiltInLayout());        exit(HasNonBuiltInLayout());    end;    procedure HasCustomXmlPart(): Boolean    begin        if "Built-In" then            exit(HasBuiltInCustomXmlPart());        exit(HasNonBuiltInCustomXmlPart());    end;    procedure GetLayout(): Text    begin        if "Built-In" then            exit(GetBuiltInLayout());        exit(GetNonBuiltInLayout());    end;    procedure GetCustomXmlPart(): Text    begin        if "Built-In" then            exit(GetBuiltInCustomXmlPart());        exit(GetNonBuiltInCustomXmlPart());    end;    procedure GetLayoutBlob(var TempBlob: Codeunit "Temp Blob")    var        ReportLayout: Record "Report Layout";    begin        Clear(TempBlob);        TempBlob.FromRecord(Rec, FieldNo(Layout));        if "Built-In" then            if not TempBlob.HasValue() then begin // not a built-in report from an extension                ReportLayout.Get(Code);                TempBlob.FromRecord(ReportLayout, ReportLayout.FieldNo(Layout));            end;    end;    procedure ClearLayout()    begin        if "Built-In" then            Error(ModifyBuiltInLayoutErr);        SetNonBuiltInLayout('');    end;    procedure ClearCustomXmlPart()    begin        if "Built-In" then            Error(ModifyBuiltInLayoutErr);        SetNonBuiltInCustomXmlPart('');    end;    procedure CanModify(): Boolean    var        User: Record User;        [SecurityFiltering(SecurityFilter::Ignored)]        CustomReportLayout: Record "Custom Report Layout";    begin        if CurrentTransactionType() = TransactionType::Report then            exit(false);        if not CustomReportLayout.WritePermission() then            exit(false);        if not User.Get(UserSecurityId()) then            exit(true);        exit(User."License Type" <> User."License Type"::"Limited User");    end;    procedure TestLayout()    var        ReportLayout: Record "Report Layout";    begin        if not "Built-In" then begin            CalcFields(Layout);            TestField(Layout);            exit;        end;        ReportLayout.Get(Code);        ReportLayout.CalcFields(Layout);        ReportLayout.TestField(Layout);    end;    procedure TestCustomXmlPart()    var        ReportLayout: Record "Report Layout";    begin        if not "Built-In" then begin            CalcFields("Custom XML Part");            TestField("Custom XML Part");            exit;        end;        ReportLayout.Get(Code);        ReportLayout.CalcFields("Custom XML Part");        ReportLayout.TestField("Custom XML Part");    end;    procedure SetLayout(Content: Text)    begin        if "Built-In" then            Error(ModifyBuiltInLayoutErr);        SetNonBuiltInLayout(Content);    end;    procedure SetCustomXmlPart(Content: Text)    begin        if "Built-In" then            Error(ModifyBuiltInLayoutErr);        SetNonBuiltInCustomXmlPart(Content);    end;    procedure SetDefaultCustomXmlPart()    begin        SetCustomXmlPart(GetWordXmlPart("Report ID"));    end;    procedure SetLayoutBlob(var TempBlob: Codeunit "Temp Blob")    var        RecordRef: RecordRef;    begin        if "Built-In" then            Error(ModifyBuiltInLayoutErr);        Clear(Layout);        if TempBlob.HasValue() then begin            RecordRef.GetTable(Rec);            TempBlob.ToRecordRef(RecordRef, FieldNo(Layout));            RecordRef.SetTable(Rec);        end;        if CanModify() then            Modify();    end;    local procedure HasNonBuiltInLayout(): Boolean    begin        CalcFields(Layout);        exit(Layout.HasValue);    end;    local procedure HasNonBuiltInCustomXmlPart(): Boolean    begin        CalcFields("Custom XML Part");        exit("Custom XML Part".HasValue);    end;    local procedure HasBuiltInLayout(): Boolean    var        ReportLayout: Record "Report Layout";    begin        if not ReportLayout.Get(Code) then            exit(false);        ReportLayout.CalcFields(Layout);        exit(ReportLayout.Layout.HasValue);    end;    local procedure HasBuiltInCustomXmlPart(): Boolean    var        ReportLayout: Record "Report Layout";    begin        if not ReportLayout.Get(Code) then            exit(false);        ReportLayout.CalcFields("Custom XML Part");        exit(ReportLayout."Custom XML Part".HasValue);    end;    local procedure GetNonBuiltInLayout(): Text    var        InStr: InStream;        Content: Text;    begin        CalcFields(Layout);        if not Layout.HasValue() then            exit('');        case Type of            Type::RDLC:                Layout.CreateInStream(InStr, TEXTENCODING::UTF8);            Type::Word:                Layout.CreateInStream(InStr);            else                OnGetNonBuiltInLayout(Rec, InStr);        end;        InStr.Read(Content);        exit(Content);    end;    local procedure GetNonBuiltInCustomXmlPart(): Text    var        InStr: InStream;        Content: Text;    begin        CalcFields("Custom XML Part");        if not "Custom XML Part".HasValue() then            exit('');        "Custom XML Part".CreateInStream(InStr, TEXTENCODING::UTF16);        InStr.Read(Content);        exit(Content);    end;    local procedure GetBuiltInLayout(): Text    var        ReportLayout: Record "Report Layout";        InStr: InStream;        Content: Text;    begin        if not ReportLayout.Get(Code) then            exit('');        ReportLayout.CalcFields(Layout);        if not ReportLayout.Layout.HasValue() then            exit('');        case Type of            Type::RDLC:                ReportLayout.Layout.CreateInStream(InStr, TEXTENCODING::UTF8);            Type::Word:                ReportLayout.Layout.CreateInStream(InStr);        end;        InStr.Read(Content);        exit(Content);    end;    local procedure GetBuiltInCustomXmlPart(): Text    var        ReportLayout: Record "Report Layout";        InStr: InStream;        Content: Text;    begin        if not ReportLayout.Get(Code) then            exit('');        ReportLayout.CalcFields("Custom XML Part");        if not ReportLayout."Custom XML Part".HasValue() then            exit('');        ReportLayout."Custom XML Part".CreateInStream(InStr, TEXTENCODING::UTF16);        InStr.Read(Content);        exit(Content);    end;    local procedure SetNonBuiltInLayout(Content: Text)    var        OutStr: OutStream;    begin        Clear(Layout);        if Content <> '' then begin            case Type of                Type::RDLC:                    Layout.CreateOutStream(OutStr, TEXTENCODING::UTF8);                Type::Word:                    Layout.CreateOutStream(OutStr);            end;            OutStr.Write(Content);        end;        if CanModify() then            Modify();    end;    local procedure SetNonBuiltInCustomXmlPart(Content: Text)    var        OutStr: OutStream;    begin        Clear("Custom XML Part");        if Content <> '' then begin            "Custom XML Part".CreateOutStream(OutStr, TEXTENCODING::UTF16);            OutStr.Write(Content);        end;        if CanModify() then            Modify();    end;    internal procedure SetLayoutLastUpdated()    begin        "Layout Last Updated" := RoundDateTime(CurrentDateTime);        if CanModify() then            Rec.Modify();    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCanBeModified(var CustomReportLayout: Record "Custom Report Layout"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdateLayout(var LayoutUpdated: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeExportReportLayout(CustomReportLayout: Record "Custom Report Layout"; var DefaultFileName: Text; ShowFileDialog: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeExportSchema(CustomReportLayout: Record "Custom Report Layout"; var DefaultFileName: Text; ShowFileDialog: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCopyRecordOnBeforeInsertLayout(var ToCustomReportLayout: Record "Custom Report Layout"; FromCustomReportLayout: Record "Custom Report Layout")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetNonBuiltInLayout(CustomReportLayout: Record "Custom Report Layout"; var InStream: InStream)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetFileExtension(CustomReportLayout: Record "Custom Report Layout"; var FileExt: Text[4])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnImportLayoutBlob(CustomReportLayout: Record "Custom Report Layout"; var TempBlob: Codeunit "Temp Blob"; FileExtension: Text[30]; XmlPart: Text; DocumentOutStream: OutStream)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnImportLayoutSetFileFilter(CustomReportLayout: Record "Custom Report Layout"; var FileFilterTxt: Text)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInitBuiltInLayout(var CustomReportLayout: Record "Custom Report Layout"; ReportID: Integer; LayoutType: Option)    begin    end;#if not CLEAN28    [IntegrationEvent(false, false)]    [Obsolete('This procedure is obsolete because the procedure LookupLayoutOK is obsoleted.', '28.0')]    local procedure OnLookupLayoutOKOnBeforePageRun(var CustomReportLayout: Record "Custom Report Layout")    begin    end;#endif}