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 / Finance | Project Operations, Human Resources, ... / Newly added field in t...
Finance | Project Operations, Human Resources, ...
Answered

Newly added field in the report is empty

(0) ShareShare
ReportReport
Posted on by Community Member

Hello everyone,

Ever experience that you add new field in your SSRS TempTable, populated correctly in Data Provider Class, but after add it to existing report, the new field / column still empty ?

During debug of my Data Provider, as it is X++ Query, I managed to trace it, and confirmed it is has value. In the report object it self, I have restore Data Set, add the field in AutoDesign Data node. But after Build successfully and Deploy report. These newly added still empty.

Any suggestion what should I do ?

Thanks,

I have the same question (0)
  • Suggested answer
    Pete Alberts Profile Picture
    Pete Alberts 3,542 on at

    Hi Wwwong

    I feel you - I have spent many hours struggling with such SSRS reporting issues. Time and again they can be solved by restarting the report server, restarting the VM, iisreset or project rebuild. Restarting the report server is a good place to start.

  • Community Member Profile Picture
    Community Member on at

    Hi Pete,

    Yeah.. it's testing patience. I solved it by give the report's field a bait, by giving a fixed "trash word". (maybe he deserved)

    It appeared then I just switch back to supposed field.

    Thanks.

  • Verified answer
    Pete Alberts Profile Picture
    Pete Alberts 3,542 on at

    lol nice one. That reminds me of something. I often need to go through the process of figuring out whether the report is still responding to changes I make. Which can be done by something like that which you described (specifying a fixed value somewhere). And then also, the VS report editor sometimes becomes detached in some way. Don't know what the correct description is - but when you close the designer (or VS) and reopen, your changes will be gone.

    So I think what happened is your changes were not "going through" and then before, after or during the trash word procedure something magically got fixed. In any case, I'm glad you managed.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans
Liquid error: parsing "/blogs/post/?postid=%27nvOpzp;%20AND%201=1%20OR%20(%3C%27%22%3EiKO))," - Too many )'s.