Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
#SQLServer 46
SQL Server 44
SSRS EXPERT 41
BI 36
#BI 33
brh 28
SSIS BEST PRACTICES 23
TSQL 19
MS BI STACKS 18
SSRS 17

Archive · View All
March 2011 24
July 2011 17
February 2011 15
April 2010 13
June 2011 11
May 2011 11
April 2011 11
July 2010 11
March 2010 8
December 2011 7

SSRS #39 – Drill down or Drill through 2?

Mar 10 2011 9:20AM by Sherry Li   

Continuing from the last blog.

Challenge

Show all FTEs under each supervisor regardless if the FTE has done anything or not in the date range.

Solution

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.

  1. If you have groupings in your report, you will need to create those fake empty rows for each group.
  2. We will need to use the Cartesian join or cross join to create those fake data rows.
  3. You will not have the real data at the detail level for those fake data rows, but you do need to have the higher level data populated for them, so that your report will show the FTEs correctly under each group.

It’s a very straightforward procedure.

Tags: SSRS, #SQLServer, SQL Server, DRILL THROUGH, DRILL DOWN, CARTESIAN JOIN, TSQL, CROSS JOIN,


Sherry Li
14 · 12% · 3827
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]