PDA

View Full Version : REPORT PROBLEM HELP!


ABC123

MIKE LYON
10-13-2000, 10:42 AM
I have written a report to print sales of invoices between two dates
broken down by product codes.

I have to now add a total for a product code of all trans between said
dates for a particular month.

Here is an example of what I req. with 'xxx' being field I need to create.
N.B. Fields converting inv date to month exists.
i.e.

Main group = "YEAR"
2nd group = "PRODUCTCODE"
detail
JAN FEB MAR APR MAY ETC..... TOTAL
Product Code xxx xxx xxx xxx xxx ETC..... YYY

If anyone has any idea how to get a column set up like this it would be
very much appreciated.
I have tried using a sub-report but it will not allow 12 subreports on a report?
Please in your reply list any expressions req'd.

Many thanks
Mike

Lowell Wardlow
10-13-2000, 01:39 PM
Mike - I think this will do what you want.

For each month, drag a calculated field into the group footer PRODUCTCODE - name them st_jan, st_feb, etc

Expression for st_jan : (I used the genie for this,
but here is the actual expression used)

TOTAL(IF(MONTH(date_var)=1,amount_var,0),GRP->PRODUCTCODE

Repeat for 12 months, month =1,month=2, etc.

Lowell