Eugene Elutin (7/21/2010)
Have you tried to use the column from the DataSet used for report to populate the Paramaeter ListBox? Does it works at all?
Yes i have done that and it woks, but the parameter dropdownlist has duplication values, and thats what i want to overcome.
Eugene Elutin (7/21/2010)
I suggets you creating separate DataSet as SELEct DISTINCT Col2 FROM YoutrTable, and then use it in Available Values for your report Parameter.
Now thats where the problem is. Can i have two completely seperate SQL queries in a single report dataset? I have tried adding one query just after the other and it cause an error.
Do you know how to define two completely separate queries in a single SQL SERVER 2005 reporting services report??.
I hear support for multiple datasets is only avaialable in sql server 2008