I need to create 2 reports, those are daily and monthly reports. scenario is i have a date parameter, if i select the date ex: 11/04/2010. i need to grab the data from 11/03/2010 5:30 PM to 11/04/2010 5:29 AM. for daily report iam using the scenario through ssrs main dataset is DECLARE @DT datetime SET @DT = SUBSTRING(convert(varchar(12),(DATEADD(d,0,(convert(datetime,@DTinDate+' 00:00:00.000')))),120),0,12)+ +'17:29:00.000' DECLARE @DT1 VARCHAR(100) SET @DT1 =SUBSTRING(convert(varchar(12),(DATEADD(d,-1,(convert(datetime,@DTinDate+' 00:00:00.000')))),120),0,12)+ +'17:30:00.000' select * from from table where DT>=@DT1 AND DT<=@DT another datset is used to pull the DT to use in main dataset select distinct substring(convert(varchar(12),DT,120),0,12) AS Date FROM table. based on above scnario iam getting exact results like if select date parameter: 11/04/2010. reportgenerated data from 11/03/2010 5:30 PM to 11/04/2010 5:29 AM ( in main dataset added time with 24hr format) Now my question is i need create monthly report for above scenario in monthly report i have parameter called reportmonth,date also .if i select any month like october data should have like above criteria. so how to split the date wise data ( criteria : 11/04/2010. i need to grab the data from 11/03/2010 5:30 PM to 11/04/2010 5:29 AM.) with in monthly report for specified login and logout for specified month. help me how to implement the monthly reprot scenario Thanks in advance

Hi, "in monthly report i have parameter called reportmonth,date also .if i select any month like october data should have like above criteria." what are the start and end datetimes to grab the data if you select October? thanks, Jerry