Joined: 26 Aug 2014
Location: United States
Online Status: Offline
Posts: 2
Topic: Show group headers even when no records Posted: 09 Sep 2014 at 6:26am
I am trying to get a report to show what are basically group headers with or without records. I have interval based headers 8:30a,9:30a, etc and I ideally if my employees are performing correctly I should have records in each group. I would like to see group headers with no records so I can spot opporunities for coaching where nothing was done.
I need to filter the records in the table with the data so left joining to a table of headers has not worked.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 17 Sep 2014 at 5:06am
since there are no records, there is not any data for the header either...probably.
what you would need to do is get an empty row in the data. If you had a table of times, and then left joined to that for who was in each time period, then your headers should show up (providing that the headers are times).
If you use a stored proc, you could add in empty rows, a left join might do, depends on what you have to work with and/or what you can do in the database...like creating a table of time intervals (if that idea works for you). I know that not every report writer has the ability to create stored procs or to change table structures.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum