Author |
Topic |
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2013-03-12 : 05:34:49
|
Hi guys,I have a requirements to change the fill color of my report titlein 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 DatePurchid--itemid---Date--RESULT > column header |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-12 : 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 MVPhttp://visakhm.blogspot.com/ |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2013-03-12 : 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" DATASETPurchid--itemid---Date--RESULT > column header11111---HTC1235--3-11-13--OK22222---HTC1233--3-12-13--CHECK33333---HTC1235--3-13-13--OK44444---HTC1321--3-14-13--OK66635---HTC1354--3-15-13--CHECK |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-12 : 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 MVPhttp://visakhm.blogspot.com/ |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2013-03-12 : 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
478 Posts |
Posted - 2013-03-12 : 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
52326 Posts |
Posted - 2013-03-13 : 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 MVPhttp://visakhm.blogspot.com/ |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2013-03-13 : 01:01:27
|
i got an error using your recomendation.1.Right clik Text properties of report title2. 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
52326 Posts |
Posted - 2013-03-13 : 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 MVPhttp://visakhm.blogspot.com/ |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2013-03-13 : 21:54:45
|
Thank you very much. |
|
|
|