SSRS - it doesn't have to be ugly..

There is an important fact in life that few people realise. I'll state it here, so you all know it:

SSRS reports don't have to be ugly.

You read that right. Read it again, if you want. It's still there.

Ok, kidding aside1. I want to show you how to create less-ugly SSRS reports. One might even call them nice.

In order to do this, you need two things

  1. Some good sense about how to structure reports and, in general, show the numbers
  2. Get rid of the old-fashioned default 'Office 2003'-theme in SSRS

Besides those two, you need to keep some other things in mind, which I'll explore in six posts:

  1. The use of typography & fonts
  2. (Re-)format tables
  3. Altering chart styles
    • Bar & column charts
    • Line charts
    • Map charts
    • Gauges
  4. Create nice report layouts
  5. Alternative use of KPI's
  6. Pick your data & visualizations

I know there's a lot of content available about SQL Server Reporting Services, but pretty much is about how to do the basics (SSRS 101) or how to accomplish a certain thing (like waterfall charts in SSRS before 2016). My series won't be as much on these techniques, but on delivering high-quality reports that in reflect the attention to detail you've given to the data you handled.

Stay tuned, tomorrow the first post will appear!

Founder of this blog. Business Intelligence consultant, developer, coach, trainer and speaker at events. Currently working at Dura Vermeer. Loves to explain things, providing insight in complex issues. Watches the ongoing development of the Microsoft Business Intelligence stack closely. Keeping an eye on Big Data, Data Science and IoT.

Next ArticleCreating non-ugly SSRS reports #1: The use of typography & fonts