Crystal Report: Stored Procedure and Temporary Table

[arock]

I've created a SQL Server stored procedure that uses a temporary table
(#tempTable) to run some sub-queries within the main SELECT statement.
This works perfectly fine within the Crystal Designer environment
(version 9.0). However, when I run this report via an ASP web page the
fields that are using the temporary table show up blank, while the
other fields show up fine that are not referencing this temporary
table. Why does it work fine in the design environment but not on the
ASP web page? I can provide more details if necessary.