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 AX (Archived) / Exporting an SSRS repo...
Microsoft Dynamics AX (Archived)

Exporting an SSRS report to Excel

(0) ShareShare
ReportReport
Posted on by Community Member

Anybody know how to export an SSRS report to Excel without taking the hyperlinks?

I know that I can disable the hyperlinks in the spreadsheet, but it looks like that has to be one at a time. I would like to disable the hyperlinks, before exporting data.

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,171 Super User 2025 Season 2 on at

    Hi Michael,

    Without changing the design of the reports it is as far as I know not possible.

    When you have the SSRS report exported to Excel with all the hyperlinks it is possible in Excel to select all cells, right mouse click. In the pop up menu choose 'Remove hyperlinks'. Then all hyperlinks in the sheet are deleted.

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

    Thanks for th esuggestion, but I do not see an option to remove hyperlinks, when I right click a bunch of selected cells. The only option I have found is to highlight all the cells, and use the "clear formats" option.

    regards

    Mike Gooding

  • Jimmy Liu Profile Picture
    Jimmy Liu 105 on at

    Hi Michael,

    I don't think it's doable since the export is part of SSRS functionality rather than AX.

    Can you select all(ctrl + a) and right-click to select "remove hyperlinks"?

  • Jyoti P Choudhury Profile Picture
    Jyoti P Choudhury 110 on at

    This is old post but still posting a reply for other's benefit.

    The 'Remove hyperlinks' option is not available in Excel 2007 and below. it is only available in above excel 2007

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Michael,

    You can export a SSRS report without the hyperlinks. Yet, this requires a report modification. Please see the following post: stackoverflow.com/.../disable-links-in-dynamics-ax-2012-report-viewer

    Best regards,

    Ludwig

  • Rendo Profile Picture
    Rendo 5 on at

    Set printsettings to file > Microsoft Excel. Direct export to Excel.

    I've same problem when I use 'screen' (reportviewer) and then export to Excel.

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 AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans