Two date ranges

[grecon]

Hi I have a report that shows territory sales just the state and total sales for a specific date range. Now I would like to add another date range so I can compare 2011 and 2012 but I am unsure how to do this. I am new to crystal - would appreciate any help. Thanks

 

[grecon]

I figured it out using cross tab but how do I get the date month (I have it by months for each year)to read MAY instead of 5/2012 and so on?

 

[Madawc]

First, right-click on the crosstab dates and see if it will let you change the format.

If this fails, you could create a formula field with something like

ToText({your.date}, "MM/yyyy - MMM")

This would show 05/2012 - May, and can be used for the Crosstab for anything from Crystal 10 onwards. But if you just used the month-name, the crosstab would sort alphabetically by month-name.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11, 2008 or whatever. Methods sometimes change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP