https://community.qlik.com/t5/Reporting-Service-Alerting/Designing-Tabular-Reports-for-PDF-Output-in-Landscape-vs/m-p/2465719#M1080 <P><STRONG>Portrait vs. Landscape: how to control?&nbsp;</STRONG></P> <P>Use the Excel Tabular Reports plugin with the Desktop Excel edition of Microsoft Office 365.&nbsp; The web edition does not include an orientation drop down.</P> <P>In Excel desktop, you will see this menu option.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JonnyPoole_0-1719407676340.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/168508i59C30CE5E9566FC1/image-size/medium?v=v2&amp;px=400" role="button" title="JonnyPoole_0-1719407676340.png" alt="JonnyPoole_0-1719407676340.png" /></span></P> <P>&nbsp;</P> <P>However in the browser, you only see this:</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JonnyPoole_1-1719407767642.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/168510i3F64BBF7D74EDAC2/image-size/medium?v=v2&amp;px=400" role="button" title="JonnyPoole_1-1719407767642.png" alt="JonnyPoole_1-1719407767642.png" /></span></P> <P>In Excel desktop, the page border will show up as hashed lines as below:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JonnyPoole_2-1719407858185.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/168511i6475F5C40F6EBF4B/image-size/large?v=v2&amp;px=999" role="button" title="JonnyPoole_2-1719407858185.png" alt="JonnyPoole_2-1719407858185.png" /></span></P> <P>As you can see in the above screenshot, all columns fit inside the hashed lines so the current orientation will result in all columns appearing on a single page.&nbsp;</P> <P>Note:&nbsp; if you don't see the hashed lines at first, try toggling the setting two times and it should show up.&nbsp;</P> <P>Lastly, if you have found a way in Excel web to visualize page borders, please share and improve the collective knowledge!&nbsp;&nbsp;</P> <P>-Jonny</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 15 Nov 2024 20:59:54 GMT JonnyPoole 2024-11-15T20:59:54Z https://community.qlik.com/t5/Reporting-Service-Alerting/Designing-Tabular-Reports-for-PDF-Output-in-Landscape-vs/m-p/2465719#M1080 <P><STRONG>Portrait vs. Landscape: how to control?&nbsp;</STRONG></P> <P>Use the Excel Tabular Reports plugin with the Desktop Excel edition of Microsoft Office 365.&nbsp; The web edition does not include an orientation drop down.</P> <P>In Excel desktop, you will see this menu option.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JonnyPoole_0-1719407676340.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/168508i59C30CE5E9566FC1/image-size/medium?v=v2&amp;px=400" role="button" title="JonnyPoole_0-1719407676340.png" alt="JonnyPoole_0-1719407676340.png" /></span></P> <P>&nbsp;</P> <P>However in the browser, you only see this:</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JonnyPoole_1-1719407767642.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/168510i3F64BBF7D74EDAC2/image-size/medium?v=v2&amp;px=400" role="button" title="JonnyPoole_1-1719407767642.png" alt="JonnyPoole_1-1719407767642.png" /></span></P> <P>In Excel desktop, the page border will show up as hashed lines as below:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JonnyPoole_2-1719407858185.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/168511i6475F5C40F6EBF4B/image-size/large?v=v2&amp;px=999" role="button" title="JonnyPoole_2-1719407858185.png" alt="JonnyPoole_2-1719407858185.png" /></span></P> <P>As you can see in the above screenshot, all columns fit inside the hashed lines so the current orientation will result in all columns appearing on a single page.&nbsp;</P> <P>Note:&nbsp; if you don't see the hashed lines at first, try toggling the setting two times and it should show up.&nbsp;</P> <P>Lastly, if you have found a way in Excel web to visualize page borders, please share and improve the collective knowledge!&nbsp;&nbsp;</P> <P>-Jonny</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 15 Nov 2024 20:59:54 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Designing-Tabular-Reports-for-PDF-Output-in-Landscape-vs/m-p/2465719#M1080 JonnyPoole 2024-11-15T20:59:54Z https://community.qlik.com/t5/Reporting-Service-Alerting/Designing-Tabular-Reports-for-PDF-Output-in-Landscape-vs/m-p/2465721#M1081 <P>Thanks for sharing!</P> Wed, 26 Jun 2024 13:27:40 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Designing-Tabular-Reports-for-PDF-Output-in-Landscape-vs/m-p/2465721#M1081 F_B 2024-06-26T13:27:40Z