Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
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

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 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 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 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 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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans