July 2004 - Posts

• "All" Parameter Value

  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 Values Read More... Posted Tuesday, July 27, 2004 4:09 PM by ChrisHays | (Comments Off) Filed under: FAQ

• Horizontal Tables

  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 Step Read More... Posted Friday, July 23, 2004 11:39 AM by ChrisHays | (Comments Off) Filed under: FAQ Attachment(s): HorizontalTable.rdl

• Dynamic Grouping

  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 column Read More... Posted Thursday, July 15, 2004 6:47 PM by ChrisHays | (Comments Off) Filed under: FAQ Attachment(s): DynamicGroup.rdl

• Welcome to my Reporting Services Sleazy Hacks blog

  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. When will the Read More... Posted Thursday, July 15, 2004 6:00 PM by ChrisHays | (Comments Off) Filed under: FAQ