December 2010 - Posts

• Working with Reporting Services Filters – Part 2: The LIKE Operator

  In the first post of this series , I introduced the use of filters within the report rather than in the query. I included a list of filter operators, and then focused on the use of the IN operator. As I mentioned in the previous post, the use of some Read More... Posted Thursday, December 30, 2010 11:06 AM by smisner | 2 Comments Filed under: SSRS

• Working with Reporting Services Filters–Part 1

  There are two ways that you can filter data in Reporting Services. The first way, which usually provides a faster performance, is to use query parameters to apply a filter using the WHERE clause in a SQL statement. In that case, the structure of the filter Read More... Posted Tuesday, December 21, 2010 4:09 PM by smisner | 3 Comments Filed under: SSRS

• My Right-to-Left Foot (T-SQL Tuesday #13)

  As a business intelligence consultant, I often encounter the situation described in this month's T-SQL Tuesday , hosted by Steve Jones ( Blog | Twitter ) – “What the Business Says Is Not What the  Business Wants.” Steve posed the question, “What Read More... Posted Tuesday, December 14, 2010 3:48 PM by smisner | 1 Comments Filed under: BI