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