SQL Server Reporting Services is one of my favorite parts of the Microsoft SQL Server stack. Making data tell a story is incredibly valuable, and fun.
Which one of these tells the story better?
I’ve used SSRS for years, and discovered many little tips and tricks to make reports stand out. For the next month, I’m going to be blogging about various properties in SSRS. Some are simple to find and set; some are more complex and require a few steps or expressions. Each of them will make your reports tell a story more clearly.
Here is a list of the blogs in this series. All examples were created using SQL Server 2012, SQL Server Data Tools 2012, and AdventureWorks2012.
- Background Image
- Hidden & ToggleItem
- Tablix Filters
- Tablix Sorting
- Interactive Sort
- CanGrow and CanShrink
- Image Source
- Chart Axis Minimum, Maximum, and Interval
- Chart Series Tooltip
These are my top SSRS properties, although there are many, many more. I encourage you to explore and experiment with myriad of other options, and see how you can make your data tell a story.