sql server reporting services: SSRS @parameter passed to function or procedure -- sql server reporting services

Re: SSRS @parameter passed to function or procedure

WillC
6/14/2005 2:20:04 PM

I mistyped my message, but you are right it should be dbo.fnRegProgress. I
got it working. It works if I only return a scalar value.

[quoted text, click to view]

Re: SSRS @parameter passed to function or procedure

Bruce L-C [MVP]
6/14/2005 3:37:14 PM

My guess is that you have not set the permissions on the function. Also, you
might need to say dbo.fnRegProgress

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: SSRS @parameter passed to function or procedure

david.bailey NO[at]SPAM amsouth.com
6/16/2005 8:11:59 AM

You can return non-scalar values by calling something like this:

select * from fnRegProgress(regId, @beginDate, @endDate)

if you define your function to return. I regularly use this to return
table structures for authorization.

select branch, branchname from fnUserBranch(@userid)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.