sql server reporting services: Use Of Custom Assembly only works in Visual Studio.... -- sql server reporting services

Use Of Custom Assembly only works in Visual Studio....

Query Builder
9/14/2005 1:50:38 PM

sql server reporting services: I am using a custom assembly that returns the logged in user's full
name. This works fine when previewing in Visual Studio, but not working
when viewing the report on a browser.

The steps I did...

1. Installed Custom Assembly.
2. Referenced custom Assembly in Report / Reports Properties /
References.
3. Set the value in a textbox =" Report Generated By : " &
NameSpace.Class.StaticFunction()

This works fine inside a Visual Studio Preview window. It returns the
logged user who is executing the report. But when a user goes and
accesses this report thru the web browser he / she gets an #Error in
the text box (its not crashing the page or returning a page error).

Can someone help me????

Thanks..!

Re: Use Of Custom Assembly only works in Visual Studio....

Bruce L-C [MVP]
9/14/2005 4:06:36 PM

I can point you in the right direction but I can't give you all the steps
because I haven't done it. The issue is security. In the development
environment your assembly has the rights it needs to execute this. It does
not in the runtime environment. This at least gets you going.

By the way, do you know about the User!UserID global variable? You can use
that in expressions.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]