web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / What can I use to buil...
Microsoft Dynamics CRM (Archived)

What can I use to build reports?? (BIDS replacement??)

(0) ShareShare
ReportReport
Posted on by donyc 4,515

Hi,

What can I use to build reports? I was told to use BIDS, but that looks like is from 2008. Is there something else I can use now?

I was told I could use now SSDT-BI, SQL Server Business Intelligence for Visual Studio 2012 instead of BIDS. But do I need anything additional installed??

I basically want to do what this guy did in below tutorial using BIDS

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    jlattimer Profile Picture
    jlattimer 24,562 on at

    From the SQL 2012 media you can install and use SSDT which installs VS2010 - from there you can install the CRM Report Authoring Extension to use create FetchXML based reports.

  • donyc Profile Picture
    donyc 4,515 on at

    Thanks Jason!

    I have downloaded SSDT-BI

    www.microsoft.com/.../details.aspx

    Can I use that with the CRM Report Authoring Extension that you highlighted?

  • PhilKermeen Profile Picture
    PhilKermeen 912 on at

    Report builder is an easy tool to use, just point at your filtered views (if you're on premise) - www.microsoft.com/.../details.aspx

    related blog:

    blogs.msdn.com/.../custom-reporting-in-microsoft-dynamics-crm-fetch-vs-filtered-views.aspx

    HTH

  • donyc Profile Picture
    donyc 4,515 on at

    HTH - so I don't event need SSDI-BI (www.microsoft.com/.../details.aspx)

    and can just download report builder you listed above?

  • PhilKermeen Profile Picture
    PhilKermeen 912 on at

    Yep, but it's a database tool, so you'll need to be on-premise rather than an online version of crm. When you've built your report you can import the rdl file into SSRS. Depending on how you want to display the report  and how your environment is configured there may be some hoops to jump through with ensuring the report can see the database connection but thats a whole other can of worms.

  • donyc Profile Picture
    donyc 4,515 on at

    Thanks Phil,

    In regards using FetchXML. I read the article you included and it states I would need Authoring Extension to use with BIDS. It looks like BIDS was decommissioned. Do you know if I can just downloaded SSDT-BI (www.microsoft.com/.../details.aspx) and then download the Authoring Extension. Will those 2 be enough and will they be compatible?

  • PhilKermeen Profile Picture
    PhilKermeen 912 on at

    Sorry, don't know for sure. BIDS is a cut down VS environment so worth a shot.

  • Suggested answer
    Nina P. Profile Picture
    Nina P. 2,195 on at

    Hi Donyc,

    I would recommend you to watch the video "Microsoft Dynamics CRM Troubleshooting Errors When Viewing Reports" available at

    which will talk you through troubleshooting techniques and examples of Fetchxml reporting issues and includes a description of the required components to create and edit fetchxml (first demo starts at 3:20)

    Please let us know if this helps.

    Thank you for using Microsoft Dynamics.

    Nina Peneva

    Support Engineer

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans