Hi all, I have a report with parameters @START_DATE DATETIME @END_DATE DATETIME, @SUPERVISOR as int, @EMPLOYEE as int, @MEASURES as varchar(4000)) and i created different data sets for each of these parameters. For Employee data set i have to use existing stored proc, which has bellow parameters. @START_DATE datetime @END_DATE datetime @SupID varchar(4000 @CENTER varchar(10 @TITLE VARCHAR(10) So parameters are same but they are differ in spellings. So they are populating twice when preview report. Also i can't modify existing S.P becasue some other reports are using it. Please suggest me. Thanks in advance Jyo ), ), , , , (

Hi Jyo1105, Thanks for your question. According to your description, my understanding is that the previous five parameters’ values relied on five different Datasets, you using these five parameters as the stored procedure’s arguments passed, right? If I misunderstand your question, please let me know. In this condition, the previous five parameters using the five Datasets to obtain the available values or default values, finally, the stored procedure uses the values. The parameters populating twice for different uses, this is a continuous process, so in my opinion, there is no unusual. Is there anything I misunderstand you? Please don't hesitate to let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.