locked
FilteredReportEntity - Listing CRM reports in SQL RRS feed

  • Question

  • I am creating a list of our CRM reports using SQL.

    I’ve got most of the information using the FilteredReport views but there’s one bit I can’t get at.

    This is the Related record Types  that shows in the General details (i.e. the entities that the report can be run from).

    I’ve found the FilteredReportEntity which lists the records but doesn’t show the entity names.

    reportidname  reportentityid                            reportid

    Sue 6 aug     6C1CAF87-AAFE-E211-B953-14FEB5CB8417     0756EEE0-82FE-E211-B953-14FEB5CB8417

    Sue 6 aug     57231BCF-43FF-E211-B953-14FEB5CB8417     0756EEE0-82FE-E211-B953-14FEB5CB8417

    I’m guessing I need to join this onto something but I’m not sure which column to link to which view/table.

    Wednesday, August 7, 2013 1:35 PM

All replies

  • The ObjectTypeCode attribute of the ReportEntity should give you this

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

    Thursday, August 8, 2013 1:02 PM
    Moderator
  • Super - I have it.

    Thanks a lot, David. I've been Googling all week to no avail.

    Friday, August 9, 2013 3:52 PM