隐藏重复值 [英] Hiding duplicate value

问题描述

我有一组包含三组的表。所有数据都来自同一个数据集。



第一套显示学区的地区领先学校。



报告需要布局，以便区域领导者记录在分组中的所有子学校的标题中。



问题是小区领先的学校也打印作为小组的第一个记录。



如何保持区域领先的学校信息打印在标题中，但不是每个小组的第一张唱片？



我尝试了什么：

I have a table with three sets of groups. All the data is from the same dataset.

The first set shows the district leading school in the school district.

The report needs to be laid out so the district leader record is in the header with all the sub-schools in the sub-group.

The problem is the district leading school is also printing as the first record in the sub-group.

How do I keep the district leading school info printing in the header but not as the first record in each sub-group?

What I have tried:

=iif(Fields!SchoolDist.Value = Previous(Fields!SchoolDist.Value), True, False)

我也试过这个：

I also tried this:

IIf(fields!SchoolDist.Value) = 1, True,False))

但这个错误带有错误集参数message。



我把它包含在子组的行中，显示我所有的学校记录，基于城市。



我也试过谷歌搜索，堆栈溢出和msdn。

but this errors with a "wrong set of arguments" message.

I included this in the row of the subgroup that displays all my school records based on the city.

I also tried google search, stack overflow, and msdn.

推荐答案

好的 - 我回答了我自己的问题！



以下是有效的：

Ok - I answered my own question!

Here is what worked:

=IIF((Fields!SchoolDist.Value) = 1, true,false)

从我的真假中删除双引号就行了。希望这有助于其他人！

Removing the double quotes from my true and false did the trick. Hope this helps someone else!

这篇关于隐藏重复值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！