Developing Reports for Excel

One of the most popular popular formats for SSRS to export to is excel, especially for large data dumps or for further data processing, or just because it is so familiar to business users. Here are some things to consider when developing with this output in mind. Continue reading “Developing Reports for Excel”

SSRS – Parameter Sets

When a report has multiple parameters, it can be handy for the user to be able to shortcut their way to making a selection in each of them, particularly when there’s a certain combination of parameter values which they frequently run. This is where the concept of a parameter set comes in. Continue reading “SSRS – Parameter Sets”

SSRS Parameters

Most reports benefit from being parameterised to allow the user to decide what filtering to apply to the data, or which fields they’d like to see, or some other behaviour or visualisation option. I’m going to show you a really simple example of grabbing some parameter options from the database, presenting them to the user, and sending the selection to the stored procedure to run the report data. Continue reading “SSRS Parameters”

SSRS Show/Hide Drilldowns

Drilldowns are often asked for to get an initial high-level view of data, then delve deeper into any interesting areas. One way to achieve this is to use the ‘Action’ property of an object to link through to another report, pre-populating parameters if necessary. Another is to set up a matrix with several levels of hierarchy and allow users to show the branches of the tree they are interested in. This is the technique I’ll be showing you in this article. Continue reading “SSRS Show/Hide Drilldowns”

Lead & Lag Functions

A reporting requirement I’ve seen come up several times is the ability to compare a field value from one record with the value in the same field but a previous record, or else some other requirement to get the preceding or proceeding record. Continue reading “Lead & Lag Functions”

Data Warehouse – Dimensional Model

This is the first in my series of ‘Basics’ articles, introducing the simple concepts needed for creating a reporting system. In this post I will be outlining the format of the data warehouse. Continue reading “Data Warehouse – Dimensional Model”

Exporting Excel Formulas

Sometimes, a customer will request for an SSRS excel export to contain some formulas rather than literal values. Usually this is when they require a ‘workbook’ rather than a normal report. i.e. they can make changes to detailed values and see what the calculated results are, rather than a read-only high-level information summary. Continue reading “Exporting Excel Formulas”

National Statistical

Tips, tricks & ideas for SQL reporting.

Junk Charts

Tips, tricks & ideas for SQL reporting.

Information is Beautiful

Tips, tricks & ideas for SQL reporting.

Blog - storytelling with data

Tips, tricks & ideas for SQL reporting.

The Middle-Sized Garden

if your garden is bigger than a courtyard, but smaller than an acre

The Creative Independent

Tips, tricks & ideas for SQL reporting.

Bar & Line

Tips, tricks & ideas for SQL reporting.

Datawrapper Blog

Tips, tricks & ideas for SQL reporting.

Nightingale - Medium

Tips, tricks & ideas for SQL reporting.

Chicken Fryd Games

Home Cooked Gaming Articles by Jake Frydman

The Giant Brain

Tabletop Game Reviews, Interviews, and Critique

Start Your Meeples

A blog about board games, board game strategy, miniature games, and tabletop RPGs. Love the Game.

Silly Point Cricket

Each and every single cricket related thought of one Yorkshire born and dwelling, extremely average, retired village cricketer. If football is your thing then please visit www.leftbackfooty.com

Being Outside Cricket

The Home of Bilious Inadequates, Vile Ignoramuses and Social Media Zealots

Live to Write - Write to Live

We live to write and write to live ... professional writers talk about the craft and business of writing

Barwick Books

Reviews, stories, and more.

Patrick Rothfuss – Blog

Tips, tricks & ideas for SQL reporting.

Heroic Technical Writing: Advice and Insights on the Business of Technical Communication

Sharing insights about technical writing that they don't teach in your university.

Business Analyst Articles, Webinars, Templates, Jobs

Tips, tricks & ideas for SQL reporting.

The Oatmeal - Comics by Matthew Inman

Tips, tricks & ideas for SQL reporting.

Blog | Collibra

Tips, tricks & ideas for SQL reporting.

CIO Dive - Latest News

Tips, tricks & ideas for SQL reporting.

Things Organized Neatly

Tips, tricks & ideas for SQL reporting.

Infographics for the People

INFORMATION DESIGN AND DATA VISUALIZATION

SmartData Collective

Tips, tricks & ideas for SQL reporting.

P3 Adaptive

Leading Consultants on Power BI and the Microsoft Data Platform

Introvert, Dear

Award-winning community for introverts

The Art of Manliness

Tips, tricks & ideas for SQL reporting.

FlowingData

Strength in Numbers

Wait But Why

Tips, tricks & ideas for SQL reporting.

Riskology

Leadership for introverts

Simple Programmer

Making The Complex Simple

Evergreen Data

Intentional Data Visualization & Evaluation Reporting

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

SSRS Tips

Tips, tricks & ideas for SQL reporting.