News and Announcements icon

Dynamics 365 CommunityForums Business Central forum How to select the layo...

Business Central forum

Unanswered

How to select the layout of the report on the request page of report in business central

(0) Share

Report

Report

Posted on by PD-23090659-0

18

Hi Team,

I have one option field on the request page of the report, and I want to preview the report based on the layout option selected on the request page in the business central.
let me know, Please let me know if there is any way to do this.

Thanks.

Categories:

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Hein Kruger 462 on at

Like (0)

Report

How to select the layout of the report on the request page of report in business central

Hi,
Its a bit tricky but do able.
You have to save your requestpage option in a Single Instance Code unit or use Isolated Storage to store the option value. Use one of the Report Triggers to save the option value.

In the Code unit ReportManagement (ID: 44) there is a procedure- OnFetchReportLayoutByCode().
You can retrieve your option from the Single instance codeunit in this procedure and modify the layout code to the layout you need to use

.

Alternatively,
Make two reports in one RDLC inside two tables and only show the table that the Report Option Selected.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2

Martin Dráb 228,501 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans