Summarized values in AX form

Users sometimes want to see both individual transactions in a grid of a Dynamics AX form, and some summarized values, such as the total amount or the number of lines (often above or below the grid). Iterating through the whole datasource and getting values one by one isn’t efficient, especially if the query returns many …

Continue reading ‘Summarized values in AX form’ »

Aggregation of expressions in SSRS

Imagine you have an SSRS report with a tablix, which contains a calculated field. For example, there is a date field (from a data set) and a calculated field showing the difference between the given date and the current date: The Diff field is calculated by the following expression: =DateDiff("d", Fields!GivenDate.Value, Today) Now we want …

Continue reading ‘Aggregation of expressions in SSRS’ »