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

Preview the Report based on selection of option on request page in business central

(1) Share

Report

Posted on by PD-23090659-0

Hi All,

I have an option field labeled "Report" on the request page. If "Sample1" is selected, I would like to display the Sample1 layout during the report preview. Conversely, if "Sample2" is selected, I would like the Sample2 layout to be shown. Is there a way to implement this functionality?

Thank you.

All responses (3)

Answers (0)

Suggested answer

Khushbu Rajvi. 4,744 on at

Like (2)

Report

Preview the Report based on selection of option on request page in business central

Hope it's also helps: https://yzhums.com/40025/

https://yzhums.com/39955/
gdrenteria 12,290 Most Valuable Professional on at

Like (1)

Report

Preview the Report based on selection of option on request page in business central

Hi

I hope this can help you

Dynamics 365 Business Central: Select a report layout before printing | Dynamics 365 Lab (yzhums.com)

Best

GR
Suggested answer

Khushbu Rajvi. 4,744 on at

Like (1)

Report

Preview the Report based on selection of option on request page in business central

Why are you creating a separate request field for this? Since the Report Layout section on the request page is distinct from your custom fields, it is not possible to programmatically change the layout using AL code directly.
In Business Central, the layout selection on the report request page cannot dynamically control the layout used for rendering the report based on a custom option field.
However, you can work around this limitation by either using multiple reports or guiding the user to select the layout manually from the Report Layout Selection page before running the report.

select 3 dots. change layout and run report.