Manual Cross Tab Solution for Creating Multiple Formulas

[socalvelo]

CR XI
Oracle DB ODBC
Novice user.

I am looking for a solution to cut down on the number of formulas I am creating for a manual cross tab. I am using a manual cross tab for this because I need Monthly side-by-side columns for the current year and last year. I also need to format this table for a certain look which can't be achieved with CR's cross tab expert. I am creating a formula in each position in the manual cross tab which contains a summary of a crime category for a certain month.

First Question
Can someone help me make combine formula 2 and 3 below into one formula if possible. For formula 2 and three, I am creating 24 separate formulas for each month.
//1
//@FeederRobbery
{Table.Crime_Incident} = "3"

//2
//@Robbery_JanLastYear
if @FeederRobbery
and year({Table.Reported_Date}) = year(currentdate)-1
and month({Table.Reported_Date})= 1 //JAN
then 1

//3
//@RobberySUM_Jan_LastYear
totext(sum({@Robbery_JanLastYear),0)


Second Question
Does anyone have advice on how to lesson the amount of formulas I need to pop into the cells in my manual cross tab?
If I create summaries using CR's Summary function, it is still crime consuming. My manual cross tab will contain about 400 summary formulas.

 

[Madawc]

Can't help with the formulas. But I wondered if you knew that you can copy any formula field and then edit it. Much quicker than starting each from scratch.

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