SSRS 2005 Dropping rows in matrix report

Question

This is not about dropping rows with no values for columns, just dropping rows arbitrarily.  I have one column group and one row group and where there is a duplicate value for the first two columns in two succeeding rows, the second row gets dropped from the matrix display.

---

WFB

Answer 1

Feel a bit daft for asking but is the visability set to hide?

Answer 2

 

Hi There

Thanks for your posting. Are the values inside get summarised? I mean if you two row with the same value inside dataset, would that inside it get summed up

Please reply

Many thanks

Syed

Answer 3

Hi WFB,

In a matrix, the row group or column group should not display duplicate fields. Here, please check whether the dataset returns duplicates or not. Besides, I suggest you post screenshots of the report design structure and the report preview for further analysis.

If you have any questions, please feel free to ask.

Regards,

---

Mike Yin
TechNet Community Support

Answer 4

The row that gets dropped has some values the same, some values different from the row that precedes it.  I have tried the matrix with both =Field and =First(Field inset into the boxes.

---

WFB

Answer 5

---

WFB