[Question] Crystal / VB ASP .net / Stored Procedure


P

Paul M.

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
 
Ad

Advertisements

P

Paul M.

The answer (as I have just found out!) is to put the line "SET NOCOUNT ON"
at the start of the SP as the rows affected figure returned by action
quesries prior to the main (and final select) counts as a recordset return
and therefore the any after are discounted.

Cheers
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top