×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Graph and Chart - itemized in details questions

Graph and Chart - itemized in details questions

Graph and Chart - itemized in details questions

(OP)
Graph/Chart Questions

I created a query that gave me all sales items breakdown. Let’s say that I have the sales for January, February and March.

I used two tables, one is the customer and second table is item (part number).  Let's say the query gave me the following results:

January : Item 010 ---- Total Sales $50
          Item 012 --- Total Sales $150
          Item 013 ---- Total Sales $100
          (Total for January) = $300

February: Item 111 --- Total Sales $20
          Item 102 --- Total Sales $40
          Item 013 --- Total Sales $80

          (Total for February) = $140

March: Item 010 -- Total Sales $60
       Item 102 -- Total Sales $50
       Item 111 -- Total Sales $70
       Item 013 -- Total Sales $80

        (Total for March) = $260

I do not have any problems running a query to provide the above result or creating a report. The value from each item is based on several transactions.

My problem starts when I am trying to create a chart/graph. Questions that I have are:

1. Is it possible to create one report that will generate January, February and March charts based on information provided? We need to have all details in there. To make it short, one report that can generate three graphs.

We will use a horizontal bar graph. The vertical (X) will represent the item number and the horizontal (Y) will represent Total Sales.

If it is possible to create a report based on information provided, what band/group that I need to insert the graph? I tried to put the chart in there but it returned all values (3-months combined.) I must do something wrong.

The worst part is, the parameter query kept popping up several times.

2. I would like to create a summary chart for January, February and March as well, to return the $300, $140 and $260 in total sales at the end of the report as well.

Our objective is to run one report, with a given parameter value. As you see, the items in each month might be the same or different from a previous month.

The report will content:

3 graphs - each month
1 graph  - summary

based on parameter query that we specify before running it.

I created the report using report wizard. Thank you.

P.S. I am not mastering in VB. I will be very much appreciated, if you can help me modifying in the report grid or report wizard. Thanks.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close