Search code examples
reporting-servicesdynamics-crm-2011ssrs-2008-r2subreports

Auto numbering to parent and child columns


I am using SSRS 2012 for MS CRM report(FetchXML) which should get result as shown in below image :
enter image description here
There are Name and Parent columns. Based on Parents, Names should be displayed and numbering should be exactly in same order. I can able to display same order except numbering by using sub report.


Note: Using FetchXML Query only.
Thanks in Adv.


Solution

  • I found solution for my question. You need to do grouping and use expressions as shown in following image. Hope this helps someone :)enter image description here