• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

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
0
abdulhameeds
Asked:
abdulhameeds
  • 3
  • 3
1 Solution
 
mlmccCommented:
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
0
 
abdulhameedsAuthor Commented:
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
0
 
mlmccCommented:
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
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
abdulhameedsAuthor Commented:
its date but if u need it string i can
0
 
mlmccCommented:
Here is a sample report using data similar to yours

SaleManCrosstab.txt
0
 
abdulhameedsAuthor Commented:
the file not opend cos its diffirennr version
but it worked best regards to u
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now