Subscribe to this blog
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, 3,331 reads
Posted in Juggling With SQL on 26 December 2011
How many times the T-SQL inside the CTE is executed?
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,…
10 comments, 2,805 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
- Change the Screen Resolution…
5 comments, 897 reads
Posted in Juggling With SQL on 2 December 2011