Expression for Border Style
I have a sub report and it contains specific numbers. I'm trying to generate an solid line when a new number comes up. Below is an example of what I'm looking for.
123
123
_________
124
_________
125
125
_________
This is what I don't want.
123
____
123
____
124
____
Either this or I can do a space in between. I have tried a few things but nothing is working. Any suggestions would be greatly appreciated. thanks.
I tried to do an expression where the numbers match, then it would not generate a line, else it would. I keep getting an error when I try this though. Thanks again.
July 11th, 2008 4:09pm
Put in the bottom of border propertyIff(Previous(fields!abc.value)=Fields!abc.value , False ,True)Also Disable the upper border
Free Windows Admin Tool Kit Click here and download it now
July 11th, 2008 4:27pm
Hai
Go to the desired textbox and in the properties window go to the Border Style and in that go to the Bottom and write the expression
=IIF(Previous(Fields!A.Value)=Fields!A.Value, "None", "Solid")
July 14th, 2008 1:33am
Worked perfectly, thank you.
Free Windows Admin Tool Kit Click here and download it now
July 14th, 2008 4:20pm
Thanks.
May 30th, 2012 5:48am
unfortunately this doesn't track the very last row and draw the last mandatory bottom line....
Please help me if I am wrong. Suppose for the above particular example you will get:
123
_________
124
_________
125
125
instead of :
123
_________
124
_________
125
125
_________ <<----------notice this line you won't get I think.
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2012 6:33am