November 17, 2011 at 8:39 pm
hi
i have the following data in report. and the report has parameter threshold value.when user enter threshold value as 50 it should highlite the cost column in yellow color at mod level >=80 and below parts for that mod only.
SKUMODPART COST
100120
10011130
100111123450
10011123430
10022280
10022245630
100222567340
output
SKUMODPART COST
100120
10011130
100111123450 this should not be colored as mod level above value is 30 which is<80
10011123430this should not be colored
10022280-- this 80 should be colored
10022245630--this should be colored
100222567340--this should be colored
plzz help how to achieve as i have tried its highlighting all parts which should not be the case it should highlight only parts which comes under mod and satisfies threshold entered parameter
November 18, 2011 at 1:26 am
I'm not sure if I understand your requirement correctly but something like this should work:
Select the font color for your textbox and enter an expression similar to this:
=IIF(Fields!Mod.Value<80,"Black","Red")
[font="Verdana"]Markus Bohse[/font]
November 18, 2011 at 10:54 am
yes i tried with the condition its not working
as a said when i enter level as mod and threshold value as 80 it should color last 3 records i.,e where part_num is null and below 2 records where part_num is not null
i.e the parent (mod) record and 2 child records
how to get all the child records colored when parent record satisfies the condition
November 18, 2011 at 11:03 pm
guys can any one help hoe to color all child records of a parent rrecords
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply