Correcting Image Distortion in PDF Reports
I’ve seen a few cases where reports exported or rendered to PDF have distorted charts and images. On past projects…
Category: SSRS Design
Designing Reports with Custom MDX Queries – part 2
…continued from part 1: Building a Report For the remainder of this article, I will demonstrate query and report design…
Designing Reports with Custom MDX Queries – part 3
Start at part 1 …continued from part 2: Handling Parameters When an MDX query is created using the graphic query…
Designing Reports with Custom MDX Queries – part 1
This article is the first in a three-part series On the Microsoft Developer Network (MSDN) forum for Reporting Services and…
Can I Add Controls to a Reporting Services Report?
I see this question on the forums all the time and thought it was worth a repost here. Just this…
Why Do All Funnel Charts Look The Same?
Something recently occurred to me. I’ve been researching chart and dashboard design standards for an article I’m working on, and…
Rich Embedded Text Formatting in Reports
I’ve recently come to realize what a truly remarkable feature it is to be able to format report text using…
Building Reports and Analytics on Dynamics CRM – Lessons (Being) Learned
In concept, designing reports is such a simple thing… you connect to a data source, write a SQL query, optimize…
Dashboard and KPI Design–the Definitive Industry Standard
First of all, the title is intended to be a little tongue-in-cheek – just a little bit. I’ll explain. Last…
Testing for NULLS in a Dataset Filter
Some seemingly simple filtering logic can be more difficult to achieve when using a dataset filter rather than the WHERE…
Report Recipe Book Released
Our SQL Server Reporting Services Recipe book was released in April. This is a cookbook style book for experienced SSRS designers with 63 individual report recipes, each addressing a specific business requirement or scenario. My co-author, Robert Bruckner, is a technical lead on the SSRS product team and a prolific blogger on the topic. The book is about 630 pages long and took about a year to write. The book takes a unique approach by providing recipes and step-by-step instructions to solve specific business problems.
Return the Value of a Specified Dataset Row Outside a Data Region
I want to return the field value for a specific row to a textbox below a table in my report. To pull this off, I have to be a little creative as there isn’t a simple way to return a value from a specific row in a dataset
How to parameterize a TOP values query
There are certain key words in a T-SQL query than cannot be parameterized, including the TOP statement.
User is prompted to login when viewing a report
A user has been added to a SSRS role for the report folder or report but is still prompted to login. This can happen if Internet Explorer isn’t configured to persist the user’s Windows login to Intranet sites.