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 (raster or vector) and the DPI of the image…

0

"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 required. Step 1:  Start with a report that…

0

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, I’ve put together…

0

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 calculation in a matrix.GroupNumber can be (mostly) simulated by using the RunningValue function to…

0

"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 to account…

0

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 matrixRight-click in the Data cell and select “Add Row”.  Repeat for the…

0

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 all of it is…

0

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? Whenever I get around to it. Where can…

0