Quarterly comparison last year to this year 3

Use DatePart, Year({Reported_Date}) and DatePart ("q", {Reported_Date}).

You could even use this in selection, Then group by year, do group totals. Or else a crosstab.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

First, to cluster the values, we would need to know more about the variations in the content of the field, but you could create a formula that does it, like:

if {table.natureofcall} like "*auto*" then "Auto Theft" else
if {table.natureofcall} like "*Burglary*" then "Burglary} else {table.natureofcall}

Then use this as your row field in the crosstab. Next create two formulas:

//{@2006}:
if year(table.date}) = 2006 then 1 //or {table.qty}

//{@2007}:
if year(table.date}) = 2007 then 1 //or {table.qty}

Add these are your first two summary fields, and then create another formula as a place holder and add it as your third summary:

whilereadingrecords;
0

Then go to the customize style tab and check "horizontal summaries" and "show summary label".

Then in preview mode, select the {@2006} summary->right click->format field->suppress->x+2 and enter:

whileprintingrecords;
currencyvar yr2006 := currentfieldvalue;
false

Then do the same for the {@2007} summary, using this formula:
whileprintingrecords;
currencyvar yr2007 := currentfieldvalue;
false

Then select the {@0} summary and right click->format field->common tab->display string->x+2 and enter:
whileprintingrecords;
currencyvar yr2006;
currencyvar yr2006;
totext((yr2007-yr2006)%yr2006,2)+"%" //for 2 decimals

-LB

Madawc,

Worked great with a crosstab but, is there a way to get the percentage of change. Crosstab is doing totals...

Thanks

Phil

See my post above.

-LB

Thanks LB

That is beuatimus...

Thanks again