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 |
|
Dek
Starting Member
7 Posts |
 Posted - 2001-12-05 : 11:35:05
|
| I have a column called commision.Now some employees do not earn a commision.I am developing a report.I have used set command i.eSET NULL 0.00Now the problem is that the output for 0.00 is left indentedand numbering is generally defualt to be right indented.This causes the report to like the followingDate.. Report Headingcolum1 | column2 | commission | Salary... .... 0.00 30,000... .... 3,000 55,000... .... 0.00 50,000.... .... 0.00 60,000How can I line the commision 0.00 with the values |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2001-12-18 : 00:45:52
|
| Try using the IsNull() function.-Chad |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2001-12-18 : 04:04:59
|
| What is this SET NULL command Dek? Can you show us your code?--HTH,VyasCheck out my SQL Server site @http://vyaskn.tripod.com |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2001-12-18 : 08:47:54
|
Oracle. Dek posts questions about Oracle report writing in the vain hope that someone here will get fed up and learn Oracle to help him. It hasn't worked yet  |
|
|
|
|
|
|
re: columns and report