Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2011

Let’s Get Visual – The Art of Report Design

Paul Turley
Mentor, SolidQ

This article is based on my session at TechEd on May 18th, 2011

Report styles vary depending on the needs of the consumer and purpose of the report. With so many capabilities in current reporting toolsets, report designers are often prone to add graphics, color and… Read more

2 comments, 1,883 reads

Posted in SQL Server BI Blog on 23 May 2011

Correcting Image Distortion in PDF Reports

I’ve seen a  few cases where reports exported or rendered to PDF have distorted charts and images.  We’ve played with fonts and chart properties have sort of accidentally corrected the issue but without really getting to the core problem.  There’ been quite a bit of traffic generated on the MSDN… Read more

2 comments, 769 reads

Posted in SQL Server BI Blog on 5 May 2011

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 techniques by progressively building a report, adding steps and features. The examples will focus on the capabilities of the query and results, rather than the visual design of the…

Read more

0 comments, 907 reads

Posted in SQL Server BI Blog on 4 May 2011

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 designer, parameters can be added automatically along with the datasets needed to drive the parameter list values. In our case, when writing the query manually, it’s necessary to do… Read more

0 comments, 557 reads

Posted in SQL Server BI Blog on 4 May 2011