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 GP (Archived) / Un-publish a SmartList...
Microsoft Dynamics GP (Archived)

Un-publish a SmartList that exports to an Excel File

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Does anyone know how to un-publish a Smartlist that has been setup to export a file to Excel?  The reason why I am looking to reverse this is because the default Financial Transactions Smartlist currently exports to an Excel file template stored on a server however due to permission issues I am looking to reverse this Smartlist from exporting to the excel file template but instead just export to an ordinary blank excel spreadsheet.

I have found various bits of information online as to how to publish a smartlist but I am struggling to find any information on how to un-publish one.

Any help would be greatly appreciated.

Thanks

Kevin

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Un-publish a SmartList that exports to an Excel File

    Great, that worked Jamie, thanks! Now to figure out how to remove a smartlist haha.

  • Verified answer
    Jamie Harris Profile Picture
    Jamie Harris on at
    RE: Un-publish a SmartList that exports to an Excel File

    Hi Natalia,

    The only way I've found to un-publish a SmartList Designer report is to delete the entry for the Published report in syDeployedReports within the DYNAMICS database.

    SELECT
*
FROM DYNAMICS..syDeployedReports
WHERE ObjectType = 5


    The above SQL query will give you a list of deployed SmartList Designer reports. If you find your report in the list and run a delete statement to remove the line it will 'un-publish' the report. Beware, it's wise to back up your database before removing this data and I would recommend making the change on a development system before you go ahead and do this in a production environment.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Un-publish a SmartList that exports to an Excel File

    I need a solution to this problem also!

    I found the .odc and the excel file in administration --> excel reports, but the "remove from" button is grayed out!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Un-publish a SmartList that exports to an Excel File

    Seeking solution for the same problem. Please facilitate as the response which suggest to try REPORT OPTIONs is not working.

    Thanks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Un-publish a SmartList that exports to an Excel File

    Hi Kevin,

    Not for sure but I believe you have to go into the Smart List report and click on the Report Options tool (SmartList- Checkbox Report -Publish Report option - Report Option- Email Options/Destination).  From there you can delete the report option or modify it so it won't automatically export to Excel.

    Good luck!

    L

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,356 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans