troubleshooting Question

Handle empty values of matrix report in a column with DataBar

Avatar of rkharko
rkharkoFlag for Ukraine asked on
SSRSMicrosoft SQL Server 2008
2 Comments1 Solution1146 ViewsLast Modified:
I have designed a matrix report with additional databar column. There are many empty cells in the report and I don't want to have different widths of bars in the  databar chart but I need to have  the same look. When there is 4 data columns in report then databar should have 4 bars independent if the row has values only for one column or for all 4 columns.
On the picture you can see the problem with databar. I would not like to put zeros instead empty values but zeros should be used only in the databar illustration (the zero will be not shown as graphic but it help to preserve the same order of data column in chart of databar)

Is it possible to adapt the data supplied from each row into databar chart in a way that it has always  the same qty of values ( and use zeros when empty value in a matrix cell detected) ? illustration of problem
Nico Bontenbal

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
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