First thing you need to verify the Service account and Execution Account are properly configured under Reporting Services Configuration Manager. After some troubleshooting, I found UAC was not turned off.
This post is about how to create info Part in AX and use it on list page. For this example; I am using Projects List page and will add Revenue
Faced following error after restoring Dynamics AX databases from one AOS server to other. Cannot open the datafile “C:Program FilesMicrosoft DynamicsAX60ServerDAX2012R3binApplicationapplStandardaxapden-us.alt” Error code from the openrating system: errno = 13.
I myself often require following commands and worth to have these at one place to get it more quickly. Export a Model File Windows PowerShell Export-AXModel -Model <name> -File <Filename.axmodel>
While reading some lengthy operations e.g. reading data from CSV files, fetching data in query and uploading data etc I wanted to know the time consuming in each opertion. This
Create and add datasource with range in X++ // Code using X++ to build the query Query query; QueryRun queryRun; QueryBuildDataSource qbds; ProjTable ProjTable; ; query = new Query(); //
I got a requirement where I want to show sum amount based on differnent conditions. Simple Sum of amount can be shown with following expression; =Sum(Fields!Amount.Value) I tried following expression
Sommetime we require to use values from textboxes in SSRS for some calculations or data hiding and some other manipulations. Textbox or any other object on report design is an item
Sometime we do need to know the number of records fetching through X++ query and this can be achieved by SysQuery::CountRecords(QueryRun) function. This function works similar to this X++ logic; ProjTable
Following expression can be used to show last day of the monthin SSRS report. Format(DateSerial(Year(Parameters!Dataset1_AsPerDate.Value), Month(Parameters!Dataset1_AsPerDate.Value),“1”).AddMonths(1).AddDays(-1),“dd/MM/yyyy”)Input: Parameters!Dataset1_AsPerDate.Value = “02/01/2015”Outout: 31/01/2015
Do you have a topic you'd like me to cover or questions you'd like answered? Submit your requests, and you might see your answers featured in an upcoming blog post! You can send me an email at the address below. I look forward to hearing from you and exploring the topics that matter most to you!
Join our subscribers list to get the latest news,
update specials offers and delivered directly in your inbox.