In your expression, you have:
Year (field ) & "/" & Right ("0" & Month (field); 2)
Where field is apparently a date field. If you put that field on your sub summary layout part, you can specify data formatting to get the data display that you describe. you can keep the above calculation field and specify it in your sort order and sub summary layout part to use for grouping your records and use the original date field for display purposes.
Thanks Phil. Works fine.
Yeah, I guess I was a little confused - I thought the calculation field needed to be in the subsummary part for it to work.
Upon reflection, no reason why it should since all the grouping happens outside the report.
Really appreciate your reply.
Here's an alternative method for compute the Year and month for such sorting:
Field - Day ( Field ) + 1
select date as the result type. This computes the date for the first day of the month for all dates in field that fall in the same month and year. This field could be used both for sub summary grouping and also for "MonthName, Year" display using data formatting.
Thanks Phil. I've saved this excellent tip for future use.
Appreciate your follow up.