By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,681 Members | 1,329 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,681 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

"Paul M." <pa**@nospam.fsnet.co.uk> wrote in message
news:bl**********@news8.svr.pol.co.uk...
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

Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.