Solved

how to create my salesman report

Posted on 2008-06-16
3
1,132 Views
Last Modified: 2013-12-25
dear all i need to create my special report iam using crystal report 7
using ado with vb6  programming
the problem

i have table with this fields

tbl_saleman ( salesman_name , itemcode , item_brand , sales_qty )

now i need to make report show me the following with this desgin


Sales Man Name               Brand1         Brand2         Brand3          Brand4        Brand 5       brand 6
jhon                                   sum(qty)      sum(qty)      sum(qty)       sum(qty)     sum(qty)     sum(qty)      
smith                                  sum(qty)      sum(qty)      sum(qty)       sum(qty)     sum(qty)     sum(qty)      
leo                                      sum(qty)      sum(qty)      sum(qty)       sum(qty)     sum(qty)     sum(qty)      

for each brand i need to make the sum of qty for saleman number 1 ( jhon )  for each brand

is there any idea how can i create this report

please iam not proffissional in this area so i need clear informatiom

best regards



0
Comment
Question by:abdulhameeds
3 Comments
 
LVL 42

Accepted Solution

by:
frodoman earned 250 total points
ID: 21793776
When you create a new report select "Crosstab" instead of "Standard".  What you describe is a textbook crosstab report.

Put the salesman_name field in the row heading, the item_brand in the column heading, and the sales_qty in the summary area.  That should give you exactly what you want.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 21794330
Agree.

mlmcc
0
 
LVL 4

Author Comment

by:abdulhameeds
ID: 21800267
for knolodge please its very nice if you tell me if the same table (up )  we add the date firld
have dates with 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
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
Read about achieving the basic levels of HRIS security in the workplace.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question