select * from projects where status = 'Active' select * from projects where status = 'On-Hold' select * from projects where status = 'Archived'

Incomplete Milestones

Due Date	Project	Name	Person	Fee	Billed	Paid	Description
#LSDateFormat(dueDate,"mmm d, yyyy")#	#projName#	#name#	#firstName# #lastName#	$#NumberFormat(rate,"0")#			#description#
TOTAL FEE:				$#NumberFormat(totalIncMSFee,"0")#

Completed Milestones

Due Date	Project	Name	Person	Fee	Billed	Paid	Description
#LSDateFormat(dueDate,"mmm d, yyyy")#	#projName#	#name#	#firstName# #lastName#	$#NumberFormat(rate,"0")#			#description#
TOTAL FEE:				$#NumberFormat(totalComMSFee,"0")#

Hourly Billing

Date	Project	Person	Hours	Billing Category	Fee	Billed	Paid	Description
#LSDateFormat(dateStamp,"mmm d, yyyy")#	#name#	#firstName# #lastName#	#numberFormat(hours,"0.00")#	#category# ($#NumberFormat(rate,"0")#/hr)	$#NumberFormat(rate*hours,"0")#			#itemtype# #task# - #description#
TOTAL:			#NumberFormat(totalHours,"0.00")#	TOTAL FEE:	$#NumberFormat(totalFee,"0")#

No billing information is available for this user.

#application.settings.company_name#

Create a new project