locked
CRM 2011 onpremise FetchXML SSRS reports RRS feed

  • Question

  • HI All,

    I want to create complex report in CRM 2011, with multiple fetchxml datasets and display the data in a single tablix. Is there a way to design the reports with multiple datasets?

    For Eg: I want to design a report (daily, MTD, YTD) that shows the forecasted revenue and the actual revenue for all the acctounts. I am using a custom entity to track the forecasted revenue for a given FY and the actuals will come from the invoices. There is a report parameter that takes the FY and when the report is run, all the daily, MTD, YTD values should be shown for the current FY and the previoues FY.

    Any help would be greatly appreciated.

    Thank you,

    Naresh.

    Wednesday, February 19, 2014 11:13 AM

All replies

  • As far as I know, a tablix can only be linked to one dataset. If you want to display all the data in one tablix, then you will probably need to return all the data in one dataset. This should be possible if you use a SQL datasource (as you can use UNION clauses in SQL), but may not be possible with FetchXML

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Wednesday, February 19, 2014 10:03 PM
    Moderator