troubleshooting Question

Report Header not displaying all fields when value is 0

Avatar of gracie1972
gracie1972Flag for United States of America asked on
SSRS
2 Comments1 Solution279 ViewsLast Modified:
I have a tablix where my column headers would display the name of the district.
Problem is when the district value is 0, the district does not display.

Regardless of the value, I want the column header to display.

For Example:

For the District I have create a column group where the sorting has an expression:
=IIF(Fields!District.Value = "National", 1,
IIF(Fields!District.Value = "Colorado", 2,
IIF(Fields!District.Value = "Florida", 3,
IIF(Fields!District.Value = "Texas", 4,0))))

However still This is the final result when the value is 0:

  Report view
I want the report result to appear:
Program name                         National       Colorado      Florida     Texas
Web                                             4
Test                                              1                                                      1
                                                 -------------------------------------------------------------------
                                                    5                                                       1

What else do I need to do?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros