December 8, 2015 at 7:59 am
hi all,
in my SSRS reporting I have one column called db_owner. the report is grouped by database name im trying to generate the total number of the access lever user for each database . after design the report and click preview you can see the drill down report which is group by database ,initially it's display the total number for each database when you click "+" to drill down then you can see all the details .so now the problem is I set this column if the value =1 then highlight this cell as pink it works fine but some of the total number of this column turns pink for other database also. I don't know why.. can anyone help me out?
This is the expression that I use->=iif(fields!db_owner.Value =1,"Pink","White")
1 more question: how can I make total color as grey and when someone click "+" then turn white?
Thank you
austin
December 8, 2015 at 12:32 pm
I figure it out.
using below expression:
=iif((fields!db_owner.Value) =1 and fields!db_owner.Value = sum(fields!db_owner.Value),"Pink","White")
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply