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 / Microsoft Dynamics AX (Archived) / Deploying SSRS report,...
Microsoft Dynamics AX (Archived)

Deploying SSRS report, changes only appear in one legal entity

(0) ShareShare
ReportReport
Posted on by lukbel 282

Hi there,

Running AX2012 R3 CU9

Having a bit of problems with one particular report - haven't been able to find any documentation to tell me where to go.

We've made some changes to the purchase order confirmation report, but have just discovered that the changes have only applied for our main legal entity. We have a second legal entity and usually when we deploy a report, it changes it in both places, but this one hasn't done so. Tried redeploying while in the second legal entity, but still didn't work.

Is there something obvious I'm missing?

Hope you can help, thanks very much in advance

Luke

*This post is locked for comments

I have the same question (0)
  • lukbel Profile Picture
    lukbel 282 on at

    Hi,

    As far as I know there's nothing in the report configuration which would make it work differently, the changes are aesthetic changes to the logo etc. We DO have two AOS servers, but I deployed them in both and no luck.

    Sorry, newbie question - how do I refresh the report server cache? I'm having a quick google and it seems to be there's a command line method I need to input on the SQL server? Is there a way of doing it in the GUI? (Also is it a bad idea to run during business hours, how long does it take?)

  • Community Member Profile Picture
    Community Member on at

    Hi,

        As Crispin John Augustine said, purchase order confirmation report Because of Report cache problem.

        Here is the screen shot for refresh the report server cache,

        RS.JPG

    Thanks

    Suresh

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    If you have changed the original report and it has multiple designs, it is possible that if your legal entity has a different country code, or if you have set up Print management on any level (AP module setup, Vendor, PO), then it has a different design selected other than the one you have customized.

    You can check the SQL Server where the ReportServer database is, it has ExecutionLog views, where you may check all past report executions, and within the parameters you can find the report and design selected. It is very easy to verify if the right design is selected there.

  • lukbel Profile Picture
    lukbel 282 on at

    Hi Vilmos,

    It's just one design, both our companies are the same country code and we don't use print management for it - that was part of why it was so confusing for me! haha But thank you for this information, I'll keep it in mind in future reports

    Suresh,

    Thanks very much for this info - I'll try this after business hours and that will probably solve the issue. I'll mark it as the answer pre-emptively, and ask again if that doesn't work :)

    Cheers

    Luke

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi lukbel,

        No worries, definitely it will work.

        If your importing purchase order confirmation report by xpo into live, You said you are using 2 AOS.

        Note: If you are importing any XPO into Live, You need to follow these

    1. You should stop one AOS, import using 2 AOS. After imported you need to start the first AOS, then only it will effect the changes. I think you didn't done this way.

    2. it it is not working, Please restart the both AOS and Sql server reporting services. It will work sure.

    Thanks

    Suresh

  • lukbel Profile Picture
    lukbel 282 on at

    Hi Crispin

    Good to know!

    Unfortunately, I refreshed the report server cache on both AOS servers and the problem persists :( Is there anything else I can try?

    Cheers

    Luke

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi lukbel,

       have you done this?

       If your importing purchase order confirmation report by xpo into live, You said you are using 2 AOS.

       Note: If you are importing any XPO into Live, You need to follow these

    1. You should stop one AOS, import using 2 AOS. After imported you need to start the first AOS, then only it will effect the changes. I think you didn't done this way.

    2. it it is not working, Please restart the both AOS and Sql server reporting services. It will work sure.

    If it is not done,

    Delete your report from report server and re deploy from AOT. it will work.

    Thanks

    Suresh

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans