A2007：子报表的子报表的位置和维度 [英] A2007: subreport's subreport's position and dimensions

问题描述

在A2007中我有一个复杂的报告（每个记录4页），有几个子报告。某些子报表中有嵌套的子报表。那些嵌套的子报表的属性CanGrow设置为TRUE。我需要
在这些子报告下通过空白空间，例如：

in A2007 I have a complex report (4 pages for each record) with several subreports. There are nested subreports in some of the subreports. Those nested subreports' property CanGrow is set to TRUE. I need to struck through empty space under such subreports, eg.:

http://www.streamline.cz/download /access/Blog/SubreportStrikeThrough1.jpg

http ：//www.streamline.cz/download/access/Blog/SubreportStrikeThrough2.jpg

图片显示报告的第4页。所有下面的"KATALOGOVY LIST strana 4"都是一个子报告。
$
"Školnívzdělávacíprogramvročníkuveveškolnímroce"中的部分："和"Navštěvoval（a）školu（adresa，od）："是嵌套的子报告。

The images show page 4 of the report. All below "KATALOGOVY LIST strana 4"is a subreport.
Parts under "Školní vzdělávací program v ročníku a ve školním roce:" and "Navštěvoval (a) školu (adresa, od):" are nested subreports.

奇怪的是我得到子报告的Y维（WindowHeight）不正确，例如：

The weird thing is that I get incorrect Y dimension (WindowHeight) of a subreport, eg:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim x As Long

   x = Me![rptZakKatListZS4].Report![rptZakKatList2stupen-Skoly].Report.WindowHeight
   Debug.Print "Me![rptZakKatListZS4].Report![rptZakKatList2stupen-Skoly].Report.WindowHeight = " & x & _
               " twips = " & Format(x / 567, "0.000") & " cm"

End Sub

结果为NEGATIVE（！）数字：

The result is NEGATIVE (!) number:

我！[rptZakKatListZS4] .Report！[rptZakKatList2stupen-Skoly] .Report.WindowHeight = -30976 twips = -54,631 cm

Me![rptZakKatListZS4].Report![rptZakKatList2stupen-Skoly].Report.WindowHeight = -30976 twips = -54,631 cm

我一定是做错了什么。请指出正确的方向。

非常感谢您提前。

I must be doing something wrong. Please, point me to the right direction.
Thank you very much in advance.

P.S。我希望WindowTop是正确的。由于WindowHeight值不正确，我还没有尝试过。

P.S. I hope that WindowTop is correct. I haven't tried it yet due to incorrect WindowHeight value.

PS我以前的帐户是弗拉基米尔Cvajniga，但我不能再访问它了，请参阅http://social.msdn.microsoft.com/Forums/office/en-US/5b1284eb-a74f-4c55-9d4c-d6fb6eb25d48/fatal-how- can-i-login-to-my-account？forum = Offtopic＃5b1284eb-a74f-4c55-9d4c-d6fb6eb25d48。

P.S. My former account was Vladimir Cvajniga but I can't access it anymore, see http://social.msdn.microsoft.com/Forums/office/en-US/5b1284eb-a74f-4c55-9d4c-d6fb6eb25d48/fatal-how-can-i-login-to-my-account?forum=Offtopic#5b1284eb-a74f-4c55-9d4c-d6fb6eb25d48.

推荐答案

绝望地，

Hi Desperately,

我根据你的描述进行了测试，我可以重现你的问题。我发现如果高度值小于4.5'，则WindowHeight为正数，如果大于5'，则WindowHeight为负数（！）数字。

I made a test with your description, and I could reproduce your issue. I found that if value of height was less than 4.5’, the WindowHeight was positive number, if it larger than 5’, the WindowHeight was NEGATIVE (!) number.

由于您已设置CanGrow为True，我建议您将子报表的高度设置为小于4.5'以解决此问题。

Since you have set CanGrow is True, I suggest you set the height of subreport less than 4.5’ to work around this issue.

最佳此致，

Best Regards,

Edward

这篇关于A2007：子报表的子报表的位置和维度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！