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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SSRS Report Dataset No...
Microsoft Dynamics AX (Archived)

SSRS Report Dataset Not Refreshing, so that unable to add the new fields to the report

(0) ShareShare
ReportReport
Posted on by Tremor Olaes 2,147

If I make change to the report dataset (query or class), the dataset does not refresh in the Visual Studio.  I am supposed to be system administrator.  Our consultant is also a system administrator, but he is able to see the changes to the dataset.  He can see the dataset refresh and add the new fields to the report.  I am only able to add it when he refreshes the dataset.  Moreover, I notice that the class is not showing that I made a change to it.  I have tried compiling, generate CIL and delete usage data but still not able to do it. I was able to do this in our R1 AX2012 version, but since we upgraded, it seems that I lost permissions that allows me to do this.  Does anyone know what permissions I might be missing or the cause of this problem?  Any help would be greatly appreciated.

*This post is locked for comments

I have the same question (0)
  • Tremor Olaes Profile Picture
    Tremor Olaes 2,147 on at
    RE: SSRS Report Dataset Not Refreshing, so that unable to add the new fields to the report

    Hi Martin.  First thanks for your responses.  I spoke to our developer and according to him, even though I add code to existing class (DP class), the change by and change date will sometimes not change (in the class properties).  I actually just got off the phone with him and he told me that my VS profile is actually (as you suspected) pointed to another instance, hence why the fields disappear when I refresh.  His profile is pointed to the instance I am making changes to, therefore he can see my changes.  I think we have figured it out.  I need to be in the instance where my VS is pointed to so that I will be able to see my changes and modify the report.    

  • Martin Dráb Profile Picture
    Martin Dráb 235,966 Most Valuable Professional on at
    RE: SSRS Report Dataset Not Refreshing, so that unable to add the new fields to the report

    If your changes to the class aren't saved, what changes do you expect to see in the report? Shouldn't you focus on the problem with saving?

    Again, you please elaborate what you mean by "the change by and date does not show I changed it"? How did you do the change and how did you check it? Are you able to save other changes in this environment?

  • Tremor Olaes Profile Picture
    Tremor Olaes 2,147 on at
    RE: SSRS Report Dataset Not Refreshing, so that unable to add the new fields to the report

    I added the new field in the class DP (also added to the temp table so that I can populate), but the change by and date does not show I changed it.  When our consultant developer refreshes the dataset and saves the report, the new field becomes available for me to see and add.  If I refresh in VS, the field disappears.    

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 235,966 Most Valuable Professional on at
    RE: SSRS Report Dataset Not Refreshing, so that unable to add the new fields to the report

    Can you please elaborate the sentence "Moreover, I notice that the class is not showing that I made a change to it.", please?

    It might suggests that the report works correctly - there are no changes in the dataset to show, if you haven't been able to save them.

    If you see your changes in AX but not in Visual Studio, maybe your VS is connected to another AX instance.

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans