April 16, 2008 at 11:22 am
I have a requirement to use the logged on users id to extract the store number they belong to,
to pass as a parameter to the stored procedure. I am using and have added a reference to system.directoryservices.dll
assembly. All works great in development, preview. From either debug mode or from the report server I get the
following error message...
Error during processing of ‘Store’ report parameter. (rsReportParameterProcessingError)
I have copied the assembly to the server and added it to the gac.
I have added the following entry to the rssrvpolicy.config on the report server, stopped and restarted it.
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="AssemblyCodeGroup"
Description="A code group for my custom assembly.">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="c:\windows\microsoft.NET\framework\v2.0.50727\System.DirectoryServices.dll"
/>
Am I missing something else??? Need HELP ASAP.
April 16, 2008 at 11:59 am
If you are either connected to the server via terminal services, or actually sitting at the server console when you try to run the report, does it work?
April 16, 2008 at 12:21 pm
Either way, same error message.
April 16, 2008 at 12:47 pm
Why not just use UserID global variable?
Ben Sullins
bensullins.com
Beer is my primary key...
April 16, 2008 at 1:05 pm
For example: my login id is my employee #. My employee number does not tell the report which store I am from. I use the login id and some custom code in the report to extract the store number from active directory entries.
Like I said, the preview works fine in development. It extracts the store number just fine. Just production or debug does not work.
April 16, 2008 at 1:59 pm
Ah...gotcha...
Well, You shouldn't need to modify the config entries at all for this to work. From my experience all I had to do with custom assemblies was to upload the dll to the bin directory in the Report Server program folder. Also to apply config changes you need to restart IIS as well as the reporting service.
Good Luck!
Ben Sullins
bensullins.com
Beer is my primary key...
April 16, 2008 at 3:25 pm
Yeah, restarted iis as well, still no worky.
April 16, 2008 at 3:50 pm
Do this...
Add it to the Bin directory locally and when you add the reference to it from the report make sure it is looking for it in that Bin directory.
Also, did you look through all the documentation on MSDN?
http://msdn2.microsoft.com/en-us/library/ms153561.aspx
Ben Sullins
bensullins.com
Beer is my primary key...
April 17, 2008 at 9:17 am
Yes, I checked all of the docs on the MSDN Website. I have done everything recommended. Still no worky....
April 21, 2009 at 10:19 am
I ended up resolving this by calling a stored procedure that extracts the store number from active directory instead of using the .dll. Everything works great now!!!
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply