0

I have a fetchxml data set and design as per below in my ssrs.

enter image description here

My preview was like this.

enter image description here

What I want to achieve is, supposed to be like this.

Parentaccountid    StatusH1    StatusH2
Parent Account A    Final       Draft
Parent Account B    Draft       Final

So, what I did is adding Row Parent group and group by Parentaccountid, but what I get is only first row for each Parent Account A and Parent Account B.

xChaax
  • 193
  • 5
  • 27
  • You need to add a column group, Take a look at this very similar question and answer: https://stackoverflow.com/a/9007678/400375 – Jamie F Mar 14 '18 at 13:03
  • Thanks Jamie, but I dont really understand your answer explanation. – xChaax Mar 15 '18 at 12:45

0 Answers0