第二页报告空白 [英] Second page of report blank

问题描述

我有一个12英寸宽的报告，但报告的设计方式有时可以只打印8英寸。这就是我所做的，该报告有18个可以打印的字段，但由于程序设置了报告，它可以打印5到18列的任何地方。使用过的可以选择要打印的列。

我所做的是将那些不需要打印的列移到左边= 0并将它们设置为visible = false。如果列数适合Portrait，我会得到第二页为空白。第二页上的所有内容都已移至左侧= 0.边距设置正确。

我知道这很令人困惑，但我希望有人会理解它，也许能够给我某个方向。

再次感谢任何建议。

I have a report that is 12 inches wide, however the way the report is designed it can sometimes print only 8 inches. Here''s what I do, the report has 18 fields that can be printed but because of the program sets up the report it can print anywhere from 5 to 18 of the columns. The used can choose what columns they want to print.
What I do is move those columns that don''t need to print to the left = 0 and set them to visible = false. If the number of columns will fit on Portrait I get a second page that is blank. Everything that would have gone onto the second page has been moved to the left = 0. Margins are set correctly.
I know this is confusing but I hope someone will understand it and maybe be able to give me some direction.
Thanks again for any advise.

推荐答案

我找到了答案。我进入设置并将列宽更改为8英寸。这有助于消除第二个空白页面。有没有办法在VBA中执行此操作，我可以动态设置它而不是使其成为标准。

I found the answer to this. I went into the setup and changed the column width to 8 inches. This worked to eliminate the second blank page. Is there a way to do this in VBA that way I could set it on the fly instead of making it a standard.

您可以尝试更改报告的宽度，因为你''隐藏''列。

You could try to change the Width of your report as you ''hide'' columns.

它不是报告的宽度，而是页面设置部分中的列大小。原始列大小是14.东西，我手动将其更改为8工作。我希望能够根据正在打印的字段数更改列大小。

it''s not the width of the report but the Column size that is in the page setup section. the original column size is 14. something and I manually changed it to 8 which worked. I would like to be able to change the column size according to the number of fields are being printed.

这篇关于第二页报告空白的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！