TechEd session: Tips and tricks for building rich reports

Here's a recording of my TechEd 2012 North America session last week in Orlando:

Tips and Tricks For Building Rich Reports

The entire session is based on Report Builder 3.0. All content is relevant to both SQL 2008 R2 and SQL 2012.

Topics covered:

• Use a tablix to organize data how you want it
• Use colors and graphics to emphasize data
• Choose the right visual for what you're trying to communicate
• Add clipboard data using an XML data source
• Integrate related data using the Lookup function
• Display short lists using the LookupSet function
• Optimize output for Excel

Hope you enjoy!

Comments

• Anonymous
  July 01, 2012
  You said in your talk that you wanted to post the solution to the map visualisation and the scripts for the colorization you used. Where are they?
• Anonymous
  November 22, 2012
  Suppose a dataset is like this=====================                              Col A  |  Col B  |  Col C |=====================a1          5       x1a2          6       x2a3          7       x3a4          5       x4a5          6       x5a6          7       x6a7          7       x7a8          6       x8a9          5       x9======================How do you achieve delow result in SSRS or MDX=======================Col A  |  Col B  |  Col C | Col D (iif(col B=5, col A, PREV-ROWVALUE)=======================a1          5          x1       a1a2          6          x2       a1a3          7          x3       a1a4          5          x4       a4a5          6          x5       a4a6          7          x6       a4a7          7          x7       a4a8          6          x8       a4a9          5          x9       a9======================ThanksRam G