No one can help me on this prolem??????

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

Hi R,

I had tried this before. I created a EmployeeDS tha include all possible employee names, and set the avalable value for 'from query' (EmployeeDS), and set the default value as null.

When the report running, the dropdown value list included all possible value of the Employee names with checkboxes beside them, and the values I passed through my web app were checked(selected). and this is no what I want. What I want is show what I pass from the Web app with checkbox and give user the choice.

Thank you so much!

Could somebody give me further idea if any

Thanks a lot!

Jone

Hi Jordi,

Thanks for your message.

Actually, I had tried this before if I don't misundstand what you sugested.

1. created @Employee at report side and passed the value{n1,n2,...,nk} to it from web app;

2. created @EmployeeName at report isde and set its value come from =parameters!Employee.Value, lable = parameters!Employee. Lable

or.

2. created a dataset select EmployeeName from tableName where EmployeeName IN (@Employee), then, created @EmployeeName and set its value come from this dataset

when the report was running, I had been able to get the values I wanted {n1,n2,...,nk} just liked what I passed from the web app with checkboxes beside them, but after I checked some of them and clicked "view report", the values in the @EmployeeName always showed the default value I set when created it (e.g., the value came back to 'Null' if the default value was 'Null', or 'n1,n2' if the default value was 'n1,n2') and the result report came out agains the default value.

It really comfuse me!

Did I do something wrong

Any response will be appreciated!!!!

Jone

Does somebody know how to handle it

Thanks,

Jone