Okay the problem I am having is pretty strange. I have a Crystal Report that is using the ODBC connection with a view and a SQL command together. The report is pulling fiscal periods and I need to be able to show an end user what month the fiscal period represents. In other words, if the fiscal period is '01' then the month is July. There is a fiscal period in the view but there it does not say what month it is.

This is where my SQL Command is used. It does a decode statement so that I can use the actual month for the parameter prompt for the user.

My problem is now I have to change the source from the ODBC connection to the Oracle Server. Now, the report does not work correctly using the SQL Command. It is not pulling anything at all.

For reference, here is the SQL Command that I am using (I am linking this SQL Command to the view using the fields FISCAL_YEAR and FISCAL_PERIOD):
<SQL Command>
SELECT DISTINCT fiscal_year, fiscal_period, DECODE(fiscal_period, '00', 'Beginning Balance', '01', 'July', '02', 'August', '03', 'September', '04', 'October', '05', 'November', '06', 'December', '07', 'January', '08', 'February', '09', 'March', '10', 'April', '11', 'May', '12', 'June') "MONTH"
FROM af_operating_ledger
WHERE fiscal_period_status = 'O' or fiscal_period_status = 'C'
ORDER BY fiscal_year, fiscal_period
</SQL Command>

Why would the report stop working because of the SQL Command in Oracle Server? What is different between using the ODBC connection and the Oracle Server connection in Crystal Reports that would cause this SQL Command to stop working?

Any help would be much appreciated,
Grim