Visual Studio (BIDS) CRM Reporting with Fetch: Showing a data group with no members RRS feed

  • Question

  • Hello,

    I'm trying to create a matrix report showing the products purchased by an account per year.

    For example, I would like to see:

    Account: Bob's Store

    Since I only have 3 products, I have created three column groups with a filter to only include data that matches the product. My problem is that when there is not any data (as in the case of the Oranges above), the group does not show because there is no data. I would like it to show as I have illustrated.

    If I was writing this in SQL, I would add a record for each product; but I don't believe that can be done with fetch.

    Can anyone offer any assistance?


    Monday, July 7, 2014 7:15 PM