Microsoft Dynamics AX

Forums

Home » Microsoft Dynamics AX » Microsoft Dynamics AX Forum
Related Search Results

passing parameters from AX2009 to SSRS reporting

by
on 11 Apr 2011
  • Verified Answer

Ax 2012 Deploy reports through code

by
on 16 Jan 2012
  • 0 comments

SSRS ax 2012 batch processing

by
on 29 Nov 2012
  • Not Answered
Troubleshooting an Issue?

Our support engineers have assembled the top recommended solutions for you.

Microsoft Dynamics AX 2012

CRM Connector in Microsoft Dynamics AX 2012

Financials Management in Microsoft Dynamics AX 2012

Upgrading 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

AX 2012, Calling a ssrs REport from x++

This question is answered
Benoit Cyr
Posted by
on 6 Nov 2012 2:04 PM

Hi ,

How can I run (call)  a SSRSreport from a method in X++.

Thanks.
Verified Answer
  • Daniel Weichsel
    Posted by
    on 6 Nov 2012 3:56 PM
    Verified Answer
    Verified by

    You can use the SrsReportRunController class as in this example:

       SrsReportRunController  controller;

       controller = new SrsReportRunController();

       controller.parmReportName(ssrsReportStr(LedgerTrialBalance, Summary));

       controller.startOperation();

    The controller has additional parm methods to help control running the report, such as parmShowDialog which you can use to skip the report dialog.

    For advanced features you can create a new controller class extending SrsReportRunController and override methods.  For example, by overriding the prePromptModifyContract method you can manipulate the query or other data members before the dialog is shown.
All Replies
  • Daniel Weichsel
    Posted by
    on 6 Nov 2012 3:56 PM
    Verified Answer
    Verified by

    You can use the SrsReportRunController class as in this example:

       SrsReportRunController  controller;

       controller = new SrsReportRunController();

       controller.parmReportName(ssrsReportStr(LedgerTrialBalance, Summary));

       controller.startOperation();

    The controller has additional parm methods to help control running the report, such as parmShowDialog which you can use to skip the report dialog.

    For advanced features you can create a new controller class extending SrsReportRunController and override methods.  For example, by overriding the prePromptModifyContract method you can manipulate the query or other data members before the dialog is shown.
  • Benoit Cyr
    Posted by
    on 7 Nov 2012 7:18 AM

    Thanks Daniel,

    It's working.

    Case closed.
  • Zahir Hussan
    Posted by
    on 12 Feb 2013 6:10 AM

    Hi,

           I need to know the usage of controller class in ax 2012 for creating SSRS Report.

           Any ideas, Please share it.

    Regards,

    Zahir

  • venkatesh vadlamani
    Posted by
    on 12 Feb 2013 9:41 AM

    Report programming model for Microsoft Dynamics AX 2012

    search for above text in BING.

    MOst comprehensive documentation for reporting framework in ax 2012
  • Ante Karpuzovski
    Posted by
    on 13 Feb 2013 8:15 AM

    How can I run the report with parameters?
  • venkatesh vadlamani
    Posted by
    on 13 Feb 2013 12:06 PM

    you have to get the contract object associated to the execution by using this kind of construct

    ReportContractClass contract;

    contract = controlerObj.ParmReportContract().ParmRDPContract() as ReportContractClass

    contract.parmParamete1(SetValueHere)

    contract.parmParameter2(SetValuehere);

    now call this method,

    ControlerObj.startOperations()
  • Ante Karpuzovski
    Posted by
    on 15 Feb 2013 4:11 AM

    With parameters like calling the report with parameter name Customer_Num, Invoice_ID...,  not report parameters like print destination, report name, caption... ?
  • venkatesh vadlamani
    Posted by
    on 15 Feb 2013 4:26 AM

    @ Ante    

    You need to first set the report name for the controller object

    then you get the ReportContract object from it as mentioned above.

    ReportContractContains

    1)RDPContract   (If you have a DP class attached to a DS used in the report which has a parameters)

    2)RDLContract  (these are parameters used just in the design of the report )

    3)QueryContracts (the query  LIST associated with the execution of the DP)

    4)PrintContracts (these are the print destination settings associated to report execution)

    you can explicitly set all these for a report once the report name is set and you have ReportContract object

    Hope this might be of some help

    Cheers

    Venkatesh