Oops, meant to type sales orders.  It's a busy day.  I'm having trouble making a visual representation of the data in Excel.  I'm not sure what the easiest solution would be.
 
In the data, I have a bunch of columns that are all zero's.  Is there a way to exclude these in the SQL script?  I assumed that the fields under SELECT would be the only ones it exported.  I'll play around with it for a while.

Evo-ERP already has a Shipment Calendar - QU-B on the Queries menu.  It has estimated dates for Shipments, PO Receipts and Work Order Completions.  You really need to update!

Quote from nicknails on 07/17/07 at 08:18:05:

 
I have a few reports created using Excel and its Query function. The real nice part is after you create/edit the Query, you can record a Macro to do all the formatting and editing. This way you can run a real time report at the click of a mouse.
 
John

I have tried to get this to work for awhile. I get a Java error (Java.IO.IOException: Could not Connect) when trying to open a database or file.
 
Portion of the error log is below-
 
!SESSION Jul 30, 2007 12:09:58.921 ---------------------------------------------
eclipse.buildId=I200406251208
java.version=1.5.0
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
 
!ENTRY com.pervasive.psql.utilities.core 4 0 Jul 30, 2007 12:09:58.921
!MESSAGE  
!STACK 0
java.sql.SQLException: java.io.IOException: could not connect
     at com.pervasive.jdbc.v2.Connection.<init>(Connection.java:107)
     at com.pervasive.jdbc.v2.Driver.connect(Driver.java:57)
     at java.sql.DriverManager.getConnection(Unknown Source)
     at java.sql.DriverManager.getConnection(Unknown Source)
     at com.pervasive.psql.utilities.core.dbaccess.jdbc.JDBCAccess.connectToDatabase(Unk
nown Source)
     at com.pervasive.psql.utilities.core.dbaccess.jdbc.JDBCAccess.connect(Unknown Source)
     at com.pervasive.psql.utilities.core.v9.Database.connect(Unknown Source)
     at com.pervasive.psql.utilities.core.v9.ServerDatabase.querySecurityEnabled(Unknown
Source)
     at com.pervasive.psql.utilities.core.v9.ServerDatabase.isSecurityEnabled(Unknown Source)
     at com.pervasive.psql.utilities.core.v9.Database.loadChildren(Unknown Source)
     at com.pervasive.core.facets.FacetSet.internalLoadChildren(Unknown Source)
     at com.pervasive.core.facets.FacetSet.getIterator(Unknown Source)
     at com.pervasive.ui.views.navigator.NavigatorContentProvider.getChildren(Unknown Source)
     at org.eclipse.jface.viewers.AbstractTreeViewer.getRawChildren(AbstractTreeViewer.j
ava:708)
     at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.
java:477)
     at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.ja
va:585)
     at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:359)
     at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69)
     at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.j
ava:342)
     at org.eclipse.jface.viewers.AbstractTreeViewer.handleTreeExpand(AbstractTreeViewer
.java:754)
     at org.eclipse.jface.viewers.AbstractTreeViewer$4.treeExpanded(AbstractTreeViewer.j
ava:765)
     at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:179)
     at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
     at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
     at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:820)
     at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:805)
     at org.eclipse.swt.widgets.Tree.wmNotifyChild(Tree.java:2074)
     at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:4002)
     at org.eclipse.swt.widgets.Composite.WM_NOTIFY(Composite.java:722)
     at org.eclipse.swt.widgets.Control.windowProc(Control.java:3019)
     at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338)
     at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method)
     at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:1397)
     at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:170)
     at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:1668)
     at org.eclipse.swt.widgets.Control.windowProc(Control.java:3001)
     at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338)
     at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
     at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:1473)
     at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2429)
     at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1377)
     at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1348)
     at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:254)
     at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:141)
     at com.pervasive.ui.Application.run(Unknown Source)
     at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java
:335)
     at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:273)
     at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:129)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     at org.eclipse.core.launcher.Main.basicRun(Main.java:185)
     at org.eclipse.core.launcher.Main.run(Main.java:704)
     at org.eclipse.core.launcher.Main.main(Main.java:688)
 

---

Quote from Kelloggs on 07/13/07 at 11:50:02:

---

I'm at a loss as to where to find a fix for this. Any ideas will be appreciated.

Well, no. I'm using v9.5

Thanks, I will try that. I haven't tried from another workstation. Good idea.