Finance | Project Operations, Human Resources, ...

Reports are visible on front end is not visible in AOT

(0) Share

Report

Posted on by Shabir Ahmad

3,124

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

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Andre Ghazaleh 870 on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Shabir Ahmad 3,124 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Shabir Ahmad 3,124 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

mhdshb1 1,250 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Andre Ghazaleh 870 on at

Like (0)

Report
Copy link

Link copied!

Hello Shabir,

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

Best regards

Was this reply helpful? Yes No