Avatar of rkharko
rkharko
Flag for Ukraine asked on

Handle empty values of matrix report in a column with DataBar

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
SSRSMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
rkharko

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Nico Bontenbal

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
rkharko

ASKER
Brilliant. Thank you very much !
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes