I am creating a RDLC report in which some year wise data is showing..
e.g YEAR column is containing 2010, 2011 and so on.
I want to get the distinct values of column year in a text box in same Page.. e.g.
If page is showing 10 records on first page and on there 6 records have year 2010 and 4 have 2011,,, so i want to get both 2010 and 2011 in textbox..
Can anybody guide me how to do that??
I know how to use expressions to get the sum or count.. but this scenario is shaking my head bad... :(