What We Offer Spectrum Users

Spectrum Dashboards

image83

We create custom dashboards where we work through your requirements, and deliver the SQL code needed for your customized dashboards.   Check out the Dashboard section to get FREE DASHBOARD EXAMPLES!

Crystal Reports

image84

Having customized over 200 Crystal Reports for multiple businesses, we understand how to successfully alter existing reports in your Spectrum installation as well as create new reports to address your business needs 

Excel Reporting and Forms

image85

We have designed Excel workbooks that mimic web forms and write data to Spectrum via SDX. We utilize VBA to read and write data to the Spectrum database, and have created complex forms for processing. 

Spectrum SQL Database

image86

 We have worked in SQL development for over 20 years on some of the largest databases in the world. Having spent 6 years specifically in the Spectrum SQL database, there's not much we haven't encountered! Writing complex views across all of the major modules - payroll, HR, job cost, T&M, AR, AP, purchasing - is just another day at the office! 

Report Automation

image87

Using C#, we have implemented solutions for automated reporting from Spectrum that are emailed out to users or placed on shared drives.  We utilize Windows Task Scheduler on a dedicated machine in your office to send out the reports.