Question: How can I enable users to select "All" as the value of a query parameter? Answer: The simplest way is to modify your query to accept nulls and map "All" to null. Step 1: Start with a report that already has a parameterized query and Valid...

<?xml version="1.0" encoding="utf-8"?> <Report xmlns=" http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition " xmlns:rd=" http://schemas.microsoft.com/SQLServer/reporting/reportdesigner "> <RightMargin>1in</RightMargin>...

Question: Does Reporting Services support horizontal tables (fixed rows and dynamic columns)? Answer: There is no native "horizontal table" report item, but simple horizontal tables can be simulated using Matrix. Step 1: Add a matrix to your report...

<?xml version="1.0" encoding="utf-8"?> <Report xmlns=" http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition " xmlns:rd=" http://schemas.microsoft.com/SQLServer/reporting/reportdesigner "> <RightMargin>1in</RightMargin>...

Question: How can I give my users the ability to dynamically select fields on which to group within a report? Answer: The key to dynamic grouping in a report is this: Practically everything in a report can be based on an expression. From grouping to...

<?xml version="1.0" encoding="utf-8"?> <Report xmlns=" http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition " xmlns:rd=" http://schemas.microsoft.com/SQLServer/reporting/reportdesigner "> <RightMargin>1in</RightMargin>...

Who are you? I'm the guy who gets to take the credit and/or blame for designing the Report Definition Language (RDL) . What is this blog? This is my warehouse for RDL tips, tricks, sleazy hacks and answers to frequently asked questions...