locked
Query to display unique cases which has N:N relationships RRS feed

  • Question

  • Hello,

    I am developing a SSRS report for CRM 2013 which should filter the cases as per the input parameters given for the report.

    Expected Output:

    It needs to show the unique Cases for all (AND) the input parameters selected where some of the input parameters are under N:N relationship.

    I have written a query taking the base table as Case and did a left join for all the N:N Relationships and got the data required in my base table. While doing this, it is showing the duplicate cases in the results set as per the join given. How can I get the unique cases results set with the respective N:N entities data tied to each record?

    Any help is greatly appreciated.

    Thanks.

    Wednesday, June 15, 2016 3:24 PM