We have a SSRS report which shows the result of a dataset in a tablix. If the query in the dataset returns no data, the header of the Tablix gets displayed but not the tablix cells below the header. I know there is a property to NoRowMessage
, but in fact it is not what we want. Because when I specify a message, SSRS shows the message instead of the empty tablix.I must show the tablix structure as it is, but with empty cells.
I even set the rule for each cell value of the tablix using IsNothing
function, to show blank (""), if the value is null, but it didn't help.
Do you have any idea? Thanks for your help in advance.