Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Report Printing
Small and medium business | Business Central, N...
Answered

Report Printing

(4) ShareShare
ReportReport
Posted on by Noha Mbi 200
Hello BC Community, 
 
I am finding it a little weird where on running the reports:
sometimes the (data and layout) option appear and 
sometimes it doesn't appear like this:
 
is there any explaination regarding this?
Warm Regards,
Noha - BC Developer
Categories:
Dynamics 365 Business Central
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 14,928 Super User 2025 Season 1 on at
    Report Printing
    Word layouts don’t support exporting both Data and Layout, whereas RDLC and Excel layouts do. This would explain why you’re seeing the option appear inconsistently. Since you mentioned it's a custom Word layout, that's likely the reason it's behaving differently across companies.
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 6,567 on at
    Report Printing
    Hello,
     
    Yes i do agree with @YUN ZHU sir that the Report Layout is RDLC then the data and layout format Option will be there. In case of Word Report Layout it will not be available.
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 81,789 Super User 2025 Season 1 on at
    Report Printing
    This is very simple, the first picture is a rdlc type layout, and the second one should be a word layout.
    For example,
    RDLC:
    Word:
     
    Thanks.
    ZHU
  • Noha Mbi Profile Picture
    Noha Mbi 200 on at
    Report Printing
    Hello all, 
    yes it is a customed word layout, well i thought this was the problem until I tried another company has the same report word layout and it works normal.
    It is weird for real.
    Regards,
    Noha - BC Developer
  • Verified answer
    Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 17,772 Most Valuable Professional on at
    Report Printing
    Hi
    Are the reports customized?
    For example, in which standard report does this option appear?
    Best
    GR
  • Verified answer
    xmp Profile Picture
    xmp 78 on at
    Report Printing
    Hi
     
    I think it has to do with the type of layout used for the report; Word layouts don't support the option of exporting Data and Layout to Excel file, while RDLC and Excel layouts do. So those reports built with Word will have Data only.
     
    Nevertheless I'm not 100% sure this is the reason, I'm answering based a bit on my experience. Maybe you can check it out on the reports you used for the screenshots?
     
    Kind Regards

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans