Date conversion and formatting

Hi all,
Need some help. I have a report which brings back data over a period
of time from one field (date_required). This is all returned in one
column. I would like to create a report whereby the data is filtered
into the appropriate Month's column, jan, feb etc etc.
I have used the Month statement to extract this and tried using the
visibility expression to create this but without any joy.
Could someone give me some pointers on how to achieve this?
Thanks
GaryHere's what I did. In the query, use the datepart(MM,datefield) to extra the
month number, 1-12. Then in the matrix use the sorting tab of the group
properites to sort ascending. This will sort the columns 1 --> 12. Then go
into the properties for the month field and set the expession to something
like this:
=Left(MONTHNAME(Fields!MonthField.Value),3)
the columns will show Jan, Feb, Mar,etc. rather the 1,2,3...
Hope this helps you.
"gdavid9@.hotmail.com" wrote:
> Hi all,
> Need some help. I have a report which brings back data over a period
> of time from one field (date_required). This is all returned in one
> column. I would like to create a report whereby the data is filtered
> into the appropriate Month's column, jan, feb etc etc.
> I have used the Month statement to extract this and tried using the
> visibility expression to create this but without any joy.
> Could someone give me some pointers on how to achieve this?
> Thanks
> Gary
>