I have report which calls parameterised SP. when i preview/debug/run the report i see three two box and one date control where i enter the values and view the report ,I can see the report correctlly. My client asked me to put dropdown instead of text box. Now I created two data set ,and changed parameter property to get values from query. and put respective dataset,value field and lable field. now the problem is: 1> when i preview the report i can see the dropdown correctlly field but when I click view report, i can see report header and table heading but CANNOT SEE THE RECORDS.
PS:- Visual Studio 2008 SQl server 2008 R2