locked
using a subreport in multiple parent reports RRS feed

  • Question

  • Is it possible to use a subreport in more than one parent report?

    For example I have a report which lists cases by company, I have another report which lists cases by date. Within both of those reports for each case I want to include a subreport showing activity on that case. The same subreport is used in each report but because a subreport appears to be able to have only one parent I have to copy the subreport to the solution twice under different names to achieve this. Surely it should be possible to reuse a subreport?

    Wednesday, May 7, 2014 9:17 AM

All replies

  • I think this is possible, though I've not tried it. The reason why you have to link a report to its parent in CRM is so that CRM can update the path in the parent report to the sub report.

    So, you could try setting the sub report's paretn to one of the parent reports, then changing it to a different parent report, and the path in the original report may stay correct


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

    Wednesday, May 7, 2014 11:55 AM
    Moderator
  • yes it is possible, see the blog, you will get answer

    http://makdns.blogspot.com/2013/05/dynamics-crm-using-sql-server-reporting.html

    Wednesday, May 7, 2014 3:24 PM
  • I think this is possible, though I've not tried it. The reason why you have to link a report to its parent in CRM is so that CRM can update the path in the parent report to the sub report.

    So, you could try setting the sub report's paretn to one of the parent reports, then changing it to a different parent report, and the path in the original report may stay correct

    Just tried that and it fails.
    Thursday, May 8, 2014 4:14 PM
  • yes it is possible, see the blog, you will get answer

    http://makdns.blogspot.com/2013/05/dynamics-crm-using-sql-server-reporting.html

    Maybe I'm missing something but I can't see anywhere in that how to use a subreport in more than one report.
    Thursday, May 8, 2014 4:15 PM