Duplicate rows in Report 1:N Relationship RRS feed

  • Question

  • I have to create a Report of Cases(incidents) with its Notes.

    As a Case can have multiple Notes (entities with 1:N relationship) my Report, that is grouped by CaseId, have duplicate rows, similar to this:

    ID                 Title         Title(Note)          Requestor


                        test 1       title of note 1       John Smith

                        test 1       title of note 2       John Smith


                        test case    title of note 1      Paul C

                        test case    title of note 2      Paul C

    How can I remove, when doing the Report or in Excel the duplicate cells values for Title and Requestor?

    In case any solution is regarding to remove rows in Excel, it must be easy to implement, because there are around 2000 exported Cases and I don't see a good way to go check every row for every Case.

    Tuesday, July 15, 2014 8:44 AM


  • Hey,

    In my opinion, you have to developp a non-standard report using SRSS. In the out of the box report, you can not manage the duplicate cells, etc...



    Blog: crmandme.blogspot.com Twitter: https://twitter.com/Ju_li3n "Working hard for something we don't care is called STRESS. Working hard for something we love is called PASSION"

    • Marked as answer by RDevelopment Tuesday, August 19, 2014 12:50 PM
    Thursday, July 24, 2014 2:29 PM