您已达到可以一次打开的表数量的限制 [英] You have reached the limit on the number of tables that can be opened at one time

问题描述

打印报告时遇到了一些问题。


我有1个报告和6个子报告，包含我需要打印的报告。我知道有7个嵌套的限制，所以我不在。我认为这个问题是我一次打开的字段数量。该报告是关于入住和搬出阶段的套房状况。


每个报告中都包含大约20个多选字段。 multiselect字段有10个选项，涵盖从G = Good到R = Repair的各种条件。我通常从多选组合框中选择一个或两个选项。


问题：将有一个值列表带字符串结果而不是必须与每个字段相关的多选组合框会改变报告的大小并允许我打印？


如果没有，单个值组合框是否会减小尺寸以便我可以打印？


我还有什么不考虑的？关系或任何其他事情与它有什么关系吗？


我能做的一件事就是修改设计，有一点我不能减少字段的数量都需要在那里？我能做什么？谢谢

I have a bit of a problem printing a report.

I have 1 report and 6 subreports comprising the report that I need to print. I know there is a limit of 7 nested so I am under. The problem that I think it is = the amount of fields that I have open at one time. The report is about the condition of a suite at move-in and move-out stage.

Each report has about 20 multiselect fields in it. The multiselect field have 10 options that covers a range of condition from G=Good to R=Repair. I usually select one or two options from the multiselect combo box.

Question: Would having a value list "with string result" instead of a multi select combo box that must be related to each field make a difference in the size of the report and allow me to print?

If not, would a single value combo box reduce the size so I can print?

What else am I not thinking about? Does relationship or any other thing has anything to do with it?

One thing I can do is modify the design, one thing I can''t is reduce the amount of fields as they all need to be there? what can I do? thanks

推荐答案

这有点模糊......我能用有限的信息给你的唯一建议是我通常会把我的数据合并到一起子查询尽可能。可能只是子报表都在运行总共引用太多表的查询。如果你可以通过将表数据组合成查询来消除部分或全部子报表，那么你可能会有更好的运气。

That''s kind of vague... the only advice I can give you with limited information is that I generally look at combining my data into as few subqueries as possible. It may just be that the subreports are all running queries that reference too many tables in total. If you could eliminate some or all of the subreports by combining the table data into queries, you may have better luck.

我真的不知道如何更好地解释它？


报告父级的记录源引用了4个表格。

所有其他6个子报告从创建它们的表中获取值。没有查询只是一个过滤器。

I don''t really know to explain it better?

The report parent has record source referring to 4 tables.
All the other 6 Sub- report takes value from the table in which they were created. no query just a filter.

我刚刚检查了一些东西，我不知道它是否重要但是这里是：


报告中的所有字段及其6个子报表共有130个字段。这些字段都不是指包含130个字段中的100个字段的LocCodeT表。如果他们都有关系会有所作为吗？ （将多选组合值与报告中的字段相关联？）

I''ve just checked on something and I don''t know if it matters or not but here it is:

All my fields in the report and its 6 subreport have about 130 fields all together. None of those field refer to the LocCodeT table that contain the value for the 100 out of 130 fields. would that make a difference if they were all related? (relating the multiselect combo value to the fields in my report?)

这篇关于您已达到可以一次打开的表数量的限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！