report design problem

edited 10:19AM in FastReport .NET
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.
1.png 22.6K
2.png 31.7K

Comments

  • edited 10:19AM
    Hello,

    You may use the Duplicates property of the Text object:
    http://fast-report.com/documentation/UserM...eatedvalues.htm
  • edited April 2010
    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
    
  • edited 10:19AM
    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.
  • edited 10:19AM
    HI,

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

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.