Small and medium business | Business Central, N...

How to use "Custom Report Layouts" within AL?

(0) Share

Report

Posted on by T_Mauser

397 User Group Leader

Hello guys,

does anyone have knowledge or a documentation about how to use custom report layout within AL?

For example:

Different layouts are made for the shipment report 208
On the basis of a condition, which can be created out of the salesheader the right custom layout should be chosen.
Then the layout can be printed, send, ...

if condition "A" then Custom Report Layout "A" (208) should be chosen

if condition "B" then Custom Report Layout "B" (208) should be chosen

Thank you for any information!

Tom

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

www.dynamicsuser.net/.../14

I will open this up to the community in case they have something to add.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

I do not think you can do that for only the layout. Unless you build a RDLC layout that have different sections that you show or hide dependent of the condition you specify.

But you can substitute the whole report and thereby indirectly substituting the layout.

docs.microsoft.com/.../devenv-substituting-reports

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

I also came to think about another solution. You could of course design the report so that it presents totally different datasets depending on the different condition and then keep the layout the same. It basically depends on what you want to achieve in different scenarios.

Was this reply helpful? Yes No
T_Mauser 397 User Group Leader on at

Like (1)

Report
NorthW

Thank you for your advise!

Just found something out about report selection that would fit very well into my scenario. Didn't find out yet how it actually works, because inside the Debugger the local variable has no information about the layout code after it was chosen. - but it works! xD

ReportLaySelection.SetTempLayoutSelected('208-000001'); Report.Run(Report::"Sales - Shipment", true, true, SalesShipHeader);

Ref: https://yzhums.com/25943/

Was this reply helpful? Yes No