Hello Experts Exchange
I am developing a SSRS Report that has categories and a sum of Total hours. I select the data, that is OK, but I have categories that have no data against them but I want them to show up on the chart as a zero value.
I have a table of data that lists all the categories.
Is there a way I can select the categories that have no data for them and set the value to zero and still keep my categories with data too?