Hack: 100 in 1 Report - Dynamic report layouts in Business Central

[rishichourey]

Custom Report Layout is beautiful functionality given by Business Central.
We have used the same report ID of Sales Invoice and created 6 different formats of Sales Invoices for 6 countries :), Based on the company it will display to the corresponding layout only.

[chirangaranasinghe]

As a beginner, from which video I should start to learn ? is there any playlist for beginners. thank you

[cioadvise]

Eric, my video studio does not show the AL File Wizard. Do I have to install anything to get that to work? I have run AL!Go already. Thanks in advance.

[hugo_alves]

This is a video i'd like to thumbs up a hundred times if i could!

[anada]

Thank you, Erik.
Microsoft should make your solution as part of the standard report object.

[IMAS-vfur]

Nice tutorial. Do you know how to change the report layout programmatically which is from "Report Layout List" table?
Thanks

[artemkeller]

Hey Erik! Thanks for this video. That helped. One thing - this method involves manually uploading layouts in "custom layouts" each time you want to modify layout. We are using "rendering" section inside report extensions to import different layouts. My question is - is it possible to choose which report to run by uploading them this way? Inside Report Extension it looks like this:

rendering
{
layout("My Sales Order Confirmation")
{
Type = RDLC;
LayoutFile = 'My Sales Order Confirmation.rdl';
}
layout("My Sales Order Confirmation Email Text")
{
Type = Word;
LayoutFile = 'My Sales Order Confirmation Email Text.docx';
}

layout("My Sales Draft Invoice")
{
Type = RDLC;
LayoutFile = 'My Sales Draft Invoice (for Sales Order).rdl';
}
}

[ricardo]

Hi Erik, thank you for the useful videos. Is it possible to reduce the image size from your video? Sometimes I can't see so well the Problems notification area on VS Code. Thanks

[ercanismail]

I'm just starting my journey of learning development in AL. I would be tempted to copy the original request page and add a section there which lists the available layouts for the user to select plus the ability to make a new one.
Great video as always!

[Genius]

Thanks Eric. Great Video. I tried using one report with multiple layouts like you did, however for some reason after running the report it showed me the layout but it also changed all the layouts of standard reports.

[UweMicha]

Hi Erik, is it possible to make sub reports in a rdlc layouts for BC? Did you already made a video about that? I did't find it... In the ReportBuilder you can add a sub report but it ask for a URL to a given report.... (???)

[danykanaan]

Hi Erik thank you for your videos. I started Coding with AL 2 month ago and you are of great help.

But saddly i have one problem with this solution right now.
If I have set the SaveValues property in the request page to true it will run through the OnInit trigger again when clicking preview and open the Selection page again and then does not give me a proper preview of the report, but instead downloads a file with no doctype.
I have set the SaveValues so the requestpage does not close when previeweing the document.
Is there a solution to this problem? Should i use a global trigger instead of the onint (Like SelectReportLayoutCode)?

[businesscentral-explained]

Thanks for the video!
Is there any efficient way i can make a page action run a standard report - f.ex. the standard sales order confirmation with a specific layout? In that case i can not modify the init trigger in the report. Or is the only way i can do that by duplicating the report?

[jnaneshc]

can you please do the report amount in words for multiple currencies without hardcoding
please

[sonnyjim]

Hi Eric, Great video and tried to change the standard Sales Invoice by changing trigger after creating a copy;
trigger OnInitReport()

var
RLS: Record "Report Layout Selection";//*select custom layout custom
begin
//custom code
Layout.Setrange("Report ID", 61306);//Layout declared as a variable at the end of this page
if page.RunModal(61306, Layout) = action::LookupOK then

else
Error('Please select layout');
only thing is once the you select the layout from the new page "Select Layout" it goes to the standard request page and then when run the report (preview) it goes back to "Select Layout" page again and then when selected (for the second time), report exports to PDF

[faaizahmed]

Dear Erik, can i preview the report without using run request page??

[linojrasmolo]

Hi Eric,
Can i directly call this custom layout using an action button?

[antdte]

Layout is one of the easiest part if customer asks for changes.
The main issue for customers is change of logic and grabbing fields from other tables (or even from existing if they weren't added to dataset).

I hope MS provide some good looking Report Extension (they promised for next global BC release afair).