locked
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

    1

                        test 1       title of note 1       John Smith

                        test 1       title of note 2       John Smith

    2

                        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

Answers

  • 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...

    Regards,

    Ju_li3n


    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