Reporting on Sparse Date Data By Yuli Vasiliev You may need to generate a row per hour within a certain day or generate a row per day within a certain date range. Often you need a report showing every date/time position within the entire range, regardless of whether there was an activity on a particular day or hour, or not….