Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Archive > 2018Jan2 - Deletes > Queries Using CTE Fail in Web Report Writer

Queries Using CTE Fail in Web Report Writer

This article is slated for Deletion. Do not update this article. If you have questions please send a message to

Created by Michael Almadova, last modified by Kevin.Swinson on Jan 02, 2018

Views: 759 Votes: 0 Revisions: 5


Queries Using CTE fail in Web Report Writer, but will run in Report writer. 



  • NPM 11.5.2




A semicolon is missing in front of the command ;WITH CTE AS.


  1. Add the semicolon in front of the;WITH CTE AS command and this will run in Web reports. 





Last modified


This page has no custom tags.