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 |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2008-07-28 : 23:51:12
|
| Hi Guys,I am having a column named SALARY in my report. Its values are something like this: SALARY$18972734.6543 $1876.7688 $62543.8800 $100.0526 Now I want to display that column in the following manner: SALARY$18972734.6543$ 1876.7688$ 62543.8800$ 100.0526 i.e. I want all the dollar sign to be displayed on the same line..Any clues how to write expression for this in the expression editor???Thanks,Raaj...... |
|
|
mrm23
Posting Yak Master
198 Posts |
Posted - 2008-07-29 : 07:11:02
|
| is the $ sign present in the table itself?if not, then u can concatenate "$" & salary with a space in between.If this is kept in the layout, then u can align it to left....its just a guess... |
 |
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-07-29 : 17:35:34
|
| Hi...Thnx for u r reply...$ sign is not present in the table....I have written in the Format area as C2 to display Currency with 2 decimal places...ThanksRaaj....... |
|
|
|
|
|
|
to display properly...