Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

SQL Report Refreshing issue

Posted on by 220

Dear all,

                   Am facing a issue in customized report.This report is for vacation balance report of the employee. The issue is i could not able to get the new employee vacation balance in the report. 

The Report menu item is generated using the report launcher class(Customized). I tried to track the report name in the AOT but i could not found. But, the report name is available in Report URL.

Please anyone help me to fix the issue.

Thanks in Advance.

            

*This post is locked for comments

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: SQL Report Refreshing issue

    Just download the file from the report server. You can edit it in Visual Studio. You can find a lot of documentation on the topic by searching the web.

  • Ameen1623 Profile Picture
    Ameen1623 220 on at
    RE: SQL Report Refreshing issue

    Hi Nikolaos

     If it is a normal ssrs report can you please give a way to find the logic of the report. i don't have knowledge on normal ssrs report.

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: SQL Report Refreshing issue

    To me it looks this is not an "AX SSRS report". It's just a normal SSRS report that is called from AX code. Therefore you can't find it in AOT.

  • Ameen1623 Profile Picture
    Ameen1623 220 on at
    RE: SQL Report Refreshing issue

    Hi Andre

                  Thanks for the reply.

       I could not found this report in VS as well. They called the report in action menu item with the class name starting with report launcher.

    i Debug the class but no use. But the report name is available in report URL with in the sub folder. i could not find this name in AOT not VS.

    Please find the below screen shots of the report.

    method-3.png

    Parameter-form.pngAfter-report-generation.png

    Report-menuitem.pngclass-for-report.pngmethod-1.pngmethod-2.pngmethod-3.pngmethod-4.pngmethod-5.pngmethod-6.pngmethod-7.pngmethod-8.png

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: SQL Report Refreshing issue

    Hi Ameen16232,

    Was this report synced with the AOT? See also the next forum post: community.dynamics.com/.../127388

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans