How do you display archived tasks on a report that uses “Use filter SQL”?  We have tasks with varius notes that we need for deployment and those tasks have been archived because they are completed.  We are not specifically filtering for or against the archived status and they aren't showing up. 

By default, the stored procedure used for that report does not return archived tasks.  To only way to get a tasks report to show archived is if you use the 'auto filter' and show archive on your main grid.

If you just need a list of archived tasks, you can create an 'other' report and write your own query to return the task that you want.

---

Dan Suceava
http://www.axosoft.com

Created a custom report and its working now.  Thanks.