srodgers45
asked on
Show date ranges by month in SSRS
ASKER
I am not currently doing it that way, I was able to figure out the grouping, now I am having trouble displaying the Month Name and Year Example: "Jan 2012" I can get it to show in this format: "1 - 2012"
Using this expression:
=Month(Fields!tdate.Value) &" - " & Year (Fields!tdate.Value)
Using this expression:
=Month(Fields!tdate.Value)
is tdate a date field?
If so them you could do this...
=Format(Fields!tdate.Value , "MM-yyyy")
If so them you could do this...
=Format(Fields!tdate.Value
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have been gone, i will try this. sorry for the delay.
Then the report will pick it up from there.