Need urgent help.......
I created a custom assembly in vb.net
Public Class CustomUserId
Public Shared Function GetUserId() As String
Dim sName As String = (Principal.WindowsIdentity.GetCurrent).Name
sName = LTrim(sName)
sName = RTrim(sName)
I added the reference to this DLL in my report. Then I added textbox in my report. Added an expression:=CustomCodeHPCBM.CustomUserId.GetUserId()
Then Put the DLL in C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer(on my local machine)
Then I previewed the report. It works fine.Textbox showed the userId.
Next I put the DLL in
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin(In the report server)
I deployed the report.Then when I start the report,Textbox shows #Error.
Any idea why this is happening?