How to remove (empty) from a grouped report?

  • 1
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a report with three groupings.  Not all of the groups will always have detail records in the last group, but I still need to be able to see all of the information in the grouped format.  The word "(empty)" is showing up in gray for some of my groups.  This makes the report overly busy and difficult to read at a glance.  How can I remove this "(empty)" feature without filtering out any of my records?

Photo of Tamara

Tamara

  • 366 Points 250 badge 2x thumb

Posted 3 years ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
Yah, "Been there, Done it, Bought the T-Shirt".

My work-a round is to create a new field called like [Grouping or blank]

with a formula

IF([Grouping]=""," ", [Grouping]) // ie show a space character instead of a null

and use that field in the reports.



 
Photo of Tamara

Tamara

  • 366 Points 250 badge 2x thumb
Thanks!