I hope you good All: I have ASP Webform with C# & SQL2005 Iwant report depend on duration (start to end date)from tow calander controls about some person in dropdownlist1 (person1,person2,person3,person4) example: if Iwante a report about the work of person3 in 1/1/2012 to 1/6/2012 I hope you know my idea thank you

Please calrify more...Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi, Create another dataset which pulls the data of persons on the given date range e.g select person from your table where date between @yourstartDate and your @endDate then map your @yourstartDate and your @endDate with person dataset . See these link will help you http://msdn.microsoft.com/en-us/library/aa337169(v=sql.100).aspx http://beyondrelational.com/modules/2/blogs/101/posts/13370/ssrs-51-using-parameters-in-ssrs-cascading-parameter-2.aspx Hope this will help you !!! Sanjeewan

Thank you Sanjeewan: because I'm new give me full C# code if you can.