Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
Invoice Settlements/Discounts/Reversals
SSRS and SSAS Integration
Workflow
Hello everyone,
I need help with launching a report from AX2012. When I launch it from custjournal, the information selected in the data provider is inserted correctly into my Temp table, but after that the report appears empty although there is info to be shown.
Any ideas? I have used the debugger but cannot find the reason why the report is launching without information.
Thanks.
Marc
Hi Marc,
Are you sure that the data is getting stored in the temp table.Make it regular once and then check if data is getting store or not.
In case if it is getting stored i would suggest you to check the user from which you are opening the report. he may not have access to table/record etc.
Hi! thank you for the answer.
The data is getting stored correctly in the temp table because I open it and see that the lines are there. It is not exactly a temp table (but it works as it), it's a regular table but I delete the old information in the beginning of the "processReport" in report data provider class. I made it regular because AX told me that it was necessary to launch it from AX (by the same way that SalesInvoice report is launching, I looked on this report and followed the steps).
So, I think it's not a problem of user access to the table, because I'm looking the table content in the AOT with the same user that is launching the report.
Hi,
Maybe your ProcessReport populate the regular table but your "getTmpTable" method de not return the correct table buffer.
Follow the link below which explain how test a DataProvider:
community.dynamics.com/.../126044.aspx
Regards
Fx
Sorry but if it append to a standard report? Does anyone know the reason of this behavior?
I Have the same error on all Standard Report. For example PurchPurchaseOrder.
I have this situation:
- One Environment for PreProduction: -> link to the first Report Server Installed -> All Reports works well
- One Environment for Live -> link to the Report Server 02 -> reports appearing empty
- One Environment for TST -> link to the Report Server 03 -> reports appearing empty
Consideration:
1 - There aren't error in compilation and generation of CIL.
2 - The reports have been published properly into the correct report server without error.
3 - We did the setup of report server and the ax using the rules of this site http://technet.microsoft.com/en-us/library/hh38
I'll try to debug. BUT... I think that is something about missing configuration.... it's impossible that all the reports are empty.
Did Anyone solve this problem?
M.
Marco,
try to clean your cache / usage data.
Hey Marc, were you able to sort out the empty report issue at your end. I am getting some of the reports like PSAPurchaseOrder, VendInvoiceDocument as empty while other reports are giving data.
I have tried everything mentioned in this thread but it did not work. Please help.
Hi imran,
finally my problem was a bad configuration of the ReportServer. I had 3 different AOS installed, but only one single ReportServer, so the reportServer was looking for data in another AOS and found anything. The solution was to install one ReportServer per AOS, and pointing each ReportServer's configuration (in AX configuration utility in ReportServer) correctly to the AOS.