Browse by Tags

• FAQ
• Sleazy Hacks

• "Continued" Header on Subsequent Pages

  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 Read More... Posted Wednesday, September 27, 2006 3:40 PM by ChrisHays | (Comments Off) Filed under: Sleazy Hacks Attachment(s): Continued.rdl

• 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 Read More... Posted Wednesday, April 19, 2006 12:08 PM by ChrisHays | (Comments Off) Filed under: FAQ Attachment(s): PolygonsCRI.zip

• "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 Read More... Posted Tuesday, April 18, 2006 5:54 PM by ChrisHays | (Comments Off) Filed under: FAQ Attachment(s): SelectAllMultiValue.rdl

• Reset Page Number On Group

  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 Read More... Posted Thursday, January 05, 2006 6:14 PM by ChrisHays | (Comments Off) Filed under: Sleazy Hacks Attachment(s): GroupPageReset.rdl

• GroupPageReset.rdl

  <?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 "> <PageHeader> <ReportItems> Read More... Posted Thursday, January 05, 2006 5:42 PM by ChrisHays | (Comments Off)

• 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 Read More... Posted Tuesday, October 04, 2005 3:45 PM by ChrisHays | (Comments Off) Filed under: FAQ

• Centered Images

  Question: I have variable sized images I want to display in a table column. How can I center these images without stretching them to fill the table cell? Answer: While there is no automatic centering behavior for the Image control, you can simulate this Read More... Posted Wednesday, October 27, 2004 12:38 PM by ChrisHays | (Comments Off) Filed under: Sleazy Hacks Attachment(s): CenterImage.rdl

• CenteredImage.rdl

  <?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 "> <CodeModules> <CodeModule>System.Drawing, Read More... Posted Wednesday, October 27, 2004 12:33 PM by ChrisHays | (Comments Off)

• 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() Read More... Posted Monday, August 30, 2004 6:22 PM by ChrisHays | (Comments Off) Filed under: Sleazy Hacks, FAQ Attachment(s): MatrixGreenBar.rdl

• MatrixGreenBar.rdl

  <?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> Read More... Posted Monday, August 30, 2004 6:19 PM by ChrisHays | (Comments Off)

• "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

• SelectAll.rdl

  <?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> Read More... Posted Tuesday, July 27, 2004 3:47 PM by ChrisHays | (Comments Off)

• 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

• HorizontalTable.rdl

  <?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> Read More... Posted Friday, July 23, 2004 11:34 AM by ChrisHays | (Comments Off)

• 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