indicator expression
hi i create report in SSRS. in that report i am having 2 columns in that report i want to compare 2 values and create indicator how to write compare expression in INDICATOR there its shows only start value and end value..where to write this expression also
May 21st, 2012 4:06am

Hi There If you are using the SQL Server 2008 then you can add indicator and put expression in the incator for red and green condition I am putting screenshot for your help If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful --indicator exp=iif(Sum(Fields!Rev_Ytd_Actual_prevmonth.Value) < Sum(Fields! Rev_Ytd_Actual_Actualmonth.Value),"red","green").
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2012 5:08am

Ya thanks for ur reply... i got good result becoz of ur reply..but i have another one probelm in that indicator.. i want to show only red indicator i dont want to show white indicator My expression: iif(Fields!BALANCE.Value > 100000,"Red",nothing) like this i gave but still i am getting that white indicator
May 28th, 2012 3:50am

Hi There Thanks for your posting. In this case you have to put the expression in the hidden property of that indicator like =iif(Fields!BALANCE.Value > 100000,false,true) If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful
Free Windows Admin Tool Kit Click here and download it now
May 28th, 2012 4:12am

Ya i tried this... but what is main problem in this ...that Border also hide when i use that expression in that hide or show option
May 28th, 2012 9:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics