If the date format in my data is YYYYMMDD, how do I inform Report Studio that the data is in date format so that I can use the "Data Format" to specify how to display the date?
Also, how do I choose to automatically roll-up the dates in a crosstab? thanks for any help.
Use to_date function to convert 2 date formate
sorry if this sounds like a dumb question, should I do this in FM or in Report Studio? which is better?
Do in reports,.....