for monthly reports use calendar month start and month end rather than days selected in date picker,
e.g. use 1 Jan 2012 to 31 May 2012 when user selects 5 Jan 2012 to 23 May 2012