how to get distinct column values in RDLC report.

See more:

C#

ASP.NET

RDLC

Hi All,

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... :(