April 6, 2012 at 1:02 pm
I am working in SSRS 2005 and designing reports with BIDS. I created an Expression to dynamically set BorderStyle properties on textboxes. However, its not working. I read in another forum somewhere that BorderStyle doesn't support Expressions....
Can anyone confirm/deny this? Or tell me how to make it work?
thanks
David
April 10, 2012 at 4:50 am
It surely works in 2008.
What is your expression?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 11, 2012 at 9:15 am
I'm seeing the same problem - unable to generate dynamic border..
Border Color:
=IIF(Fields!CallerID.Value = "198.175.95.48","Red","DimGray")
Border Style:
=IIF(Fields!CallerID.Value = "198.175.95.48","Solid","Dashed")
Border width:
set to 2pt
I set custom font color in several reports and assumed that I could 'box' an interest point -
Any ideas? Thanks
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 11, 2012 at 9:51 am
Koen Verbeeck (4/10/2012)
It surely works in 2008.What is your expression?
=First(Fields!GROUP9_BORDER_LEFT.Value, "ROW_FORMAT")
Its the same basic expression that I use to set the Font, Font Color, Format, Background Color, etc... and they all work fine.
April 11, 2012 at 10:15 am
Tom,
Are you working on 2005, or in 2008?
David
April 11, 2012 at 10:17 am
vs2008, SS2008R2
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply