Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Tips   (RSS)

Marquee Moon (Field References in Page Headers and Footers)

One of the questions that I get often is about putting database fields in their SSRS report page header and/or footer. Note that putting fields in the page header and footer is not the same as putting a data region in these sections. Because of the impact Read More...
Posted Tuesday, June 19, 2007 11:57 PM by bwelcker | 1 Comments
Attachment(s): Product Line Sales.rdl

At the End of Paths Taken (Modifying Where Clause when All Parameter Values are Selected)

With the return of “Select All” in Service Pack 2, all multi-value parameters allow the user to pick all of the available values. But what if you want to remove the predicate from your WHERE clause instead of generating a long set of values in the IN Read More...
Posted Saturday, May 19, 2007 1:32 PM by bwelcker | 1 Comments
Filed under: , ,

Attachment(s): Select All.rdl

Wincing the Night Away (Tips for SSRS in SharePoint Mode)

Here is some useful information about using SSRS in SharePoint Integrated mode (included with SP2): Installing the SharePoint Add-In If you plan to upgrade from a previous version of the add-in, you should uninstall the previous add-in then install the Read More...
Posted Sunday, February 04, 2007 1:53 PM by bwelcker | 25 Comments

Today! (Cleaning up Reporting Services SharePoint Add-In Setup Problems)

Some people have had problems during installation of the new Reporting Services Add-in for Microsoft SharePoint . If the add-in setup fails while to add the Reporting Services feature to the sites, some of your SharePoint sites will no longer work. You Read More...
Posted Thursday, November 09, 2006 10:28 AM by bwelcker | 13 Comments

End of Amnesia (Avoiding Divide By Zero Errors)

People often ask how to avoid divide by zero problems in their Reporting Services reports. Let's say you have a textbox that calculates profit margin via the expression: =Fields!Price.Value / Fields!Cost.Value This works fine unless a value in the Cost Read More...
Posted Tuesday, September 26, 2006 9:46 AM by bwelcker | 10 Comments
Filed under:

Alien Lanes (Logical and Physical Pagination Rules)

One of the things I see people getting confused about in Reporting Services is around page sizing. Not setting the correct properties can result in extra blank pages or improper paper orientation. Here are some general guidelines for setting page sizes. Read More...
Posted Friday, August 19, 2005 7:57 AM by bwelcker | 46 Comments
Filed under:

All Mod Cons (Multilingual Reports with AS2005)

Based on feedback from a couple of folks, I've decided to make my post titles a bit more descriptive. I'll still use the name of one of the albums in my music collection as the primary title but will also include a description of the actual content of Read More...
Posted Sunday, July 03, 2005 6:46 PM by bwelcker | 7 Comments

Perfect From Now On (Custom Chart Legends)

While the legend built into Reporting Services charts is relatively easy to use, it lacks some of the flexibility that you might like to have. One issue is that it takes up space within the chart boundaries, making the plot area smaller as the number Read More...
Posted Friday, May 20, 2005 12:51 AM by bwelcker | 13 Comments
Attachment(s): CustomColorPalette.rdl
 
Page view tracker