GANTT Chart For Project Management and other Graphics....

IrishGiri

Hi all,

I would like to create a simple GANTT chart based on data contained in Textboxes on a form in NAvision (v3.7). Very simply, there are about 20 textboxes each containing dates for the start date of a project management phase e.g. Date1, Date2, Date3....Date 20. So the first task is very simply the duration from Date1 to Date2, next task Date2 to Date3 etc.....So you basically get a staircase type Gantt chart with one task following on from the other.

How can I best design this in Navision? Automation Server using Excel and VBA? Is there a free OCX available that you could recommend?

Managers get very excited when it comes to Graphics! At present everybody in my company pulls info. from Navision and then imports this into Excel to create Graphics. Is there a Graphics package out there that could accomodate my needs? A freeware OCX that covers all the basic bases would suffice. Not really prepared to invest in Business analytics for now until we make the jump to Nav 4.0.

I'd like to hear your thoughts on this!
Cheers,
Paul.

IrishGiri

another possibility I just thought of: ODBC-ing the data from Navision to Excel and generating an Excel graph and displaying this in NAvision by using an Automation Server....I don't really know how this would compare with other approaches in terms of speed though. As it is Navision is accessed remotely by Terminal Server by our end-users and runs a little slowly......

:-k

pduck

Maybe you can use this? http://www.programmersheaven.com/downlo ... nload.aspx

The problem would be that no visual components in navision are allowed but this example comes with source code and there are some other examples in this forum how to get visual components running with navision.

Have luck!

IrishGiri

Cheers pdluck, I'll look into this now.....

IrishGiri

Is there anybody out there who could offer any other suggestions? I'm open to all ideas....