QuickDevGuide

Home › SSRS Report Development

Subreports & Drillthrough — SSRS Report Development

Technique How it works Cost Drillthrough Action → Go to report with parameters; opens a new report on click cheap — runs only when clicked Subreport a report embedded in a cell, executed once per row expensive for many rows Lookup / LookupSet join a second dataset in expressions cheap for small lookup sets Go to URL link to an app or another system — Prefer drillthrough or a single joined dataset over subreports in large tables — a subreport inside a 1 000-row table runs its query 1 000 times. Pass context with parameters: Region = Fields!Region.Value, StartDate = Parameters!StartDate.Value. In the target report, mark those parameters hidden if users shouldn't change them.

Key Takeaways