CR XI date range question 1

[finbib]

I have a report request from a user to show sales in qty and dollars for the 1st quarter of the current year, as well as the last 3 years.

I was able to get the current year qty and dollars fairly easily, using this formula:

If {Invoice.Date} in Calendar1stQtr then {Ship.Qty} else 0;

and a similar formula for the dollars.

How can I calculate the qty shipped and dollars for the 1st Quarter of the previous 3 years?

I'm using CR XI, connecting to an IBM Universe database thru ODBC. The table I'm hitting has all pertinent info I need, without any joins of any kind.

TIA

Bob Osborne

 

[lbass]

A simple way would be to insert a crosstab. First create a formula {@Qtr}:

datepart("q",{table.date})

Use this as your row field. Then insert {table.date} as your column and select "group options"->print on change of year->options tab->customize name->use a formula->x+2 and enter:

"Qtr " + totext(datepart("q",{table.date}),0,"")

Then add sales (sum) as the summary field.

-LB

 

[finbib]

lbass,

thanks, it worked just like you advertised

Bob