Add group by and ranges to Queries Forms example code
https://community.dynamics.com/ax/b/hellodax/posts/add-group-by-and-ranges-to-queries-forms-example-code
Add Cache MethodAttribute to Display Method
[SysClientCacheDataMethodAttribute(true)]
An internal error occurred in the provider. Additional information is available in the event viewer on the Management Reporter server XXX-XX. Please contact your administrator.
Solution Reset Data Mart for Dynamics AX from LINK
Management Reporter 2012 – Reset Data Mart for Dynamics AX
https://stoneridgesoftware.com/management-reporter-2012-reset-data-mart-for-dynamics-ax/
Refresh master data cache in D365FO
Solution: execute the below command in the browser, then reload the form:https://xxxprod.operations.dynamics.com/?mi=SysClassRunner&cls=SysFlushData ref:
SQL Server Windows NT [99% Memory Usage]
In Object Explorer, right-click a server and select Properties. Click the Memory node. Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory. Then Restart Service
New line / Line break in expression of SSRS
=First(Fields!CompanyAddress.Value, “EcomPackingSlipTmp”) & vbcrlf &First(Fields!CompanyURL.Value, “EcomPackingSlipTmp”) & vbcrlf &First(Fields!CompanyPhone.Value, “EcomPackingSlipTmp”)
Pass Args with Menu Item and open form with passes parameter x++
args.parm(parameter value); // calling menu item new MenuFunction(identifierstr(SampleTest), MenuItemType::Action).run(args);