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) / Modify rdl of crm repo...
Microsoft Dynamics CRM (Archived)

Modify rdl of crm report directly

(0) ShareShare
ReportReport
Posted on by Community Member

One of my org's has about 20 reports that were developed in BI/SSRS and then uploaded to crm.  I need to modify one line of code in all of the reports.  Is it possible for me to use powershell, sql, or some other tool to modify the report directly without having to download each report, open in BI/SSRS, change code, then reupload to crm?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    Phoeneous,

    You are using onpremise right? Assuming yes since you mentioned SQL.

    You can go to the :http://reportserver/reports, that is through your server that you installed the Reporting Services inside.

    Go to the Reports, then you go to custom reports, choose the view to detailed view if you cant see clearly.

    Then you go to Customer reports folder and you find the reports name you want to modify ok.

    Then edit it through report builder, you might need report builder installer if not inside there, assuming it is feature in SQL that you before installed then it would be good, you no need to install anymore.

    Again, I recommend you to do a download backup copy first.

    But, please remember that you might still cannot do a bulk import, but at least save some times to not doing re-upload again since you just save it and it done updating.

    Hope this helps.

    Thanks.

  • Community Member Profile Picture
    Community Member on at

    This is perfect!  Thank you so much.

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