If you try to do calculations on your ConnectWise Manage custom fields in Report Writer, you’ll notice that custom fields that are supposed to be formatted as a number or date type just come through as text. ConnectWise stores custom fields as the SQL data type varchar, instead of the relevant type you selected for […]
UPDATE UPDATE 2021-04/27 – Here’s a simpler version that works in some cases (this is what I started with before settling on the version below as this way didn’t want to work on that invoice). If you need to do calculations on the numbers, stick with the original method as this method converts to text. […]
Good news! Whether your ConnectWise Manage is self-hosted or in the cloud with the Cloud Data Access add-on ($99/month for 11-50 users as of this writing), you can now establish a live Direct Query SQL connection to your ConnectWise data without having to purchase NexNow’s custom Power BI connector. This has dramatically reduced our fee […]
Automatically alternating row formatting is a great way to make your report easier to read and more visually pleasing, especially when your report can output a lot of rows. Report Writer allows us to set alternating row formatting in the Style tab. However, that formatting only applies to the standard display. As soon as you […]