Date Range Report - Didn't get correct Result Set

• rohitnegi09

  Valued Member

  Points: 68

  More actions

  August 5, 2014 at 1:12 pm

  #310542

  Hi All,

  i am doing search through Date Range but didn't get correct result.

  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 got the 5th Date data.

  I am taking Range Inclusive Operator(:).

  SELECT ( STRTOMEMBER(@FromDate) : STRTOMEMBER(@ToDate) )

  I need help ASAP.

  Thanks.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  August 5, 2014 at 1:29 pm

  #1735359

  rohitnegi09 (8/5/2014)

  ---

  Hi All,

  i am doing search through Date Range but didn't get correct result.

  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 got the 5th Date data.

  I am taking Range Inclusive Operator(:).

  SELECT ( STRTOMEMBER(@FromDate) : STRTOMEMBER(@ToDate) )

  I need help ASAP.

  Thanks.

  I really can't help with SSRS that much but I can tell you that there is not enough information in the post above to even give you a shot in the dark. We can't see what you see so you really need to provide us with more information if you actually expect an answer.

  You can start by reading the first article I link to in my signature block below. It will walk you through everything you need to post and how to post it to get the best possible answers to your question.

• rohitnegi09

  Valued Member

  Points: 68

  More actions

  August 5, 2014 at 2:00 pm

  #1735367

  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.