SSRS – Repeat header on each page

I had a recently got a request to make changes in a SSRS report.
As the output of the report has several pages of information, i was asked to repeat the column header on each page.
So i tried the usual approach that everybody thinks which will work. Which is, in tablix properties, check the option ‘Repeat column headers on each page’. I even tried the other option of ‘Repeat row headers on each page’ and also the combination of these two.
Read More…

Posted in SSRS at February 12th, 2013. 15 Comments.

Triggers in SQL Server

So, What are Triggers ?

If we want some action to take place when data is deleted, inserted or updated in the table, we need to create triggers.
In short, triggers are event driven stored procedures. They get executed when a certain event like insert/delete/update operation occurs on a table.
It is a database object which is bound to a table and is executed automatically. You can’t explicitly invoke triggers. The only way to do this is by performing the required action on the table that they are assigned to.
Read More…

Posted in T-SQL at October 19th, 2012. 2 Comments.

What are Magic Tables in SQL Server ?

Magic tables are internal tables called ‘inserted’ and ‘deleted’ which are created and managed by SQL server.

Inserted‘ table holds the values that have been recently inserted.
Inserted‘ table also holds the updated values from a update operation on a table.

Deleted‘ table holds the values that have been recently deleted.
Deleted‘ table also holds the previous values from a update operation on a table.

Read More…

Posted in T-SQL at October 14th, 2012. 1 Comment.

ROW_NUMBER, RANK and DENSE_RANK functions in T-SQL

As you know, Rank means: ‘Placing things by merit/grades/preference and assigning a number to it

The T-SQL ranking functions ROW_NUMBER(), RANK() and DENSE_RANK() were introduced for ranking of rows in SQL Server 2005. Read More…

Posted in T-SQL at October 13th, 2012. No Comments.

Limitations of SSRS 2008 R2

So what are the limitations/Drawbacks/Shortcomings of SQL Server Reporting Services (SSRS) 2008 R2 ?

I know that SSRS 2005 had a much more issues than SSRS 2008 R2 but i am concerned with the SSRS 2008 R2, as its the latest one.

This post lists the features available in other reporting tools that are missing in Microsoft’s Reporting Services. Please add something to this list as i would love to hear from all the experts out there. Read More…

Posted in SSRS at September 29th, 2012. 3 Comments.

Issues in SSRS Reports when SQL Server is updated from 2005 to 2008/2008 R2

I hate when up-gradation of software removes or changes existing features. They may provide new features that help us to achieve the same result as before but it’s still a re-work. Anyway, while up-gradation of SQL Server 2005 to 2008/2008 R2, I came across a similar situation.

I have faced following 2 issues due to this up-gradation:

  1. StrToMember function behavior changes
  2. Conditional coloring of data values stopped working (solved in 2008 R2)
    Read More…
Posted in SSRS at August 19th, 2012. 5 Comments.