Link to home
Start Free TrialLog in
Avatar of tanjastar
tanjastar

asked on

Creating Bar Chart Using Crystal Reports in VB.net 2003

Hello Experts,
I am very new to crystal reports, but I am fairly seasoned in VB.Net.  I am trying to create a bar chart in a VB.Net 2003 application using Crystal Reports in VS.Net 2003.

Let me try to explain my database structure.  It is an Access 2003 Database, There are two main tables:  Job_Status, Job_Info
Let's say that the Job_Info table has three columns:

(Formating)   Text                  Text             Text
                  Job_Number       Job_Title      Job_Zone
                  JB1111               First Job       48XB5R
                  JB2222             Second Job     71RXB3
                  JB3333             Third Job        41LRBD

Lets say that the Job_Status table has 6 columns:

(Formating)    Text                Yes/No          Yes/No                    Yes/No                    Yes/No                  Yes/No
                   Job_Number      OnTime      Tools_Added       Engineering_Added       Work_Added       Ready_For_Release
                     JB1111               Yes              Yes                         No                          Yes                        No
                     JB3333                No                 Yes                        Yes                      Yes                        No



So, let me try to explain what I want to do with this data.  I would like to Create a bar chart that has a column for each of the 'Yes/No' columns in the Job_Status table.  I want each bar to have two parts to it that when they add up they equal the total amount of records on the Job_Info tab



Total number of jobs
                             
                             
                          3  |       #                      #                          #                              #                                 #
                          2  |       #                       *                         #                              *                                  #
                          1  |       *                       *                          *                              *                                  #                                            
                              |__________________________________________________________________________________
                                   On_Time         Tools_Added    Engineering_Added         Work_Added           Ready_For_Release
                             

                                           * = Completed
                                           # = Not completed


Could someone please help me with this?  I am putting it for the max points because I need it really fast.


ASKER CERTIFIED SOLUTION
Avatar of gangwisch
gangwisch

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial