Hi, i have this field value, First(Fields!StartDate.Value,"Course4Display") and i want to format it like this = format (FieldsDoB.Value, "MM/dd/yyyy") which is the normal way to format a date value , it is fine when i print it out in pdf and excel but differrent format when i print it out in word which was why i thought formating it would solve this issue. Can some please help or advise me on this issue Thanks biroma

Hi, i have this field value, First(Fields!StartDate.Value,"Course4Display") and i want to format it like this = format (FieldsDoB.Value, "MM/dd/yyyy") which is the normal way to format a date value , it is fine when i print it out in pdf and excel but differrent format when i print it out in word which was why i thought formating it would solve this issue. Can some please help or advise me on this issue Thanks biroma

Hi Ollumide, Use something like this =Format(CDate(First(Fields!StartDate.Value,"Course4Display")),"MM/dd/yyyy") Please let me know if stil prob persists Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi Ollumide, You just replicate the thread, please close this one.Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi, I tried the expression but it is bring out just one date through out the reportbiroma

Yes, it will show single record through the report because we are using First function over there, if you want to show respective start date, just remove first function from the expression like as below =Format(CDate(Fields!StartDate.Value,"Course4Display"),"MM/dd/yyyy") Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi, It is giving an error that it can only refer to the fields within the current data set scope which i think the 'first' took care off but removing it gave an error because the field comes from another dataset other than then dataset i used for the detail section. thanksbiroma

Do you have any thing in common between main dataset and Course4Display; if yes, your version is 2008 then use LookUP function.. http://www.bidn.com/blogs/hardikabhavsar/bidn-blog/1637/lookup-in-ssrs-2008-r2Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

why would you suggest Lookup? Does not make sense at all. This is formatting issue.Think out of the box

Dear I_h, he has to insert data of different dataset into the table which has different dataset; i believe look up will do....if you have any other solution please let us know.........Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/