开发者

How to display all tablix columns, including zero

开发者 https://www.devze.com 2023-03-23 07:53 出处:网络
I am developing an SSRS 2008 tablix.The problem that I have though is that I need to display all 12 months of the year.Currently, it only displays columns with values > 0.Even though I entered this ex

I am developing an SSRS 2008 tablix. The problem that I have though is that I need to display all 12 months of the year. Currently, it only displays columns with values > 0. Even though I entered this expression for that field:

=IIF(Sum(Fields!NumActionPlanRemainOverdue.Value)=0, 0, Sum(Fields!NumActionPlanRemainOverdue.Value))

What else can I do?开发者_开发百科


From what I know, a Tablix does not hide non-positive rows. Can you verify that the dataset is returning a row for every month?

Some additional considerations are:

  • Are you showing the data in a Tablix or a chart?
  • What data type is the month column?
0

精彩评论

暂无评论...
验证码 换一张
取 消