Browse by Tags

Tagged Content List
  • Blog Post: Custom Report Item Image Quality

    Question: How can I get print-quality output from my custom report item? Answer: Custom report items have slightly different plumbing than native report items. Of particular note are native charts. These are generated during report rendering, which means it is possible for us to vary both the type...
  • Blog Post: "All" Parameter Value Redux

    Question: How can I enable users to select "All" as the value of a multivalue query parameter? Answer: Since multivalue parameters cannot be null, you cannot use the approach previously described here . Fortunately, a simple modification of that approach to use a non-null "ALL" token is all that is...
  • Blog Post: Custom Report Items

    A currently undocumented feature of SQL 2005 Reporting Services is the ability to develop custom report items for embedding in reports. The documentation will be available in the web doc update around the time of the release. But for those of you interested in playing around with this in the mean time...
  • Blog Post: Green-Bar Matrix

    Question: How can I get a green-bar effect (alternating colors) in a matrix? Answer: For a green-bar table, you can simply use a background color expression like this: =iif(RowNumber(Nothing) Mod 2,"Green","White") However, there is currently no GroupNumber() function on which to base a green-bar...
  • Blog Post: "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 queries. Step 2: Edit your base query...
  • Blog Post: 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 2: Add static rows to the matrix Right...
  • Blog Post: 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 headers to column and row visibility... since...
  • Blog Post: 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 blog be updated? ...
Page 1 of 1 (8 items)