Data, Reporting,
and Integration Services
for ConnectWise
Our smart, custom solutions are designed for your unique business processes and workflows.
Services
Merge and Convert
Full database merge and data conversion
We’re experts at getting data in and out of ConnectWise, seamlessly.
About
News & Blog
Convert UTC Fields to Local Time
When querying the ConnectWise database, sometimes the only date field you’ll have available is UTC meaning the time returned is not user-aware and you’ll need to adjust it. Or, you may want a report to show standardized time, no matter what timezone the end user is in. To calculate the desired local time from a […]
Report all active Types/SubTypes/Items
I put together a quick SQL query a couple of weeks ago to share my list of ConnectWise Manage types/subtypes/items with a client. Yesterday, someone asked for the same thing in the CW forums so I thought I’d put together a quick blog post for anyone else out there searching for a way to build […]
Conditional Formatting in Report Writer HTML
Recently, I had a client request that I format the negative numbers in red on their RW report. However, since we were using a custom HTML template, we couldn’t use the Advanced Field Properties to set conditional formatting. To accomplish conditional formatting in Report Writer HTML, I used custom CSS. Here are the basic steps. […]