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

Archives: December 2011

Dynamic Sorting in SSRS

Introduction

Many times while developing any report we come across a situation where we need to SORT the TABLE columns or the columns in the GROUP dynamically. There are many well known ways to achieve this. However, here I will demonstrate a not-so-known way -

 

Implementation

Assuming that the… Read more

5 comments, 6,462 reads

Posted in Juggling With SQL on 26 December 2011

How many times the T-SQL inside the CTE is executed?

Introduction

Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that the t-sql written inside the CTE will be executed only once irrespective of the number of times it is referred in the subsequent CTEs or the related query.
However,…

Read more

10 comments, 3,776 reads

Posted in Juggling With SQL on 15 December 2011

Workarounds for SSRS 2008 Font rendering issue

 

Problem

A report developed using SSRS 2008 either through Visual Studio 2010 or BIDS 2008 does not renders properly when viewed in the Report Viewer 10.0 via Remote Desktop or any 3rd party applications using Terminal Services in the background.

Remote Rendering

Local Rendering

Workarounds

  1. Change the Screen Resolution…

Read more

5 comments, 2,017 reads

Posted in Juggling With SQL on 2 December 2011