report should take last day into account