Display column headers for missing data in SSRS matrix report
This tip explains the steps to develop a SSRS matrix report to show column headers for all months even when there is no data for these columns.
Amarendra Reddy Thummeti is a Senior Business Intelligence Engineer who works in Silicon Valley in the United States. He holds a Master's Degree in Computer Science. He has extensive experience in developing data warehouses, ETL, cubes and reports using the Microsoft Business Intelligence stack. He is also passionate about Data Analytics. He can be contacted at amarreddy23@gmail.com and via LinkedIn.
Generate text Output file with a Header and Details Format using SSIS
I need to generate a text file using SSIS that has multiple Header Groups and Detail rows for each header group. This article explains the steps to generate a single flat file with multiple header and detail records.