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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.