Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SSRS Fetch XML report
Microsoft Dynamics CRM (Archived)

SSRS Fetch XML report

(0) ShareShare
ReportReport
Posted on by Srini20 395

Hi,

I have developed one matrix report using fetch XML but always seeing one extra row. At the time of design I just set the Row and Column groups and picked the columns that I want to display but when I runt the report seeing additional highlighted row without any header value that I don't need? Am I doing any thing wrong here ? I am unable to hide this as I don't see any thing at design time. Please refer to screen shot and the FetchXML query.

Fetch XML Query:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="connection">
    <attribute name="record2id" alias="Account" />
    <attribute name="record2roleid" alias="ConnectionRole" />
    <attribute name="connectionid" />
    <attribute name="record1id" alias="Opportunity"/>
    <link-entity name="opportunity" from="opportunityid" to="record1id" alias="ab">
      <attribute name="statuscode" />
</link-entity>
  </entity>
</fetch>

 

*This post is locked for comments

  • a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: SSRS Fetch XML report

    I can't see it.

  • Srini20 Profile Picture
    Srini20 395 on at
    RE: SSRS Fetch XML report

    Hi Andrii,

    I resent that again, let me know if you are unable to see it.

  • Srini20 Profile Picture
    Srini20 395 on at
    RE: SSRS Fetch XML report

    Hi Andrii,

    Here is the screen shot. First section displays the details from Advanced Find query of CRM but the requirement is to display in the format where it is mentioned as SSRS reporting. I am trying to achieve this using SSRS Matrix report. I need to change the Roles from Rows to Columns. If I do the same report SQLServer table it works fine but with the above fetch XML its not aligning as desired.

  • a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: SSRS Fetch XML report

    Srini,

    I'm afraid that Metrix report is the only way for you.

    What kind of issues do you experience using outer join?

  • Srini20 Profile Picture
    Srini20 395 on at
    RE: SSRS Fetch XML report

    Thanks Andrii. Outer join is creating problem in the report that I am creating using Matrix. Any best samples that to create SSRS report using Fetch XML to convert the Columns to Rows or Rows to Columns?

  • a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: SSRS Fetch XML report

    Hello,

    Your screenshot is not visible. Can you please repost it?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans