how to create my salesman report

Posted on 2008-06-16
Medium Priority
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

Question by:abdulhameeds
LVL 42

Accepted Solution

frodoman earned 1000 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.
LVL 101

Expert Comment

ID: 21794330


Author Comment

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

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

600 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