Processing Duplicates

[dpeel2757]

Hey Everyone,
I am a beginner using stimulsoft reports and so far really like but had a question I just can't seem to correct. I have a table (CombinedParts) that contains a list of cabinet parts and their material such as:

Cabinet Top - 3/4 White Mel
Cabinet Bottom - 3/4 White Mel
Cabinet Left Side - 1/4 White Mel
Cabinet Right Side - 1/4 White Mel

For the report I am creating I want a list of just the material. So I assign the material column to the databand and it gives me the following list.

Material

3/4 White Mel
3/4 White Mel
1/4 White Mel
1/4 White Mel

I want to hide or suppress the dulipcate so thought I would be able to use the Processing Duplicates property. When I set it to Hide or Merge I get the following list:

3/4 White Mel
(Blank Row)
1/4 White Mel
(Blank Row)

Is there a way to completely remove that blank row so my report would be displayed like:

3/4 White Mel
1/4 White Mel

I am using Version: 2007.3.100 from December 2007
.Net Framework v2.0.50727

Any help would be great. Thanks in advance.

[Brendan]

Hi,

One way you can accomplish this is to place a GroupHeaderBand above your databand.

Set the condition of the GroupHeaderBand to the material column.

Set the height of the Databand to zero.

Place a text component in the GroupHeaderBand with the expression of your material column e.g {CombinedParts.Material}

[dpeel2757]

Thanks that worked perfectly. I will have to remember that trick. Thanks again.