取消水晶报表中的重复值 [英] Supress a duplicated value in crystal report

问题描述

嗨.
我正在做水晶报告.
可以说我在一列中有一个序列号:
|序列号|
124000100,124000101,124000102,124000103,124000104，


我希望水晶报表视图中的值像这样
|序列号|
< 124000>
100,101,102,103,104

表示将相同的值infront分组，归类为一个重复的值.

我该怎么办?

Hi.
I m doing a crystal report.
Lets say i have a serial numbers in a column:
| Serial Number |
124000100,124000101,124000102,124000103,124000104,


I wan the values to be something like this in the crystal report view
| Serial Number |
<124000>
100,101,102,103,104

means that the same value infront is grouped,categorized under one duplicate value.

How may i do this?
Any ideas guys?

推荐答案

您需要在第1列中获得序列号的一部分，在第2列中获得最后3个符号. 我不知道您使用哪个数据库.在MS Access或MS SQL Server中，您可以像这样询问"数据库:

You need to get the part of Serial Number in column1 and the last 3 signs in column2.
I don''t know which database you use. In MS Access or in MS SQL Server you can "ask" your database like this:

SELECT Left([Serial Number],6) As FPartSN, Right([Serial Number],3) As LPartSN
FROM TABLE1;

其中TABLE1是表的名称.

它可以帮助您将重复的值分组.

where TABLE1 is the name of your table.

It whould help you to group duplicated values.

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