No One Can Help Me On This Prolem??????

Feb 6, 2007

or it may be too simple to care about?

My scenario is:

I want to pass a multi-value parameter, Employee, with value set string[]{n1,n2,..,nk} to the report1. {n1,n2,..,nk} is a subset of whole employee name set {n1,n2,...,nk,...,nm}(k<=m), and it value is based on the user's access.

when user open the report1, he/she can select one or more user name from the Employee dropdown value list.

my problem is, there's no checkbox at the leftside of the Employee values to let user choose the value, so all the {n1,n2,..,nk} are selected as the value of @Employee.

I spent time on setting 'Available values' uner "Report-->Report Paramters-->Employee", but can't get what I want.

P.S., I do check the 'multi-value' for @Employee

I think it should not be a complex one, but I am unluky.

Could somebody give a suggetion or idea?

Thanks a lot

Jone

View 5 Replies


ADVERTISEMENT

Prolem With Create Login From Asymmetric Key

Feb 26, 2007

Greetings...

I'm trying to create assembly with "PERMISSION_SET = UNSAFE".
For that I've signed assembly's .dll and installed root certificate to €œTrusted Root Certificate Authority.€?: http://www.sqljunkies.com/WebLog/ktegels/articles/SigningSQLCLRAssemblies.aspx
now I'm trying to create login from asymmetric key:

USE master
GO

CREATE ASYMMETRIC KEY SQLCLRTestKey
FROM EXECUTABLE FILE = 'C:Documents and SettingsAll UsersDocumentshunterStoredProcedures.dll'
CREATE LOGIN SQLCLRTestLogin
FROM ASYMMETRIC KEY SQLCLRTestKey

but I'm receiving error: "Cannot find the asymmetric key 'SQLCLRTestKey', because it does not exist or you do not have permission."


What's wrong?

Best regards...

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved