Thanks for the quick respone sir...
It's not working for me. Actually my requirement is:
I am explaining my problem here:
My grid look like this
Amount Unit Percentage
7890 60 35%
65667 32 40%
7676 54 89%
In my grid first row shows the value whose saledate>getdate()-3 and this row color should be red.
second row of a grid shows values of saledate between getdate and getdate()+3 and this row color should be yellow.
third row of a grid shows values of shipdate >= getdate and this row color should be orange.
Sometime happens that in my grid shows either 2 or 1 or 3 rows according to data in database but not morethan 3 coz i used aggreagate function "SUM".
Now i need to drill down on each row which shows on grid and that will load the another grid which shows the details of that perticular columns(amount,percentage,customer,location etc etc).
For eg: If i drill down on red color row then my data should be like
Cust Loc Date Amount Percentage
whose condition is saledate>getdate()-3 as i described above.
If i drill down on green color row then my data should be like
Cust Loc Date Amount Percentage
whose condition is saledate between getdate and getdate()+3 as i described above.
that's why i need a row no which row no i have selected..
Plese help me it's urgent.