| Author |
 Topic  |
|
|
Villanuev
Constraint Violating Yak Guru
311 Posts |
 Posted - 03/12/2013 : 05:34:49
|
Hi guys,
I have a requirements to change the fill color of my report title
in my dataset "OpenRAW" i have a field name RESULT.
Under Result fieldname, it contains data "OK" and "CHECK-100"
I have to evaluate if there is a word or it contains "CHECK-100" or "CHECK" in the RESULT field.
then i will change the default fill color of my report header into Red color. thank you in advance..
-------------
OPEN PO --- report title > need to change the fill color if the RESULT field contains "CHECK-100" or "CHECK"
------------
My Date
Purchid--itemid---Date--RESULT > column header
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47173 Posts |
Posted - 03/12/2013 : 05:39:26
|
SO does OpenRAW only have single record always? if there are mutiples how will you determine which one to be considered based on which you've manipulate report title color? or is it that value of RESULT field will be same across?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
Villanuev
Constraint Violating Yak Guru
311 Posts |
Posted - 03/12/2013 : 06:00:42
|
Hi Visakh,
Here is the content of my OPENRAW dataset. it came from the value of RESULT fields.
its possible to scan the RESULT field? once it detect a "CHECK" the fill color will change.
"OPENRAW" DATASET
Purchid--itemid---Date--RESULT > column header
11111---HTC1235--3-11-13--OK
22222---HTC1233--3-12-13--CHECK
33333---HTC1235--3-13-13--OK
44444---HTC1321--3-14-13--OK
66635---HTC1354--3-15-13--CHECK
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47173 Posts |
Posted - 03/12/2013 : 06:41:29
|
but you've both CHECK and OK coming here isnt it? in that case , what would be your report title color?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
Villanuev
Constraint Violating Yak Guru
311 Posts |
Posted - 03/12/2013 : 20:15:04
|
| My Report Title would be "OPEN PO". Its either i will change the font color or change the back ground (fill color) into red color. If the result field has contains "CHECK". present background color is Light blue. thanks. |
|
|
|
Villanuev
Constraint Violating Yak Guru
311 Posts |
Posted - 03/12/2013 : 23:44:28
|
i make some modification and here is the result.
I'd make another dataset that contains only field RESULT.
then i made an script filtering only those with "CHECK"
after doing this i used this dataset to my table header and it's working.
=IIF(First(Fields!RESULT.Value, "CheckDS)="CHeck",Red","#003366")
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47173 Posts |
Posted - 03/13/2013 : 00:25:48
|
nope..this wont work always. In case you have a value CHECK in dataset but its not first value it will still show the color as #003366.
I think based on your earlier sample data what you need is this
=IIF(SUM(IIF(Fields!RESULT.Value="CHeck",1,0), "CheckDS)>0,Red","#003366")
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
Villanuev
Constraint Violating Yak Guru
311 Posts |
Posted - 03/13/2013 : 01:01:27
|
i got an error using your recomendation.
1.Right clik Text properties of report title
2. click text box properties ---> Fill--Fill Color Expression-->Set expression for background color
=IIF(SUM(IIF(Fields!RESULT.Value="CHeck",1,0), "CheckDS)>0,Red","#003366")
The BackgroundColor expression for the text box ‘Textbox10’ uses an aggregate expression with an invalid recursive/simple flag. The valid values for this flag are ‘Recursive’ and ‘Simple’. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47173 Posts |
Posted - 03/13/2013 : 02:08:53
|
the below is wrking fine for me.
=IIF(SUM(IIF(Fields!RESULT.Value LIKE "CHeck*",1,0), "DataSetName")>0,"Red","Green")
I'm using this expression fro Backgroundcolor property available from properties window by selecting textbox and clicking show properties icon on top.
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
Villanuev
Constraint Violating Yak Guru
311 Posts |
Posted - 03/13/2013 : 21:54:45
|
| Thank you very much. |
|
|
| |
Topic |
|
SSRS change fill color on report title
