Report 5623 Insurance Register

Base Application, Microsoft.FixedAssets.Insurance

src/Layers/W1/BaseApp/FixedAssets/Insurance/InsuranceRegister.Report.al191 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.FixedAssets.Insurance;using Microsoft.FixedAssets.FixedAsset;report 5623 "Insurance Register"{    ApplicationArea = FixedAssets;    Caption = 'Insurance Register';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Insurance Register"; "Insurance Register")        {            DataItemTableView = sorting("No.");            PrintOnlyIfDetail = true;            RequestFilterFields = "No.";            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(FORMAT_TODAY_0_4_; Format(Today, 0, 4))            {            }            column(Insurance_Register__TABLECAPTION__________InsuranceRegFilter; TableCaption + ': ' + InsuranceRegFilter)            {            }            column(InsuranceRegFilter; InsuranceRegFilter)            {            }            column(Insurance_Register__No__; "No.")            {            }            column(Ins__Coverage_Ledger_Entry__Amount; "Ins. Coverage Ledger Entry".Amount)            {            }            column(Insurance_RegisterCaption; Insurance_RegisterCaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(Ins__Coverage_Ledger_Entry_DescriptionCaption; "Ins. Coverage Ledger Entry".FieldCaption(Description))            {            }            column(Ins__Coverage_Ledger_Entry__Document_No__Caption; "Ins. Coverage Ledger Entry".FieldCaption("Document No."))            {            }            column(Ins__Coverage_Ledger_Entry__Document_Type_Caption; "Ins. Coverage Ledger Entry".FieldCaption("Document Type"))            {            }            column(Ins__Coverage_Ledger_Entry__Posting_Date_Caption; Ins__Coverage_Ledger_Entry__Posting_Date_CaptionLbl)            {            }            column(Ins__Coverage_Ledger_Entry_AmountCaption; "Ins. Coverage Ledger Entry".FieldCaption(Amount))            {            }            column(Ins__Coverage_Ledger_Entry__Entry_No__Caption; "Ins. Coverage Ledger Entry".FieldCaption("Entry No."))            {            }            column(Ins__Coverage_Ledger_Entry__Insurance_No__Caption; "Ins. Coverage Ledger Entry".FieldCaption("Insurance No."))            {            }            column(Insurance_DescriptionCaption; Insurance_DescriptionCaptionLbl)            {            }            column(Ins__Coverage_Ledger_Entry__FA_No__Caption; "Ins. Coverage Ledger Entry".FieldCaption("FA No."))            {            }            column(FA_DescriptionCaption; FA_DescriptionCaptionLbl)            {            }            column(Insurance_Register__No__Caption; Insurance_Register__No__CaptionLbl)            {            }            column(TotalCaption; TotalCaptionLbl)            {            }            dataitem("Ins. Coverage Ledger Entry"; "Ins. Coverage Ledger Entry")            {                DataItemTableView = sorting("Entry No.");                column(Ins__Coverage_Ledger_Entry__Posting_Date_; Format("Posting Date"))                {                }                column(Ins__Coverage_Ledger_Entry__Document_Type_; "Document Type")                {                }                column(Ins__Coverage_Ledger_Entry__Document_No__; "Document No.")                {                }                column(Ins__Coverage_Ledger_Entry__FA_No__; "FA No.")                {                }                column(FA_Description; FA.Description)                {                }                column(Ins__Coverage_Ledger_Entry_Description; Description)                {                }                column(Ins__Coverage_Ledger_Entry_Amount; Amount)                {                }                column(Ins__Coverage_Ledger_Entry__Entry_No__; "Entry No.")                {                }                column(Ins__Coverage_Ledger_Entry__Insurance_No__; "Insurance No.")                {                }                column(Insurance_Description; Insurance.Description)                {                }                column(Ins__Coverage_Ledger_Entry_Amount_Control33; Amount)                {                }                column(InsuranceAmountTotal; InsuranceAmountTotal)                {                }                column(TotalCaption_Control32; TotalCaption_Control32Lbl)                {                }                trigger OnAfterGetRecord()                begin                    if not FA.Get("FA No.") then                        FA.Init();                    if not Insurance.Get("Insurance No.") then                        Insurance.Init();                    InsuranceAmountTotal := InsuranceAmountTotal + Amount;                end;                trigger OnPreDataItem()                begin                    SetRange(                      "Entry No.", "Insurance Register"."From Entry No.", "Insurance Register"."To Entry No.");                    Clear(Amount);                end;            }        }    }    requestpage    {        layout        {        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './FixedAssets/Insurance/InsuranceRegister.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        InsuranceRegFilter := "Insurance Register".GetFilters();    end;    var        FA: Record "Fixed Asset";        Insurance: Record Insurance;        InsuranceRegFilter: Text;        InsuranceAmountTotal: Decimal;        Insurance_RegisterCaptionLbl: Label 'Insurance Register';        CurrReport_PAGENOCaptionLbl: Label 'Page';        Ins__Coverage_Ledger_Entry__Posting_Date_CaptionLbl: Label 'Posting Date';        Insurance_DescriptionCaptionLbl: Label 'Insurance Description';        FA_DescriptionCaptionLbl: Label 'FA Description';        Insurance_Register__No__CaptionLbl: Label 'Register No.';        TotalCaptionLbl: Label 'Total';        TotalCaption_Control32Lbl: Label 'Total';}