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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics