Crystal Reports column with alias is not displayed in fields secti

Message

     Hi,
I am using a stored procedure to select records for my crystal report. The data base used is sql server. My query inside the stored procedure goes like this

SELECT col1, col2, CASE WHEN (col3='S') THEN 'SUCCESS'
                                       WHEN (col3='F') THEN 'FAILURE'

                                       WHEN (col3='N') THEN 'NO RESULT'

                                       ELSE NULL
                                       AS STATUS 
FROM TABLE1 WHERE  <my conditions ...>

The fields col1 and col2 is getting displayed when i select the stored procedure as the data source. But the 'STATUS' field is not getting displayed.

Please suggest what is going wrong.

PS: In my actual query, the case statement is having around 10 conditions. Hence I am preferring to keep the case in the SP itself rather than doing it in the crystal report