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,

 

 

There should be a place to post sample Crystal Reports.