SSRS Report Parameter

• Lookup_BI

  SSCrazy

  Points: 2964

  More actions

  June 12, 2008 at 2:40 pm

  #187095

  All,:(

  I have a report that needs to return a number of columns from a table based on 2 parameters [StartDate & EndDate [datetime]].

  Here is my dataset

  Select * from table1 where start_date between @StartDate and @Enddate.

  In table1 [start_date datetime ,example value=[3/6/2008 6:41:47 PM]]

  My problem is how do I convert the start_date to [3/6/2008] within my Dataset.

  Something like the below.

  Select * from table1 where convert(varchar(10),start_date,111) between @StartDate and @Enddate.

  The reason for doing this is because when I pick, StartDate as 01/01/2008 and EndDate as 1/31/2008.My report only return's values of 01/01/2008 to 01/30/2008.The items that falls on 1/31/2008 do not get displayed as the datasets does not consider time when comparing,but only the date part.

  Do give me a suggestion,solution to convert Start_date to only date and then check the BETWEEN .Thank You in advance!

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

• Lookup_BI

  SSCrazy

  Points: 2964

  More actions

  June 13, 2008 at 8:39 am

  #828551

  Got it solved with the below.

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104764

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]