|
|
-
|
|
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 ......
|
|
-
|
|
This is a typical drill-down report. Users can click the plus sign to go from summary levels to detail levels.
On the other hand this is a typical drill-through report, where hyperlinks are provided for each row so users can drill through from summary to detail.
I’ve created both typ......
|
|
-
|
|
This should be a simple task. But I struggled with it longer than I really should have.
Goal
Count unique number of FTEs only when the flag FTE is 1.
It turned out that all I need to do is to put the IIF function inside the COUNTDISITNCT function.
CountDistinct(IIF(Fields!FTE.Value = 1, Fields!U......
|
|
-
|
|
This should be a simple task. But I struggled with it longer than I really should have.
Goal
Count unique number of FTEs only when the flag FTE is 1.
It turned out that all I need to do is to put the IIF function inside the COUNTDISITNCT function.
CountDistinct(IIF(Fields!FTE.Value = 1, Fields!U......
|
|
-
|
|
Did you ever wonder why we sometimes need to use the StoredProcedure for our SQL Command Type. Why can we just type this and choose Text as the SL Command Type?
execute myProcedure param1, param2
There is a good reason why we do prefer using StoredProcedure as our SQL Command Type over simply ......
|
|
-
|
|
My previous blog SSRS – Repeat Details Grouping to show data columns vertically shows how to grow data columns vertically on a Table with repeating the Details Grouping.
Just when I thought I am done, the business user sent me another request to change the report layout to show data rows hori......
|
|
-
|
|
Conventional layout in Table shows data columns horizontally.
But occasionally business users want to see data columns vertically.
To create a report with columns shown vertically, I simply repeat the Details Grouping multiple times, with each Detail grouping representing one column.
This......
|
|
-
|
|
Continue from SSIS – Use “Foreach Loop Container” and pass a variable to a OLE DB Source in a Data Flow.
Step 2: Create a data flow step, into which we are going to pass a variable
Step 3: Create an OLE DB Source, Destination and a Data Conversion
Step 4: In the OLE DB ......
|
|
-
|
|
OK, let’s continue from the last blog SSIS – “Full result set” to a set variable of Object.
We have read a list of dates from a SQL query into a set variable vLoopSet.
Now we are ready to pass vLoopSet into a Foreach Loop Container.
Step 1: Create a Foreach Loop Container
In the Collection tab, ......
|
|
-
|
|
In my previous blog SSIS – ETL Audit Table with Variables Passed to SQL Task, I have showed you how to read a Single row value from a table into a SSIS variable.
Here is a re-cap:
Step 1: Create the user variable in the variable window
Step 2: Create a SQL task to populate the variable ......
|
|