asked on

creating my sales report

i have this table and there is date field
the table have the following data
tbl_saleman ( salesman_name , itemcode , item_brand , sales_qty , date )
a 1 a 10 01/01/2008
a 2 a 11 05/01/2008
a 3 a 12 09/01/2008
a 1 a 13 01/02/2008
a 4 a 11 01/02/2008
a 2 a 10 01/03/2008

this is the data inserted inside the table

now i need to know is there any way to make this crosstab report with this result
make all the dates for januwary month (1) for each sales
make all the dates for Februwary month (2)
make all the dates for March month (3)

Sales Man Name Month (1) Month (1) Month (3)

jhon sum(qty) sum(qty) sum(qty)
smith sum(qty) sum(qty) sum(qty)
leo sum(qty) sum(qty) sum(qty)

best regards

iam using vb6 and crystal report 7.0

Mike McCracken

This should be a s simple as

Insert a cross tab
Choose SALESMAN for the rows
Choose the date for the columns (summarize by month)
Choose the qty for the summary fields.

mlmcc

abdulhameeds

ASKER

maybeu dont under stand me ok
i agree its crosstab remember that i have date with the format ( DD/MM/YYYY ) inside the data base
i need this date to be filtered

i mean all the sales invoices between 01/01/2008 - 31/01/2008 will be Month ( 1 )
Between 01/02/2008-28-02-2008 will be month(2 )
as columns

i need the month withour the day and year
hope it will be clear now

Mike McCracken

Perfectly clear. Is it a date field or a string?

If string create a formula to use in the cross tab. Something like
Date({YourDAteField})

When you put a date field in the cross tab column you have an option to use each day, week, month etc.

mlmcc

abdulhameeds

ASKER

its date but if u need it string i can

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

abdulhameeds

ASKER

the file not opend cos its diffirennr version
but it worked best regards to u