report design problem

Jiasheng

HI,

My data structure cf 1.png.

I want to merge data cell cf 2.png.

Is there any examples you can provide ?

please help,thank you.

AlexTZ

Hello,

You may use the Duplicates property of the Text object:
http://fast-report.com/documentation/UserM...eatedvalues.htm

Jiasheng

AlexTZ wrote: »

Hello,

You may use the Duplicates property of the Text object:
http://fast-report.com/documentation/UserM...eatedvalues.htm

HI,

I have seen examples you provided, it works well.

But when I want to merge the field according to other field's name

is "subject_id" cf post 1, 2.png.

The same subject_id I want to merge ,different subject_id I want to show.

how do I type the code snippet?

please help,thank you.



there is my code snippet

'dt.row(i).item(4) is subject_id's value

 For i As Integer = 0 To dt.Rows.Count - 1
            For j = i + 1 To dt.Rows.Count - 1
                If dt.Rows(i).Item(4) = dt.Rows(j).Item(4) Then
                    subject_name.Duplicates = Duplicates.Merge
                    subject_id.Duplicates = Duplicates.Merge
                    subcredit.Duplicates = Duplicates.Merge
                Else
                    subject_name.Duplicates = Duplicates.Show
                    subject_id.Duplicates = Duplicates.Show
                    subcredit.Duplicates = Duplicates.Show
                    i = j - 1
                    Exit For
                End If
            Next
        Next

AlexTZ

This property has no effect if you use TableObject. To hide duplicates in this case, you need to use the script. See the attached report, you may run it in the Demo.exe.

Jiasheng

HI,

thanks for your help. [img]style_emoticons/<#EMO_DIR#>/laugh.gif" style="vertical-align:middle" emoid="" border="0" alt="laugh.gif" /> According to your example I had write the function I want.[/img]