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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

how to add a column to a smart list report

(0) ShareShare
ReportReport
Posted on by 60

Does anyone know how to add a column to an existing SmartList report?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Deborah Bergman Profile Picture
    1,465 on at

    Open the report you want to start with, click on columns and select antoher column from the list displayed. They will always show at the bottom of the list, so you can select it and move it up or down depending on where you want to see the new column in your report.  Then click ok and you should see the new column added.  If you want to save this column to always show, click on favorites and give it a name then decide if you want all users in all companies to have access to this report (Select System),

    all users in this company (select Company), all users in your class (select User Class) or just your user ID by in all companies you have access to (User ID).

    Then you can select search and put restrictions in if you want, but that columns wil remain as long as you save it as a favorite.

  • Mike Smith Profile Picture
    6,840 on at

    As a note, Deborah's recommendation will work under the circumstance that the column is available as one of the default columns available on that SmartList.  If the column is simply unavailable for selection, you will need to take advantage of the SmartList Builder tool that will allow you to select additional columns that may not be available from an underlying dataset.

  • L Vail Profile Picture
    65,271 on at

    Hi Teresa,

    In addition to Deborah's and Mike's advice, if you do not own SmartList Builder, you can use the integrated Excel reports and views. When you install the Excel reports, views are created in the database that match each of the 'out-of-the-box' SmartLists.

    You can modify (or copy) these views and then use them in a dynamic Excel report. No additional module is necessary.

    Kind regards,

    Leslie

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans