Skip to main content

Reports


Report with explicit parameters

 There are two ways to create a report 

  • using controller class 
  • SSRS report using DP class 

1. For SSRS Report first create a DP class and declare the insertion in your temp table (In memory) and declare the logic for your report 




you can also place your queries in DP class or AOT queries 

2. Now create a contract class in which you will declare your parameters for your report and it will also perform validation of the data




3. Now create a UI builder class for your the lookup of your parameters and how they will bind to your report.






4. Now finally create your report from solution explorer and click add item and select report 

fill in the following properties in it to get the temp table mapped with the report


In this query first write name of your DP class and .temptable name to get its fields to map in the report 



IF IN YOUR REPORT MULTIPLE DATA IS NOT VISIBLE ADD ROW GROUP AND SORT ACCORDING TO YOUR DESIRED FIELDS 


5. Now create an output menu to refer this report as SSRS report and also mention the name of the Design tab in your report 



  • FOR CONTROLLER CLASS YOU CAN CREATE THIS CONTROLLER CLASS AND MENTION OUTPUT MENU OBJECT TYPE CLASS and OBJECT NAME CONTROLLER CLASS NAME 






 HEY HEY HEY !! HACK OF THE DAY!!!

GO TO ANY CLASS FROM OTHER CLASS SELECT CLASS NAME 

AND PRESS F12



Comments

Popular posts from this blog

Edit Method on Form

Edit Method D365 for a form Data Source 1. To create an edit method first create a controller class. with following properties  public static edit MainAccountNum LedgerJournalTransLedger(LedgerJournalTrans _ledgerjournal, boolean _set, MainAccountNum _id) { MainAccountNum accountId = _id; MainAccount mainAccount = MainAccount::findByMainAccountId(_id); if(_set) { if(_ledgerjournal.AccountType== LedgerJournalACType::Ledger) { mainAccount = MainAccount::findByMainAccountId(accountId); if(_ledgerjournal.LedgerDimension) { DimensionDefault defaultDim = LedgerDimensionFacade::getDefaultDimensionFromLedgerDimension(_ledgerjournal.LedgerDimension); _ledgerjournal.LedgerDimension = LedgerDimensionDefaultingEngine::getLedgerDimensionFromAccountAndDim(mainAccount.RecId, DimensionHierarchy::getAccountStructure(mainAccount.RecId), defaultDim); } else { _ledgerjournal.LedgerDimension = LedgerDimensionDefaultingEngine::getLedgerDimensionFromAccountAndDim(mainAccount.RecId, DimensionHierarchy::getAcc

Security Objects In D365

   PRIVILEGES, DUTIES AND ROLES IN D365 FinOps To add customize security privilege, duty and role you should follow this flow because it is considered as the best practices  Role---> Duty---->Privilege Duty and Privilege would be created at the back end and where as role would be created at front end  1. create privilege from solution explorer in a project  and add new entry point for output, display or action menus to refer in privilege that for which entity we have to give privilege to the user 3. Now Create a duty from solution explorer same as privilege and add this new created privilege to the duty  Now you can refer this duty to the role created on the front end.   HEY HEY HEY !!!! HACK OF THE DAY !!           THE HIGHEST ACCESS LEVEL  FOR ACTION MENU ITEM IS   DELETE     

Deep Links

  DEEP LINKS FOR SALES ORDERS In this blog we will discuss about generating deep links for any form , record or datasource. Deep links are basically termed for generating URL's through code for any specific record in D365. Using Deep links other environments can access D365 records by using this URL generated from it. 1. In below blog I am creating Deep links for sales order header record. 2. To Access these links one should always be added the user in FinOps to access through URL. Step #1 Create and extension class of  URLUtility class  and also add following code snippet to access this class : using Microsoft.Dynamics.AX.Framework.Utilities; using Microsoft.Dynamics.@Client.ServerForm.Contexts; public static str generateRecordUrl(str _menuItemName, MenuItemType _menuItemType, DataSourceName _dataSourceName, Map _indexFieldValuesMap, DataAreaId _dataAreaId = curExt()) {   System.Uri host = SessionContext::Get_Current().Get_RequestUrl();   UrlHelper.UrlGenerator generator = new Url