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

How to use "Custom Report Layouts" within AL?

(0) Share

Report

Posted on by T_Mauser

401 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)

Sort by

Suggested answer

Marco Mels Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

IB-29041624-0 1,191 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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

IB-29041624-0 1,191 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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 401 User Group Leader on at

Like
a
(1)

Report
Copy link

Link copied!
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

Join the conversation

Community site session details

How to use "Custom Report Layouts" within AL?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

How to use "Custom Report Layouts" within AL?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates