So I followed your instructions from chapter 9.12, Linking to a stored procedure... It worked like you said it would (after I fixed a little type mis-match). I thought, "finally... the frustration is over" But Oh-No...

Now what happens is the prompt still appears and even if I enter input I get that stupid "missing parameter field..." error.

Has anyone else run into this? if so is there a solution / work around... Believe me I followed the book to the letter - the only difference was in the book you have @CustomerId, I have @ProspectId.

Thanks

I'm sorry - when I fixed the type mismatch it worked in that my drop down list showed me the variable that I wanted which was of course the argument for the stored procedure. before I was not seeing that.

So if you look at the links I have set up in my main report you see that subreport field to link to is ?@ProspectID

Have a look at http://www.refreshless.net/subReportLink.jpg and you will see that other than the variable name it looks like the screen shot from your book.

Hope I cleared that up.

Thanks!