Again Posting with more information -
I am working on TFS 2010 Report with Report Builder 3.0.
I need to fetch data on basis of Start Task Date(means when user start their task).
So i have added a new field in a TFS Work Item Template with name StartTaskDate.
Now i have created new DataSet in ReportBuilder where i have taken StartTaskDate as a Parameter(Inclusive Date Range).
This Parameter have created automatically 2 DatePicker parameter in Report.
I have changed Format of Parameter in DataSet properties .mention below-
="[Work Item].[System_CreatedDate].&[" + Format(CDate(Parameters!ToWorkItemSystemCreatedDate.Value), "yyyy-MM-dd")+"T00:00:00]"
Now i am trying to search data between 2 dates from DatePicker .
For Example if i created a Task on 5/8/2014 and when i have take Date Range from 1/8/2014 to 6/8/2014 then didn't get 5/8/2014 data in result but when i taken range from 1/8/2014 to 5/8/2014 then i got the 5/8/2014 date data.
in mdx query i have taken below mwntion query -
SELECT ( STRTOMEMBER(@FromDate) : STRTOMEMBER(@ToDate) )
At last my issue is i am not getting correct result set.
Please let me know if need more info.