SSRS 2008 R2 - Interactive Sort expression is not able to access custom code variable

Question

Hi All,

I have a tablix filling data based on value returned from custom code

i.e. IIF(Code.one = "something", Fields!val1.Value, Fields!val2.Value)

this works fine and data shows up all right; however when i put the same expression in Interactive Sort Expression - it fails to work.

I have tried writing another function to return me what Code.one does {Code.GetThatValue(1)} and also tried to set the same value in a report variable and accessing like {Variables!one.Value}, but nothing works.

It seems like Interactive sort expression can`t access anything more then a "const" variable from the custom code.

Is it another bug in SSRS?

Answer 1

hello,

why not create a calculated field in your dataset using your expression and then make that calculated field your interactive sort field?

---

Hope this helps! k r o o t z

Answer 2

Hello,

hope this will help:

http://social.msdn.microsoft.com/Forums/pl/sqlreportingservices/thread/911a7430-fc06-460f-9797-89f768153718?prof=required

Regards,

Summer