Search This Blog

Thursday, June 7, 2012

Ax2012 Create SSRS Report using Query and Display Methods of Table

Based on  requests from users, how to create the Report with Display methods, The following link will help you to create a simple report and deploy.

http://dynamicsaxgyan.wordpress.com/2011/08/19/learn-quick-first-ssrs-report-in-dynamics-ax-2012




13 comments:

  1. how to create document report from scratch level.

    ReplyDelete
    Replies
    1. Hi Laxmi,
      I posted yesterday regarding the creating the reports using RDP classes, you can go through it.

      http://krishhdax.blogspot.dk/2012/07/ax2012-create-ssrs-report-using-data.html

      Regards,
      krishna.

      Delete
  2. Hi krishna,

    I have an issue while printing reports for multiple sales orders.
    When we post two sales order packing slips together(i.e., select 2 open orders and open the packing slip for those orders..check print packing slip report button and pot it). we can generate the reports simultaneously. Even I have to print my reports along with those reports. But in my case, one report is prinetd and then second is printed only if the first report is closed.This is happening same as Shipping labels reports in Posting form.

    I have no clue how to print them like packing slips.

    Can you please help me in this issue.

    ReplyDelete
    Replies
    1. Hi Jhansi,
      Did you configure the packinfslip for printmanagement setup,How you are printing your report after opening your report from that selecy file print and providing the printer or, packing slip functionality will uses the printmanagement functionality...

      in your case is it showing to screen and printing from that...?

      Regards,
      krishna.

      Delete
    2. Hi Krishna,

      I have implemented the controller class for my report similar to salesPackingSlipController class.
      But in the execution, my class runs SRSReportRunController/run() method where it is not calling runPrintMgmt method.
      But in Packingslip class, salesPackingSlipController class runs \Classes\SrsPrintMgmtController\run() and executes the runPrintMgmt().

      Can you tell me if iam missing something....
      so that i can call runPrintMgmt() in my code.

      Thank you...

      Delete
    3. Hi Jhansi,
      your controller class should extends from
      extends SrsPrintMgmtController
      then you have to override runprintmgmt function, I explained in my one of my blog post how to configure printmgmt functionality for the report, you can refer that.
      http://krishhdax.blogspot.com/2012/02/ax2012-configure-print-management-for.html


      Regards,
      krishna.

      Delete
    4. Thank you krishna....your site was useful.

      Delete
  3. This comment has been removed by the author.

    ReplyDelete
  4. HI krishna
    I want Your small help as I want To make financial dimensions data flow from header form to line form & also want that if i update that data in header form then that data should reflect for all lines on line form.

    please help me out with this.

    ReplyDelete
    Replies
    1. Hi Deepak,
      just write the code in initfromheader() and initialize the value of finanicial dimension recid of header in line table method,
      And write in update method of table to handle to update the dimensions from header as well.

      Regards,
      krishna.

      Delete
  5. Thanks Krishna
    Can you send me A demo code snipplet If You Can...
    Regards
    Deepak

    ReplyDelete
  6. Hi
    My records are visible on ledgerjournaltransvouchertemplate form & in the table also but it is not showing on in the grid of ledgerjournaltransdaily form. please help me

    ReplyDelete

Thanks for visiting my blog,
I will reply for your comment within 48 hours.

Thanks,
krishna.