• Changing database without exiting program

    My work has a separate database for each of our companies, I am pulling expenses using Sage. When I open my Crystal Reports for Sage, select my report template, go to File > Export > and then I am prompted with the Sage 100 Database Signon. Currently…
  • SQL Query - Sage Intelligence - Custom Container

    Greetings SI & SQL Gurus! I built customer SI containers for tables containing UDFs as part of a larger project. Some of those UDFs are date fields, which are typically null. This doesn't present a challenge for Sage, SQL, or the custom Crystal Reports…
  • CSV export repeats headers with each field value

    I know this is going to be a really simple answer... when I export my header comes out on each export line preceding the fields that are being exported. I want the header line to export in csv in the 1st line, with the record lines underneath. wa…
  • Microsoft query to export time card data into excel?

    Can someone tell me what table/s I need to include to export the time card data for a job code using Microsoft query? When I select various tables thus far, no data is showing up. I know I can export the time card report to excel directly, but the data…