QuickDevGuide

Home › SSRS Report Development

Data Sources & Datasets — SSRS Report Development

Object What it is Tip Shared data source (.rds) connection string + credentials on the server one per database; reused by many reports Embedded data source connection stored inside one report avoid — hard to repoint between environments Shared dataset (.rsd) a query reusable across reports, cacheable great for parameter lists (regions, years) Embedded dataset query inside the report fine for report-specific queries Credentials Prefer stored credentials of a least-privilege, read-only SQL/Windows account (needed for subscriptions and caching) or Windows integrated security with Kerberos for per-user data. Write datasets well Call stored procedures or views — easier to tune and secure than ad-hoc SQL in RDL. Return only the columns and rows the report shows; aggregate in SQL, not in the…

Key Takeaways