Continuing from the last blog.
Show all FTEs under each supervisor regardless if the FTE has done anything or not in the date range.
Create a stored procedure to add fake data rows for the FTEs who have no production data for the the date range. No need to add those fake rows to the underneath SQL table though. We just need to trick the reporting services to show the FTEs’ names.
There are a few challenges here.
It’s a very straightforward procedure.
Tags: SSRS, #SQLServer, SQL Server, DRILL THROUGH, DRILL DOWN, CARTESIAN JOIN, TSQL, CROSS JOIN,