troubleshooting Question

Creating Bar Chart Using Crystal Reports in 2003

Avatar of tanjastar
tanjastar asked on
Visual Basic.NET
1 Comment1 Solution529 ViewsLast Modified:
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.


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros