Build and Extend Reports MB-820 Practice Questions (Page 4)

Questions 16–20

1. 16application · medium

   A developer is designing a report that lists all customers with their outstanding balances. The report should allow the user to filter by customer group and by a date range for the balance calculation. The developer has defined a data item for the Customer table. What is the best way to implement the date range filter on the request page?

   • AAdd two separate Date fields for start and end dates and calculate the balance in code.
   • BAdd a global variable of type Date and use it in the report's data item filters.
   • CUse the Customer table's built-in Date Filter field on the request page.
   • DAdd a DateFilter field on the request page and use it in the report's data item filters.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   In an AL report object, what is the purpose of a data item?

   • ATo control the formatting of output
   • BTo handle user input on the request page
   • CTo define the layout of the report
   • DTo specify the table that provides the data for the report
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A developer is creating a report for a delivery note. The report must include a header with the company name and address, a body with the shipped items, and a footer with a signature line. The developer wants to use an RDLC layout. What is the correct way to structure the RDLC layout to match the report's data items?

   • AUse a list control for the header and a table for the body, and place the footer in the report footer.
   • BUse separate tablix controls for each data item and place them in the appropriate report sections.
   • CUse a single textbox for the entire report content.
   • DUse a single table in the RDLC layout that contains all fields from all data items.
   Reveal Solution Discussion Select an answer first
5. 19expert · hard

   A developer is creating a report that shows the total sales per customer for a selected period. The report has a data item for the Customer table and a nested data item for the Sales Invoice Header table. The developer wants to calculate the total sales for each customer and display it in the report. The report should also be able to run without a layout (processing-only) to update a table. What is the best way to calculate the total sales?

   • AUse the DataItemLink property to automatically sum the invoice amounts.
   • BUse a global variable to accumulate the total in the OnAfterGetRecord trigger of the Sales Invoice Header data item.
   • CUse the OnPreDataItem trigger of the Customer data item to run a SQL query that calculates the total.
   • DUse the CalcFields function on the Sales Invoice Header data item to calculate the total amount.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A company needs to generate a sales order confirmation document in multiple languages. The report must include a header with the company logo, a body with line items, and a footer with terms and conditions. The developer wants to create a layout that can be easily maintained by a business analyst who does not know AL. Which layout approach should the developer choose?

   • AUse the built-in Excel layout for the report.
   • BCreate a custom layout using AL code that generates the document as a PDF.
   • CCreate a Word layout using the Word layout feature in Business Central.
   • DCreate an RDLC layout using Visual Studio Report Designer.
   Reveal Solution Discussion Select an answer first