on 02-20-2014 3:22 PM
Hi Brian,
Here's a method that shows the dates in the format you want and also sorts them in the right order:
1) Insert a Crosstab and place it on the Report Header. Use the date field as the row and the measure field as the Summary field.
2) While in the Crosstab Expert, highlight the field in the Row > Click Group Options > Options tab > check the option 'Customize Group Name field' > Select 'use formula as group name' and click the formula button beside. Use this code:
totext({date_field},"MMMM-yyyy")
4) Right-click the Crosstab and select Insert Chart. Choose the right Chart Type
5) Suppress the Section that holds the Crosstab
Hope this helps.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.