Hello,
Not sure if I am in the right place here, so please for give me.
I have a CR that uses a stored procedure as the data source.
I am having a difficult time getting this to work with.
I am using VS 2005 with the built in CR's, I have a stored procedure on an SQL 2000 server that takes one parameter. The parameter is passed as string "Call = Request.QueryString["Call"];", but getting this to be accepted into the stored proc is a pain.
I have built the connectin string into my WebConfig file, this also holds the "impersonate" tag to assist in authentication.
I have added numerous assemblies to the web config file also.
I can get the page to ope that the report is on but I get so many errors that it is hard to know which way to go.
I though a good start would be to get the login sorted first, then work on the acceptance of parameters.
So any one that has a working example of this process I will be really interested in some assistance.
PS: I have tried multiple online tutorials that have all failed - dismally I might add.
Thanks in advance
Jag