How to get running value in ssrs report in ax 2012

Description:-

Here we will generate serial number based on grouping.  If I have grouping on ssrs report only for that group generate serial number in ssrs report. For that you have to get running value for that group in ssrs report.

For Example: Here I have ItemId group in ssrs report I want to display value for that group only not for each for in ssrs report.
So you have to add column in you inside group left and add below expression.
=RunningValue(Fields!ItemId.Value, CountDistinct, "Dataset") 

Note: - You have to specify field in running value which you have set parent group.

Related Posts

Previous
Next Post »

Thanks for comments.....