Integer to Date formatting in Reports studio

[Gowtami]

Hi
I have a date field which is asigned as an integer in SQL database. I would like to show it as date (yyyy/mm/dd) in report studio report.
I tired many ways to convert from integer to date filed in framework manager level, transformer cube level and even in Report Studio but end up with nothing.
In Transformer cube we are not using this data item in Time dimension, it's in different dimension because of some cascade soure functionality otherwise I could have changed the date format in the cube level. Report studio doesn't allowing SQL functionalities because Framework manager model is using Cognos SQL(and i can't change this here).
Could anyone give me a solution to convert this integer type to date format in report studio report?

Thanks in advance!!
Gowtami

[ramscognos]

please try with data type casting functions

[Gowtami]

thanks for the reply ramscognos...
I tried cast and convert in all levels (Framework manager, Transformer and report), nothing worked

[GGowtham]

Try Cast([dataitem],date) and apply date format to that particular date item.