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 |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2008-03-11 : 11:41:41
|
| Expresion for the Text Box=Round((Fields!Deliveries.Value-Fields!Net_Receipts.Value)/Fields!Deliveries.Value*100,2)Properties for the Text Box=CDec(Fields!Deliveries.Value -Fields!Net_Receipts.Value /Fields!Deliveries.Value) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-11 : 11:43:55
|
| Ok..so wats your question? |
 |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-03-11 : 11:43:56
|
| Hi Group:I need help with the following the first one is the Expression for the Column that give all the results as a percentage. I need two things: 1. That if the number for that percentage is negative ---- I need this number in parentesis example (-25) 2. If is negative I also want the number and the parenthesis in red. Expresion for the Text Box=Round((Fields!Deliveries.Value-Fields!Net_Receipts.Value)/Fields!Deliveries.Value*100,2)Properties for the Text Box=CDec(Fields!Deliveries.Value -Fields!Net_Receipts.Value /Fields!Deliveries.Value)Thanks for the help |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-11 : 11:52:16
|
| 1. Use this as expression inside Format code property by right clicking on cell, taking properties and Format tab.="#.##%;(-#.##%)"2.Use the same format as above. Also write below expression for color proprety=IIF(Me.Value >=0,"Black","Red") |
|
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-03-11 : 12:24:03
|
| Thank You visakh16 ---- :) I appreciate your help |
|
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-03-11 : 12:44:10
|
| Visakh16I have this inside the Expression for the Deliveries- I have an #Error when I try to use the second part of the expression inside the textbox. =Round((Fields!Deliveries.Value-Fields!Net_Receipts.Value)/Fields!Deliveries.Value*100,2)=IIF(Me.Value >=0,"Black","Red")Thanks for your help :) |
|
|
|
|
|
|
Format colors