• 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? …
  • How can I export a report as a live Excel file or .csv?

    I want to take different reports and export them as live updating .csv file or other Excel compatible format. For example, there is a report at IC > Reports > On Hand Detail Report. I would like to be able to save a copy of the file locally to open with…
  • 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…