Trying to format a Date/Time for just showing Date in Report Studio Crosstab

[rockytopmark]

I have a crosstab whose column headings are derived from a Date/Time column in my table.  I do not want to display the time portion of the value as it is irrelavent.  No matter what Format changes I make, the format stays the same.  I have also tried changing the format in FM model, but it too stays the same.  Database is Oracle 10g. 

Anybody see this problem before?  Workarounds?  Thanks,
Mark

[mikegreen]

Instead of changing the drop-down formatting options, enter MM/DD/YYYY in the pattern field and see whatcha get.

Regards,
mike

[rockytopmark]

Thanks for the reply.  Yeah, I tried that already too.  Other things I tried included making it a Date/Time format and I chose NO for all the Display settings for Time... Display Hour = No, Display Minute = NO, etc...

[GJParker]

Select the column title and change the Text Source -> Source Type propert from Member Caption to Data Item Value, then set the required Format

HTH

Gary