Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Retrieve Fetchxml from a Report RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All -

    I have a report created using the out of the box feature of CRM 2011 (no custom fetchxml, no t-sql). Is there a way to extract the FetchXML from an OOB report, the same way we can extract it from an advanced find?

    Thanks in advance.

    Wednesday, October 16, 2013 10:13 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote
    Hi Eric,
    you can download the RDL file of the report and opens it using BIDS (Business Intelligence Development Studio).
    Inside you will find the datasets and you can see the their queries, depending on the report you can find the fetchxml or the t-sql code.

    My blog: www.crmanswers.net

    • Proposed as answer by Mamatha Swamy Wednesday, October 16, 2013 10:40 PM
    • Marked as answer by Eric_Blanco Thursday, October 17, 2013 1:28 PM
    Wednesday, October 16, 2013 10:38 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    Hi Eric,
    you can download the RDL file of the report and opens it using BIDS (Business Intelligence Development Studio).
    Inside you will find the datasets and you can see the their queries, depending on the report you can find the fetchxml or the t-sql code.

    My blog: www.crmanswers.net

    • Proposed as answer by Mamatha Swamy Wednesday, October 16, 2013 10:40 PM
    • Marked as answer by Eric_Blanco Thursday, October 17, 2013 1:28 PM
    Wednesday, October 16, 2013 10:38 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Guido - perfect, thanks that worked!

    1. Select Report-->Edit-->Actions-->Download Report.

    2. Load report in BIDS (or VS with MS Dynamics CRM Fetch data connector installed).

    3. View-->Report Data explorer-->Under Datasets, right click DSMain-->Dataset Properties.

    4. FetchXML displayed in the Query window.

    Thursday, October 17, 2013 1:28 PM