Taking the Scare out of Monster Reports
summary
Shows concrete tactics to tame two kinds of monster reports: handling disparate data by creating a SQL control table (or CTE in an RDL) for ordering, formats, tool‑tip lines and chart hooks, and handling disparate controls by prebuilding standalone charts, using subreports or pasting controls into the base report and grouping them inside rectangles to prevent gaps. Reports include a 150‑page monthly state report, dashboards with ~20 subreports, parameter datasets to fix passing issues, and heavy optimizations for large servers (~100,000 runs/day).
AI-written summary · about
chapters (19)
- 0:00Intro
- 0:14How do you eat an elephant
- 0:46Monster Reports
- 1:50Disparate Data
- 3:11Dashboard Reports
- 3:44Special Ordering
- 5:43Control Table
- 8:22Demo
- 15:50Two approaches
- 16:26Prebuild controls
- 17:35Issues with sub reports
- 19:15Final Report
- 28:14Recap
- 28:30Base Report Issues
- 29:26Data Sets
- 35:24Summary
- 35:34Contact Info
- 36:21Questions
- 44:44Conclusion
related talks
01h 01mAdvanced Data Visualization with SQL Server Reporting Services
46mVisualizing Data for Non-Data Experts: Making Reports Accessible to All
01h 04mCreate Reports That Help You Run Your Business
25mTake your Power BI Reports to the Next Level
21mTreat your reports as communication tools
50mLet End Users Drive: Empowering User Control in Power BI Reports
22m5 Things You Can Do to build better looking reports
37mMaking Informed Decisions: Guidelines for Creating an Effective Dashboard