1,867
Hello
I add this expression on matrix on ssrs report:
=IIF(Parameters!BOMCalcTransDetailDS_parmOrderByCalc.Value = "TRUE", Fields!PriceCalcId, Fields!LineNum)
I'm sure that BOMCalcTransDetailDS_parmOrderByCalc.Value returns TRUE of FALSE but report returns this error:
Sort expression used on 'MainTablix' returns a type data that is not valid. (rsInvalidExpressionDataType)
I want order by field PriceCalcId or linenum depend on parameter OrderByCalc.
Somebody can help me?
thanks
Are you sure that OrderByCalc is a text field containing the text "TRUE"? Isn't is an enum field instead? And if it isn't an enum, shouldn't it?
1. You don't need double quotes for the keyword true (in the expression)
2. check ifBOMCalcTransDetailDS_parmOrderByCalc.Value returns TRUE indeed, by just showing it in the report design somewhere..
(also compare this with an infolog from the DP class (if applicable)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (