• ODBC Connections and Intergrations with Business Works

    Hi, We've been using Business Works for years and now need to integrate Order and Invoice data into our in-house proprietary external database that manages our operations. We have a few questions: Can we use SQL to set up an ODBC connection? …
  • Subreport does not export to excel as data (in a data document) - Is there a way to make that happen?

    I have a custom BW report which grabs invoices with a particular due date. I wanted the invoice detail with it which I can easily get, but the key is, I did not want a row for each line item. I wanted this information to be all comprised in a single field…