Report 111 Customer - Top 10 List
src/Layers/W1/BaseApp/Sales/Reports/CustomerTop10List.Report.al303 lines, Copyright (c) Microsoft Corporation. MIT
#if not CLEAN28// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Sales.Reports;/// <summary>/// Lists top customers ranked by sales or balance amounts with graphical chart representation. This report is obsolete./// </summary>using Microsoft.Sales.Customer;using Microsoft.Utilities;using System.Utilities;report 111 "Customer - Top 10 List"{ ApplicationArea = Basic, Suite; Caption = 'Customer - Top 10 List (Obsolete)'; PreviewMode = PrintLayout; UsageCategory = ReportsAndAnalysis; DataAccessIntent = ReadOnly; ObsoleteState = Pending; ObsoleteReason = 'This report has been replaced by the report Customer - Top List (Excel). This report will be removed in a future release.'; ObsoleteTag = '28.0'; DefaultRenderingLayout = RDLCLayout; dataset { dataitem(Customer; Customer) { DataItemTableView = sorting("No."); RequestFilterFields = "No.", "Customer Posting Group", "Currency Code", "Date Filter"; trigger OnAfterGetRecord() var IsHandled: Boolean; begin IsHandled := false; OnBeforeCustomerOnAfterGetRecord(Window, Customer, TempCustomerAmount, ShowType, NoOfRecordsToPrint, TotalSales, TotalBalance, ChartTypeNo, ShowTypeNo, IsHandled); if IsHandled then CurrReport.Skip(); Window.Update(1, "No."); CalcFields("Sales (LCY)", "Balance (LCY)"); if ("Sales (LCY)" = 0) and ("Balance (LCY)" = 0) then CurrReport.Skip(); TempCustomerAmount.Init(); TempCustomerAmount."Customer No." := "No."; if ShowType = ShowType::"Sales (LCY)" then begin TempCustomerAmount."Amount (LCY)" := -"Sales (LCY)"; TempCustomerAmount."Amount 2 (LCY)" := -"Balance (LCY)"; end else begin TempCustomerAmount."Amount (LCY)" := -"Balance (LCY)"; TempCustomerAmount."Amount 2 (LCY)" := -"Sales (LCY)"; end; TempCustomerAmount.Insert(); if (NoOfRecordsToPrint = 0) or (i < NoOfRecordsToPrint) then i := i + 1 else begin TempCustomerAmount.Find('+'); TempCustomerAmount.Delete(); end; TotalSales += "Sales (LCY)"; TotalBalance += "Balance (LCY)"; ChartTypeNo := ChartType; ShowTypeNo := ShowType; end; trigger OnPreDataItem() begin Window.Open(Text000); i := 0; TempCustomerAmount.DeleteAll(); end; } dataitem("Integer"; "Integer") { DataItemTableView = sorting(Number) where(Number = filter(1 ..)); column(SortingCustomersCustDateFilter; StrSubstNo(Text001, CustDateFilter)) { } column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(RankedAccordingShowType; StrSubstNo(Text002, SelectStr(ShowType + 1, Text004))) { } column(ShowTypeNo; ShowTypeNo) { } column(ChartTypeNo; ChartTypeNo) { } column(CustFilter_Customer; Customer.TableCaption + ': ' + CustFilter) { } column(CustFilter; CustFilter) { } column(No_Customer; Customer."No.") { IncludeCaption = true; } column(Name_Customer; Customer.Name) { IncludeCaption = true; } column(SalesLCY_Customer; Customer."Sales (LCY)") { IncludeCaption = true; } column(BalanceLCY_Customer; Customer."Balance (LCY)") { IncludeCaption = true; } column(TotalSales; TotalSales) { } column(TotalBalance; TotalBalance) { } column(CustomerTop10ListCaption; CustomerTop10ListCaptionLbl) { } column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl) { } column(TotalCaption; TotalCaptionLbl) { } column(TotalSalesCaption; TotalSalesCaptionLbl) { } column(PercentofTotalSalesCaption; PercentofTotalSalesCaptionLbl) { } trigger OnAfterGetRecord() begin if Number = 1 then begin if not TempCustomerAmount.Find('-') then CurrReport.Break(); end else if TempCustomerAmount.Next() = 0 then CurrReport.Break(); TempCustomerAmount."Amount (LCY)" := -TempCustomerAmount."Amount (LCY)"; Customer.Get(TempCustomerAmount."Customer No."); Customer.CalcFields("Sales (LCY)", "Balance (LCY)"); if MaxAmount = 0 then MaxAmount := TempCustomerAmount."Amount (LCY)"; TempCustomerAmount."Amount (LCY)" := -TempCustomerAmount."Amount (LCY)"; OnAfterIntegerOnAfterGetRecord(TempCustomerAmount); end; trigger OnPreDataItem() begin Window.Close(); end; } } requestpage { AboutTitle = 'About Customer - Top 10 List (Obsolete)'; AboutText = 'Review a summary of customers with the most transactions within a selected period to identify sales trends, upcoming collectable debts, and major revenue sources in the company.** This report is obsolete and will be removed in a future release.** Please refer to the report documentation for alternative ways to retrieve this information.'; SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(Show; ShowType) { ApplicationArea = Basic, Suite; Caption = 'Show'; OptionCaption = 'Sales (LCY),Balance (LCY)'; ToolTip = 'Specifies how the report will sort the customers: Sales, to sort by purchase volume; or Balance, to sort by balance. In either case, the customers with the largest amounts will be shown first.'; } field(NoOfRecordsToPrint; NoOfRecordsToPrint) { ApplicationArea = Basic, Suite; Caption = 'Number of Customers'; ToolTip = 'Specifies the number of customers that will be included in the report.'; trigger OnValidate() begin if NoOfRecordsToPrint <= 0 then Error(NoOfRecordsToPrintErrMsg); end; } field(ChartType; ChartType) { ApplicationArea = All; Caption = 'Chart Type'; OptionCaption = 'Bar chart,Pie chart'; ToolTip = 'Specifies the chart type.'; Visible = ChartTypeVisible; } } } } actions { } trigger OnInit() begin ChartTypeVisible := true; end; trigger OnOpenPage() begin if NoOfRecordsToPrint = 0 then NoOfRecordsToPrint := 10; end; } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Sales/Reports/CustomerTop10List.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } trigger OnPreReport() var FormatDocument: Codeunit "Format Document"; begin CustFilter := FormatDocument.GetRecordFiltersWithCaptions(Customer); CustDateFilter := Customer.GetFilter("Date Filter"); end; var TempCustomerAmount: Record "Customer Amount" temporary; Window: Dialog; CustFilter: Text; CustDateFilter: Text; ShowType: Option "Sales (LCY)","Balance (LCY)"; NoOfRecordsToPrint: Integer; MaxAmount: Decimal; i: Integer; TotalSales: Decimal; TotalBalance: Decimal; ChartType: Option "Bar chart","Pie chart"; ChartTypeNo: Integer; ShowTypeNo: Integer; ChartTypeVisible: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Sorting customers #1##########'; Text001: Label 'Period: %1'; Text002: Label 'Ranked according to %1';#pragma warning restore AA0470 Text004: Label 'Sales (LCY),Balance (LCY)';#pragma warning restore AA0074 CustomerTop10ListCaptionLbl: Label 'Customer - Top 10 List'; CurrReportPageNoCaptionLbl: Label 'Page'; TotalCaptionLbl: Label 'Total'; TotalSalesCaptionLbl: Label 'Total Sales'; PercentofTotalSalesCaptionLbl: Label '% of Total Sales'; NoOfRecordsToPrintErrMsg: Label 'The value must be a positive number.'; /// <summary> /// Initializes the report request options for the Customer Top 10 List report. /// </summary> /// <param name="SetChartType">The chart type option for visualization.</param> /// <param name="SetShowType">The show type option (sales or balance).</param> /// <param name="NoOfRecords">The number of top customers to include.</param> procedure InitializeRequest(SetChartType: Option; SetShowType: Option; NoOfRecords: Integer) begin ChartType := SetChartType; ShowType := SetShowType; NoOfRecordsToPrint := NoOfRecords; end; [IntegrationEvent(false, false)] local procedure OnBeforeCustomerOnAfterGetRecord(var Window: Dialog; var Customer: Record Customer; var TempCustomerAmount: Record "Customer Amount" temporary; var ShowType: Option; var NoOfRecordsToPrint: Integer; var TotalSales: Decimal; var TotalBalance: Decimal; var ChartTypeNo: Integer; var ShowTypeNo: Integer; var SkipDataItem: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterIntegerOnAfterGetRecord(var TempCustomerAmount: Record "Customer Amount" temporary) begin end;}#endif