Subscribe: Chris Hays's Reporting Services Sleazy Hacks Weblog
Preview: Chris Hays's Reporting Services Sleazy Hacks Weblog

Chris Hays's Reporting Services Sleazy Hacks Weblog

Last Build Date: Wed, 22 Jul 2015 16:11:47 +0000


"Continued" Header on Subsequent Pages

Wed, 27 Sep 2006 18:40:00 +0000

Question:How can I repeat a group header on each page, but have it say "MyGroup (continued)" on all but the first page? Answer:Since pagination is determined long after the report has been fully processed, there's no way for the body of the report to reference any page information.  As a result, we're going to have...

Custom Report Item Image Quality

Wed, 19 Apr 2006 15:08:00 +0000

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...

"All" Parameter Value Redux

Tue, 18 Apr 2006 20:54:00 +0000

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...

Reset Page Number On Group

Thu, 05 Jan 2006 21:14:00 +0000

Question:How can I reset my page number back to 1 every time I get a group break? Answer:Resetting the page number on group breaks isn't natively supported, but it can be achieved by tracking group breaks in a shared variable and subtracting off the page offset of the first page of the group from the...


Thu, 05 Jan 2006 20:42:00 +0000

                            1        0.375in        1.5in        true        ="Page: " & Globals!PageNumber                            0.375in        3.625in        true        ="Grouped Page: " & Code.GetGroupPageNumber(ReportItems!Category.Value,Globals!PageNumber)        1.75in              true    true                          5                      textbox1                      true                      Product                    &[...]

Green-Bar Matrix

Mon, 30 Aug 2004 21:22:00 +0000

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...


Mon, 30 Aug 2004 21:19:00 +0000

  1in                                                                      4              textbox1              true                                                    0.5in