Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: How to make a production schedule chart? Post Reply Post New Topic
Author Message
Lori.Hunt
Newbie
Newbie
Avatar

Joined: 21 Oct 2008
Location: United States
Online Status: Offline
Posts: 1
Quote Lori.Hunt Replybullet Topic: How to make a production schedule chart?
    Posted: 21 Oct 2008 at 12:32pm
Hello,
 
I work for a plastic injection molding company in Madisonville, TN.  We use a program called Epicor Vista for our accounting, customer service, and production control functions.  It uses a Progress database and Crystal Reports 11.5 is bundled with it. 
 
I have been tapped to develop some custom reports for the program.  I can do the basic reports, but have run into the proverbial brick wall with a request from our production manager. 
 
We have 16 different machines.  He has asked for a graphical presentation of the production schedule with a line for each machine, then a bar for each job on the machine, using start and end dates to determine the bar's length.  On the bars, the part name and number need to be displayed, and I need to be able to color code the bar based on whether or not the job will finish by the need by date and also by whether the job needs a full time operator or not.  The user would determine the time period the chart would cover, and it would be viewed on a computer screen, not printed out, so width is not an issue.  Scrolling can take care of that.
 
I am able to pull the data needed from the database, I just don't know how to put it into the graphical format requested.    There is not a graph that lends itself to this easily.  I would appreciate any suggestions on how to accomplish this.
 
Thank you,
 


Edited by Lori.Hunt - 21 Oct 2008 at 12:48pm
Lori Hunt
Hope Industries, Inc.
351 Industrial Park Rd.
Madisonville, TN 37354
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 22 Oct 2008 at 1:28am

Hi Lori,

Can you email me some records with what values you need to be displayed in X axis and Y axis ,I will give it a try.
 
Thanks
Rahul
 

 

IP IP Logged
jlb1
Newbie
Newbie
Avatar

Joined: 10 Dec 2008
Location: Canada
Online Status: Offline
Posts: 5
Quote jlb1 Replybullet Posted: 15 Dec 2008 at 10:45am
Hi Lori, I have a sample that might be able to help you.  Please email me at jbedoya@yorkcentral.on.ca
 
There should be a place to post sample Crystal Reports.
take care
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.