Group by in tablix

Question

Hi everybody i have this problem in my tablix my boss doesnt want this white rows so i tried to hide this but when i do it my tablix not show all info in the last group look second imagen please

why happen this? anybody could help me please

Answer 1

Hiding rows while grouping does leave white spaces and report looks bit ugly. I would advise consider modifying your dataset i.e. your source query or put filter on dataset to exclude rows which you don't want rather than hiding.

Answer 2

Hi Pachecora,

Use filters in the dataset or SP to eliminate Empty or Null Values if not needed instead of hiding in the report.

If u don't ur report to be displayed in tree structure then u can use sub reports.

Then u can design the report as per ur requirement.

If any queries please feel free to ask...

Thanks,

Kishore Babu K

---

Kishore Babu K

Answer 3

This should be done either in backend query to ignore those blank rows by using a WHERE condition like below

WHERE fieldName > ''

or in dataset properties add filter a below

Expression: =Len(Fields!FieldName.Value)

Operator: >

Value: 0

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs