Bitta Sheets · Part 15 · 2:24 · YouTube
Print Business Central Reports to PDF from a Sheet
What this video covers
Print a Business Central workbook or save it as PDF, straight from the sheet.
Add a logo, set the print area, orientation, paper, margins and scaling, repeat rows, and build a header and footer with tokens.
Transcript
Marcus wants the sales dashboard on one printed page for Monday, with the Larkspur logo on top. Print and PDF does that from the sheet. Here's how to print a workbook and save it as a PDF.
A print layout sets the page for each sheet: the area, the paper, the scaling, and a header and footer. Print and PDF use it. Start with the logo.
On the Insert tab, choose Image. Give it alternative text, keep its shape, and place it at the top left, two rows by two columns. Turn off the title bar, so the page shows only the picture.
Insert it, and Business Central asks for the file: a PNG, JPEG or GIF, up to two megabytes. The logo now sits on the sheet, at the top left. Select the part of the sheet to print.
Then, on the View tab, open Print Layout. Use the selection as the print area. Choose landscape, Letter paper and narrow margins, and fit every column on one page.
Repeat the top two rows on every page. The header and footer take tokens. Here, the company name in the header, and the workbook name and page numbers in the footer.
Center the page, and save. In the File menu, choose Print or PDF. Control P opens it too. It sums up the page setup.
Print this sheet or all sheets, and name the file. Excel values keeps the numbers as numbers. Download PDF builds the file. One landscape page: the logo, the pivots,
and the charts and the KPI card as pictures, with the company name on top and the page number below. Send, in the same menu, emails the workbook as a PDF, an Excel file, or both.
Use a print layout for any sheet that leaves Business Central, on paper or as a PDF. Next, templates: start new workbooks from one you have already built.
More Bitta Sheets videos
All videos
1:18OverviewEdit Business Central Tables Live in a Spreadsheet
2:08Part 1Edit Business Central Data in an Excel-Style Sheet
3:08Part 2Business Central Bulk Update Without Export and Import
2:50Part 3Business Central Budget in a Spreadsheet, Written Back Live
2:35Part 4Business Central Budget Entry by Department
2:56Part 5Business Central Consolidation: Companies and Account Mapping