Wednesday, April 28, 2010

Serial Number Column in SQL Reporting Services Report

Problem : You need to add a serial number column (incremented like 1,2,3...) in SQL Reporting Services Report.

Solution :
Sql reporting Services provides you with a Function : RowNumber(Nothing)
Insert Expression "=RowNumber(Nothing)" into your textbox & it will generate the serial number.

If you want the serial number to be generated for each group. Then just add the group name instead of "Nothing". For Example, the group name is "Group1" then the expression becomes "=RowNumber(Group1)". Same for nested data regions, just use the name of the data region instead of "Nothing".

Uses :
1. Can be used to generate numbered rows such as Serial Number Column
2. Can be used to insert Page breaks based on number of rows

Sunday, April 04, 2010

Utthishta Bharata

I remember watching one or two episodes of Chanakya TV Serial in DD National TV and suddenly it stopped airing after some episodes. I didn't know why at that time, I was a kid. I don't remember whether I understood the serial or not or whether I was interested in that or not.But I think I believe I was interested because I still remember those episodes.

And after stopping that serial, they started airing,Akbar the great serial(or it was Tippu Sultan serial don't remember exactly).

And the time passed on... as always time passes on and we never realize what we left behind.

Recently I got Chanakya TV Serial video CD's from one of my friend, and I spent watching the episodes almost 18 hours continuously without stop. I was spell bound to watch such a serial, and later came to know why DD National stopped airing it.And it was congress govt which stopped the serial, thinking that it expresses Hindu Oriented Nationalistic views & those of RSS & BJP ideology.

I really liked Chanakya serial. It is very much essential for the future generations. I request all of you to have one copy of all the episodes with you and see yourself as well as show it to your family members & kids. Protect our culture.

And I heard "Utthishta Bharata" word in that serial, in Sanskrit it means, "Arise India". It empowers each one of us, bharatiya's, to put our efforts into protecting our Motherland as well as our Culture.

Utthishta Bharata, Jai Hind.