Re: adp report does not recognize fields from stored procedure

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks for your reply. A co-worker found a silly mistake in my report design.
I left out the equal sign on a text field where I am using IIF. I still
don't get the field list, which I assume is because the SP is performing
multiple tasks, but my report runs now.

Thanks again.

Norman Yuan wrote:
Posting your SP may help other help you.

Just wild guess: add "SET NOCOUNT ON" at the beginning of your SP?

I am using AccessXP and SQLServer 2000.

[quoted text clipped - 14 lines]

Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200705/1

.