Solved

how to create my salesman report

Posted on 2008-06-16
3
1,120 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VB6 Compile Compatibility Issue 4 87
Add and format columns in vb6 7 42
Runtime 3044 error 14 35
RDBMS and No sql database 4 36
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
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…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

947 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now