没有下面的记录时取消组标题 [英] Suppress Group Header when no record below

查看:47
本文介绍了没有下面的记录时取消组标题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

当页眉页中没有记录时,是否可以在3/8页中隐藏页眉。

Is it possible to suppress Group header in page 3/8 when group header no record in this page.

推荐答案

在这里可以解决该问题,但是您必须进行其他调整才能使组标题在每个页面重复

Here it goes a solution for the problem, but you will have to adjust something else to keep the group header repeating for each page.

主要思想是将组标题模拟为详细信息节,并仅将其与组的第一条记录一起显示。

The main idea is to simulate the group header as a detail section and show it only together with the first record of the group.

逐步操作:


  1. 创建一个运行总计字段以计算组中的记录:summary =任何,摘要的类型=计数,为每条记录评估,在组更改时重置。假设此公式的名称为{#RTotal0}。

  2. 禁止显示组标题。

  3. 在当前详细信息部分上方创建另一个详细信息部分。因此,您将拥有 Details a和 Details b。

  4. 打开部分专家,选择 Details a部分,打开公式编辑器以显示 Suppress选项,然后将其放入公式: {#RTotal0}> 1 。这意味着该部分仅在组的第一条记录中显示。

  5. 打开该部分专家,选择 Details部分( Details a和 Details的父级b),然后选中保持在一起选项。

  1. Create a running total field to count the records in your group: field to summarize = any, type of summary = count, evaluate for each record, reset on change of group. Let's assume the name of this formula is {#RTotal0}.
  2. Suppress your group header.
  3. Create another detail section above your current detail section. So, you will have "Details a" and "Details b". The section "Details a" will simulate the group header.
  4. Open the section expert, choose the section "Details a", open the formula editor for the option "Suppress", and put this formula: {#RTotal0} > 1. That means that this section will be shown only for the first record of the group.
  5. Open the section expert, choose the section "Details" (the parent of "Details a" and "Details b") and check the option "keep together".

这将解决您的问题。但是知道组标题不会为每个页面重复。一种方法是:

This will solve your problem. But know the group header will not repeat for each page. One way to do that:


  1. 打开组标题选项的节专家,打开抑制选项的公式编辑器,公式: {#RTotal0} = 1 。这意味着该组标题将取消显示首字母缩写,但在分页符显示后,它将显示(如果您将组设置为打印每页的组标题)。

  1. Open the section expert for the group header option, open the formula editor for the option "Suppress", put the formula: {#RTotal0} = 1. It means that the group header will suppress initialy, but after a page break, it will show (if you the group is set to print the group header for each page).

但是您可能需要根据情况进行调整。

But you may need to adjust it for your case.

这篇关于没有下面的记录时取消组标题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆