（水晶报表）在某些详细信息后断开页面？ [英] (Crystal Reports) Break page after certain # of details?

问题描述

我正在尝试创建一个以下列方式工作的支票写作报告：

• 每页的第一部分


• 报告每页的中间部分将是实际支票，包括收款人，付款人，金额，地址等。

$ b $
b

报告的每一页都将包含10个订单项例如，如果我们正在写一个将包含12个项目的支票，则报表将有两个页面：

• 第一页将有前10个订单项（网页的第一部分和最后一部分）以及金额为0.00的支票。


• 第二页将包含其他2个订单项两个部分）添加检查的实际数据。基本上，唯一有效的检查将是报告最后一页上的一个。

我的想法是有一个DataSet表，一个用于订单项，另一个用于检查数据。并且在检查表中，每页有一行。因此，在前面的示例中，我将在行项目表中有12行，在检查表中有2行（一个将具有0.00作为金额，另一个将具有实际的X.XX量）。
我还在考虑通过支票分组，并在每次检查后添加分页符，但我不知道如何确保每个页面只有10个订单项。

有关如何处理此问题的任何帮助或新想法吗？

谢谢！

解决方案

要使每页显示10条记录，请执行以下操作：

1. 在设计视图中报告




2. 右键单击详细信息部分并选择部分专家

   确保在段专家对话框中选择详细信息部分。选中新页面之后框




3. 点击复选框右侧的公式编辑器按钮。




4. 如果Remainder（RecordNumber，10）= 0，则输入以下公式

else false

6.单击保存并关闭，然后单击确定。

I am trying to create a check writing report that will work in the following way:

• The first section of each page of the report will include all line items that will be added into the check.
• The middle section of each page of the report will be the actual check, with Payee, payer, amount, address, etc.
• The last section of each page of the report will simply be a copy of the first section.

Each page of the report will include 10 line items AT MAX. For example, if we are writing a check that will account for 12 items, the report will have two pages:

• The first page will have the first 10 line items (in both the first section and last section of the page) and a check with the amount of 0.00.
• The second page will have the other 2 line items (in both sections) PLUS the actual data for the check. Basically, the only valid check will be the one on the last page of the report.

My idea is to have a DataSet with two tables, one for the line items and the other one for the check data. And in the check table, have one row per page. So in the previous example, I would have 12 rows in the line items table, and 2 rows in the checks table (one would have 0.00 as the amount, and the other one would have the actual X.XX amount). I was also thinking about grouping by check, and add a page break after each check, but I am not sure on how to make sure that only 10 line items are in each page.

Any help, or new ideas on how to approach this matter?

Thanks!

解决方案

To make it show 10 records per page do the following

1. Open the report in Design View

2. Right click on the Details section and select Section Expert

3. Make sure the Details section is selected in the Section Expert dialog box. Check the box that says "New Page After"

4. Click the formula editor button to the right of the checkbox.

5. Enter the following formula

if Remainder (RecordNumber, 10) = 0 then true else false

6.Click Save and Close and then click OK.

这篇关于（水晶报表）在某些详细信息后断开页面？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！