Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When I send my query results to a Standard Report, the columns are wide and spreading across more than one page. How can I get them to all on one page automatically?

April 26, 2017automatically columns page query report results send spreading standard wide

0

Posted

When I send my query results to a Standard Report, the columns are wide and spreading across more than one page. How can I get them to all on one page automatically?

1 Answer

0

Posted

Answer -In BI/Query 7.0 and prior, the width of standard report columns is determined by the largest column in the query and then calculated based on the Windows Font you have specified under Tools>Preferences>Windows Fonts. If your columns are being created wide and do not all fit on one page, you can adjust the font so that the columns are created smaller. Usually Arial Narrow is the best font to choose in this situation. Try 10 and then start reducing the number until you see the columns all fit on one page.