web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by 20
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.
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    92,073 Super User 2025 Season 2 on at
    How to select the layout of the report on the request page of report in business central
    Hi, sorry, I may not have fully understood your question, this should be standard functionality.
    More details: Business Central 2022 wave 2 (BC21): Choose the report layout on request page (Select a report layout before printing)
    PS:
    Dynamics 365 Business Central: How to set the default report layout via AL (“Report Layout List 2000000234”)
    Dynamics 365 Business Central: Can we change default options/filters on the request page of Report???
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Hein Kruger Profile Picture
    628 on at
    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,878

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,390

#3
Sumit Singh Profile Picture

Sumit Singh 2,884

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans