[{"id":"840f0737-df1d-47ae-bb0a-359b01fe0608","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"d5d9cdef-8854-4505-89be-a2bbc3cb4482","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"3dc3dd55-35b0-4d23-bf62-47bc3650e4ee","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"80d84fbc-d0f8-4e4a-947f-e3e4de9b49b2","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]},{"id":"9152b7ca-0186-4fe3-a26f-5a05f322db07","tags":[{"product":null,"links":null,"id":"adf72f47-7f61-4239-8392-b9bcc127fa80","name":"\u65B0\u589E","color":"green","productId":"0995490e-43fc-4d6e-bc8d-8e66f38b0c63"}]}]
        
(Showing Draft Content)

表格单元格内容的条件转换

报表的表格单元格,一般默认是显示绑定的数据集字段值内容。某些情况下,可能需要将原始的字段值做一些转换,再显示出来。

示例

比如一个人员花名册,设计状态如下图:

154011s0v8czvc3n54kuqn.png

数据集的性别、学历字段可能是整数值,如下图:

154030qdttiddf4ccjju3t.png

性别的1表示【男】;2表示【女】;学历则是:1=高中或以下;2=大专;3=本科;4=研究生。

为了在表格中显示更具直观意义的文字信息,可使用表达式来实现字段值的转换。


对于性别,将默认的数据绑定表达式

{性别}

修改为:

{IIF(性别=1,"男","女")}

对于学历,将默认的数据绑定表达式

 {学历}

修改为:

{Choose(学历, "高中或以下","大专","本科","研究生")}

再预览,即可看到期望的表格内容,如下图:

153131x7yyllnhl3t88tcr.png

关于表达式中IIF和Choose函数的说明,请参考 流程函数