locked
Group by in tablix RRS feed

  • 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

    Monday, February 24, 2014 10:04 PM

Answers

  • 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

    Tuesday, February 25, 2014 5:40 AM

All replies

  • 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.
    Tuesday, February 25, 2014 12:11 AM
  • 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

    Tuesday, February 25, 2014 4:01 AM
  • 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

    Tuesday, February 25, 2014 5:40 AM