如何显示零Tablix数据行？(How to make zero tablix data rows appear?)

如何显示零Tablix数据行？(How to make zero tablix data rows appear?)

我正在制定SSRS 2008报告。 我创建了一个tablix，但是，当我查看此报告时，其中一行的条目为零。 此行未显示在输出中。 如何让它显示无论值如何，否则它只会显示“0”？

这是我用过它的表达式：

=iif(CountDistinct(Fields!Client.Value)=0 or isnothing(countdistinct(Fields!Client.Value)),0, CountDistinct(Fields!Client.Value))

我尝试在不同的字段上进行分组，并在另一个字段上进行过滤，但是当没有数据时，这些字段都不会出现。

I am developing an SSRS 2008 report. I created a tablix, however, when I view this report one of the rows has zero entries. This row is not showing in the output. How can I make it show regardless of values so that it will just show "0" otherwise?

This was the expression I used for it:

=iif(CountDistinct(Fields!Client.Value)=0 or isnothing(countdistinct(Fields!Client.Value)),0, CountDistinct(Fields!Client.Value))

And I have tried grouping on different fields and also filtering on another field, but none of these make it appear when there is no data.

最满意答案

我认为你能做的最好的事情就是确保你使用的数据集具有你想要的记录，即使它是空的。 例如，如果您要对月份进行分组，并且希望所有12个月都显示在Tablix中，那么即使它们对所有其他列都具有空值，您也需要在数据集中存在这些月份。

I think that the best you can do is ensuring that the dataset you are using has the record you want, even if it is null. For example, if you are grouping months, and you want all 12 months to appear in your tablix, then you need to make those months to exist in your dataset even if they have null values for all the other columns.