Open the downloaded excel file and you will get an excel with two sheets: Data and Report Metadata. We can do this by running the report and click Send To > Microsoft Excel Document (data only). To make an excel layout, we need to export the report raw data to excel first. We are going to make an excel layout from this report. This is the standard Inventory Order Details layout. Let’s try to create one using Inventory Order Details. With Excel layouts for Business Central reports, users can now create and edit report layouts simply by using the full capabilities in Excel such as sliders, diagrams, charts, and pivot tables. Excel layouts work the same way as Word and RDLC layouts in that they can be edited and saved back again into Business Central. Give it a try!!!□ Believe your solution will be better.Since Business Central 2022 Wave 1 (BC20), we have the ability to use Excel Layout for reporting. Once you know this information, I think it should be easy to do. Key method: ReportLayoutSelection.SetTempLayoutSelected(Code) Īnd the Code is the primary key in table 9650 “Custom Report Layout”. As you know, we can run different layout files directly on this page. You can find clues on page 9650 “Custom Report Layouts”. Report.Run(Report::"Standard Sales - Order Conf.", true, true, SalesHeader) ReportLayoutSelection.SetTempLayoutSelected('1305-000003') ReportLayoutSelection.SetTempLayoutSelected('1305-000004') ReportLayoutSelection.SetTempLayoutSelected('1305-000002') ZYLayouts: Label 'ZY Test Layout 01,ZY Test Layout 02,ZY Test Layout 03' ĬurrPage.SetSelectionFilter(SalesHeader) ReportLayoutSelection: Record "Report Layout Selection" Source Code: pageextension 50105 SalesOrderListExt extends "Sales Order List" Then, create a new action in the Sales Order List and add the following code. In fact, there is an easy way to do this before the report is run (before the Request Page is opened).įor example, I created three different layouts for Report 1305 Sales – Confirmation. Developers also need to maintain a lot of report code. But, if there are five, ten, or more layouts, do you have to add that many actions? The user might not be able to remember what each button is used for either. In general, you might create two reports, each with a different layout, and then add two actions to the page to print different reports depending on the situation. In Report Selection – XXXX features, we can specify special reports and layout files according to Usage.įinally, we can also set up different reports and layouts separately for customers or vendors.īut this does not solve the problem if the same customer, the same report, needs to print different layouts according to different situation? What should we do? We can manage and select the default layout for the report in the Report Layout Selection page.Īnd from Business Central 2022 wave 1 (BC20), Microsoft has given us another user-friendly page for report layout administr a tion (page 9660 “Report Layouts”) to manage report layouts. Recently I was asked a very interesting question, is there any way to select a layout file when printing a report?Īs you might know, we have powerful report management features in Business Central.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |