how to show a datekey values greater than a particular datekey of a table in ssrs report

Hi fanu987,

According to your description, you want to change the text into date format. Right?

In Reporting Services, we can use expression to format the text into a date first. Pleaes use the expression below:

=CDate(Left(Fields!DateKey.Value,4)+"/"+Left(Right(Fields!DateKey.Value,4),2)+"/"+Right(Fields!DateKey.Value,2))

Then we can apply a filter on a table to display all "date" which is later than 2014/11/06. We just need to use the above expression in filter.

For only showing the "11/06" in textbox. We can use the expression below:

=Left(Right(Fields!DateKey.Value,4),2)+"/"+Right(Fields!DateKey.Value,2)

Reference:

Expression Examples (Report Builder and SSRS)

If you have any question, please feel free to ask.

Best Regards,

Simon Hou