Crosstab report to show fiscal year 1

[EagerBeaver]

I currently have a crosstab report which reports by group and the sales in each respective year. I need to convert the columns so that they actually show the fiscal year and not the actual year...

Any ideas?

Please help...

 

[kenhamady]

If your fiscal year started on July 1 you could create the following formula:

Year({date} + 184)

and use that as your cross-tab column field. Adjust the number for your FY Start. Won't work if the FY is Jan or Feb. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/