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
- Columns
- Description
- Hidden & ToggleItem
- Tablix Filters
- Tablix Sorting
- Interactive Sort
- FixedColumnHeaders
- FixedRowHeaders
- NoRowsMessage
- DocumentMap
- WritingMode
- RepeatWith
- VerticalAlign
- InnerPlotPosition
- 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.
Jes Borland is a Premier Field Engineer - SQL Server for Microsoft, where she is a trusted technical adviser, deep technical support, and teacher for her customers. Her experience as a DBA, consultant, and 5-time Data Platform MVP allow her to help the business and the IT teams reach their goals. She has worked with SQL Server as a developer, report writer, DBA, and consultant. Her favorite topics are administration, automation, and performance. She frequently presents at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef.
