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 |
|
jneff02
Starting Member
10 Posts |
 Posted - 2009-11-20 : 15:55:36
|
| I'm not sure if this is possible but I was asked to try. I have a report that is working wonderfully but they were looking to have individual rows show with bold text. The rows are ordered by equipment Make. We want to select certain Equipment Numbers and Bold the entire row if the Equipment Number matches the criteria. I was researching this and found that under the layout tab in visual studio if I put the proper expression in for the FontWeight property it should do what I'm looking for....I think. Below is what I tried using and it accepts the expression but doesn't bold the row. Any thoughts? =IIF(Fields!Equipment_.Value(4778) = True, "Bold", "Normal")Thanks in advance!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-22 : 01:27:05
|
| what does 4778 represent? |
 |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-11-23 : 08:16:08
|
| If 4778 is the value you are testing for it would be:=IIF(Fields!Equipment_.Value="4778", "Bold", "Normal")JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
jneff02
Starting Member
10 Posts |
Posted - 2009-11-23 : 12:02:17
|
| Yes, 4778 is an example of a Value for Equipment Numbers that we want to bold. Sorry that I didn't specify that earlier. JCirocco, the expression you gave me did work! I appreciate the work guys!Thank you, Jared |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-23 : 12:07:45
|
| if its numeric no need of "" around |
|
|
|
|
|
|
bolding select rows by fiield value