SSRS报告中的排序列

问题描述

= Math.Round((IIF(Fields！npass.Value> 0，(Fields！npass.Value/Fields！answ.Value * 100)，0))).当我在交互式排序中通过此表达式时，它是通过错误
无法执行Tablix"table1"的SortExpression处理.比较失败.请检查SortExpression返回的数据类型. (rsComparisonError)，但是当我使用表达式对= Math.Round((IIF(Fields！npass.Value> 0，(Fields！npass.Value/Fields！answ.Value * 100)，0))进行排序时， 它不会给出错误，但不能正确排序.

=Math.Round((IIF(Fields!npass.Value > 0 , (Fields!npass.Value / Fields!answ.Value * 100) ,0))). when i passed this expression in interactive sorting it was through error
The processing of SortExpression for the tablix ‘table1’ cannot be performed. The comparison failed. Please check the data type returned by the SortExpression. (rsComparisonError) but when i used expression for sorting =Math.Round((IIF(Fields!npass.Value > 0 , (Fields!npass.Value / Fields!answ.Value * 100) ,0))) & " %" it not give error but not sorting properly.

推荐答案

这篇关于SSRS报告中的排序列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！