Query contracts is not initialized in AX 2012 SSRS

This question is answered

Hi,
      I have duplicated LedgerJournal Report.
      Accounts Payable > PaymentJournal

  Duplicated below objects
  
  LedgerjournalDP
  LedgerJournalContracts
  LedgerJournalController and businesslogicfiles.

  I renamed all places where ever I want.

 I generated CIL(both)


  When I run the report Query contract object is not getiing initialized.

Classes\Srsreportruncontroller\getdatacontractinfoobjectsinternal
queryContracts = reportDataContract.parmQueryContracts();

If I am linking the standard menu item I am getting query in above line.


May I know the reason.I am getting the same Issue when I am duplicating the standard report. 

  

Verified Answer
  • Make sure the SSRS process is able to "catch up" to your newly generated CIL. Restarting the Service itself (SSRS Intance) might be the missing step for it to load your newly generated CIL.

    Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no

  • Please delete the data from these table's if you have executed report some time earlier and made changes to it query which now throw an error

    1)SRSReportQuery

    2)SysLastValues(systemDocumentation)

    In visual studio if you have disable the dynamic filter for the DS that might cause this too.

    If your Reports DS has Dynamics filtering enables the query used in the report , or ReportDP class as queryAttribute gets initialized from the SRSReportQuery table if already report is executed once.

    Delete this will actually regenerate the map for the queryContract.

All Replies
  • Make sure the SSRS process is able to "catch up" to your newly generated CIL. Restarting the Service itself (SSRS Intance) might be the missing step for it to load your newly generated CIL.

    Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no

  • Please delete the data from these table's if you have executed report some time earlier and made changes to it query which now throw an error

    1)SRSReportQuery

    2)SysLastValues(systemDocumentation)

    In visual studio if you have disable the dynamic filter for the DS that might cause this too.

    If your Reports DS has Dynamics filtering enables the query used in the report , or ReportDP class as queryAttribute gets initialized from the SRSReportQuery table if already report is executed once.

    Delete this will actually regenerate the map for the queryContract.

  • Thanks for your reply.Can you please give some ssrs development document.It will be helpful for me at critical situation.

    Customizing existing reports.

    Adding new fields in tmp table in existing reports.

    Duplicating existing reports with business logic files.

  • MSDN you have reporting framework document with examples of all the approaches conceptual model of framework. Please search for "M3 programming model frameworks for SSRS reports in Ax 2012"  This document is microsoft framework document for SSRS reports in Ax 2012. This is the best document you can get on Ax ssrs till date. MSDN also have how to write a sample Dp class etc.

    For print mgmt  reports i am clueless where  to search for

  • community.dynamics.com/.../97949.aspx

    has general steps which will be needed when ever changes made to TMP tables returned by your DP class

    hope it was of some help

    Cheers

    Venkatesh