Last post Nov 11, 2011 03:43 PM by jeeveshfuloria08
Nov 09, 2011 09:25 AM|pdusp|LINK
On the bottom lines 4 rows have empty columns. So I have idea to do not print border line for them.
I preapred simple expresion for border but it doesn't work.
Maybe somebody Expert wants to help me?
TextBox properties for its style I wrote:
Have a nice day!
Nov 09, 2011 11:47 PM|Srikanth Kasturi|LINK
You can try putting like this in the xpression for borders.
=iff((Fields!komponent.Value) is Nothing,"None","SOLID")
But frankly, this might not look good when there are no borders in your report.
Nov 10, 2011 08:20 AM|pdusp|LINK
Thank you, Dear Srikanth!
I found Microsoft Error in RS2008. It would be ask you to test how your RS works?
I select one cell and set properties for border.
The next insert your expression - everything is ok.
When I open it again it still have Solid. No mather when you write None in Expression and open it again it has always Solid.
I think it is bug in system or my RS2008 has local problem.
Nov 10, 2011 08:29 AM|Srikanth Kasturi|LINK
Pardon me pdusp,
That shud be
=IIF((Fields!komponent.Value) is Nothing,"None","SOLID")
i misplaced, IIF with IFF..
Give a try. !
Nov 10, 2011 08:38 AM|pdusp|LINK
Yes! it should be IIF
but after click OK and open it again RS forgets and show SOLID.
Does your RS work well?
Pleas test I will very grateful.
Nov 11, 2011 03:43 PM|jeeveshfuloria08|LINK
don't use right click and then textbox property, then border and putting some expression.
use this step i hope you will get correct border based on column value.
select(highlight) the textbox and go to properties windows, there you will find border color property, expand the property and put the expression in each section whatever require default,top,bottom,left,right =IIF((Fields!no.Value) is Nothing,"White","Black").
now if you see the preview of report, i hope you will not get border for blank value.