Hi,
   I have a Crystal Report that I want to have use as its datasource a
SQLServer 2000 stored procedure, basically the sp would do several selects
to insert data from several tables into 1 temp table (first letter of temp
table name = #) then the last thing I do is select * from #temptable.
However Crystal can not see in the VB .net IDE any fields just the SP. If
all I do is create the temp table and then do select * from #temptable I can
see the fields in the SP when I add the SP to Crystal within the VB IDE.
Obviously doing the latter is no good as I need to do several selects prior
to the last one to populate my temp table.

Anyone got any ideas?

Thanks
Paul