Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sz1
Aged Yak Warrior
555 Posts |
 Posted - 2013-02-26 : 10:05:47
|
| HiI have created several columns with expressions, not actual fields, how do I call a column thats not in the dataset? so a column called Test for example, how would I call this to work out conditional formatting?ThanksSZ1Learning and development is the driving force in the universe...! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-26 : 22:59:43
|
| you can call it using ReportItems collectionReportItems!Textboxname.value etcalso if you're trying to set conditional formatting for same textbox and has to invoke its own content use Me.value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2013-02-27 : 05:08:37
|
| ThanksCan you show me an example using the Me.value for conditional formatting, thanks.SZ1Learning and development is the driving force in the universe...! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-27 : 05:14:44
|
| =IIF(Me.value <0,"Red","Black")set the above expression inside font color property of textbox to make negative values appear in red------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2013-02-27 : 05:38:43
|
| Ok so the Me.value looks at its own cell/data...ThanksSZ1Learning and development is the driving force in the universe...! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-27 : 23:17:56
|
| yep...it does------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Call Column