Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Reports are visible on front end is not visible in AOT

Posted on by 2,988

payrollReport123.pngpayrollReport.png

Hi Experts,

I didn't find some Reports in AOT please help. Please check the above two images Front-End and Back-End on the Front end is showing but not in AOT.

Best Regards,

Shabir Ahmad

  • Suggested answer
    Andre Ghazaleh Profile Picture
    Andre Ghazaleh 870 on at
    RE: Reports are visible on front end is not visible in AOT

    Hello Shabir,

    If the query is not returning any row maybe your reports are MorphX reports rather than SSRS

    Best regards

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Reports are visible on front end is not visible in AOT

    Hi Shabir,

    I wonder why you want to use a report that applies to the US payroll functionality if you have a setup made for Saudi Arabia.

    Did you apply the US localization functionalities for your company or did you make some modifications?

    Would be great if you could provide some additional information how you operate this US payroll module.

    Best regards,

    Ludwig

  • Suggested answer
    mhdshb1 Profile Picture
    mhdshb1 1,250 on at
    RE: Reports are visible on front end is not visible in AOT

    Hi Shabir,

    To check the configuration keys you can go to

    System administration > Setup > Licensing > License configuration

    and make sure you select the Payroll - USA configuration key.

    Regards,

    M

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: Reports are visible on front end is not visible in AOT

    Hello Andre Ghazaleh ,

    Thanks for your prompt reply, i want to know about these two step which you mentioned  point number

    1)  In Report Dialog-> Right Click -> Setup ->Information page, here you will get the report name in Caller Edit box, you can also click Edit to go directly to AOT     (where is Report Dialog  in AOT or ??)

    Point number 5

    I checked the SQL Query but the query given by you is giving me blank row now info  ??

    Best Regards,

    Shabir Ahmad

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: Reports are visible on front end is not visible in AOT

    Hi Dr. Ludwig Reinhard,

    Thanks for your valuable reply from where i can found the this config key, i setup is Saudi Arabia. is in AOT or system administrator module.

    Best Regards,

    Shabir AhmaD

  • Suggested answer
    Andre Ghazaleh Profile Picture
    Andre Ghazaleh 870 on at
    RE: Reports are visible on front end is not visible in AOT

    Hello Shabir,

    You have many options to find the report in AOT:

    1) In Report Dialog-> Right Click -> Setup ->Information page, here you will get the report name in Caller Edit box, you can also click Edit to go directly to AOT

    2) In AOT -> Menus , find the report menu item name and from it you find the report in AOT

    3) Make code modifications to the report classes to always display report name on the title, for this you need to modify method createReportViewer() in ClassFactory class ,be carefull tought because ClassFactory is a system class which is loaded every time AX is started so it should be modified with care.

    4) Set a breakpoint at parmReportName method of SrsReportDataContract class, debug and you will get to your report name

    5) You could also run an sql query on the report database(default name is ReportServer) to select the last executed reports:

    SELECT TOP 100 *  FROM [ReportServer].[dbo].[ExecutionLog2] ORDER BY TimeStart DESC

    Once you find the report name you can use the find tool to locate it in AOT

    Best regards

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Reports are visible on front end is not visible in AOT

    Hi Shabir Ahmad,

    The Report that you mentioned depends on the PayrollUSA config key.

    Not sure for what country/region you setup your system and whether this config key is enabled in your environment.

    Please double check that.

    Many thanks,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans