Skip to main content

Questions and answer on Reporting in Axapta 2012

1. What tool is used to deploy reports in Microsoft Dynamics AX 2012?
( ) Microsoft Dynamics AX 2012 Reporting Project Deployment form
( ) Command prompt
(•) PowerShell
( ) None of the above

2. What technology is used to access report data in Microsoft Dynamics AX 2012 SSRS reports?
( ) Microsoft Dynamics AX 2012 Business Connector .Net
(•) Services
( ) PowerShell
( ) Direct SQL

3. Put the following steps in order:
Step:
1 : A user requests a report. A user requests a report. A user requests a report.
5 : The report is displayed to the user.
3 : The Microsoft Dynamics AX server receives the request and sends the report data back to Reporting Services.
2 : Reporting Services receives the request and asks the Microsoft Dynamics AX server for the report data.
4 : Reporting Services renders the report and sends it to the Microsoft Dynamics AX client.

4. Which if the following statements is true about failover clusters?
( ) Failover clustering is not supported for the report server database.
(•) Failover clustering is supported only for the report server database.
( ) Failover clustering is supported only for the Reporting Services Windows service.
( ) Failover clustering is supported for the report server database and for the Reporting Services Windows service.

5. What steps will the setup wizard for Microsoft Dynamics AX 2012 follow
when you install business intelligence components? (Select all that apply)
(√) Verify that prerequisite software has been installed on your server.
(√) Prompt you to select a SQL Server Analysis Services instance.
( ) Install Microsoft Dynamics AX 2012 Reporting Extensions.
(√) Prompt you to select a SQL Server Reporting Services instance.

Popular posts from this blog

sales order Totals option getting error in Axapta

Problem: On  click sales order Totals option getting below error. Please help me how to solve it. Microsoft.Dynamics.Ax.Xpp.ClrErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ClrErrorException' was thrown. at Microsoft.Dynamics.Ax.Xpp.CLRInterop.MakeReflectionCall(Object instance, String methodName, Object[] parameters) at Dynamics.Ax.Application.TaxDocumentProxy.Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide, String taxType, String taxComponent, Boolean , Boolean , Boolean ) in TaxDocumentProxy.sumByTaxAccountingProvider.xpp:line 15 at Dynamics.Ax.Application.TaxDocumentProxy.@Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide, String _taxType, Boolean , Boolean ) at Dynamics.Ax.Application.TaxDocumentProxy.@Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide, ...

X++ Code to run SSRS Report with parameter in D365 F&O (Example Sales Invoice )

Below is sample X++ Code to run SSRS Report with parameter in D365 F&O (Example Sales Invoice )      Args                       args = new Args();     CustInvoiceJour            custInvoiceJour;     SalesInvoiceJournalPrint   salesInvoiceJournalPrint;       select firstonly custInvoiceJour where custInvoiceJour.SalesId != '';       // Add record to be printed.     // In order to have the context table we need to set args.record().     args.record(custInvoiceJour);       salesInvoiceController = new SalesInvoiceController();     salesInvoiceController.parmReportName(         PrintMgmtDocType::construct(PrintMgmtDocumentType::SalesOrderInvoice).getDefaultReportFormat());       salesInvoiceContract = salesInvoiceController.parmReportContrac...