<group>
	<groupid>LifeCycleState</groupid>
	<sortorder>LIFECYCLESTATE</sortorder>
	<groupbyheader>Life Cycle State</groupbyheader>
	<header>
		<column>
			<fieldname>
			case when CURRENTSTATE.LIFECYCLESTATE='DRAFT' then 'Draft'
			     when CURRENTSTATE.LIFECYCLESTATE='EFFECTIVE' then 'Effective'
			     when CURRENTSTATE.LIFECYCLESTATE='NOT_EFFECTIVE' then 'Not Effective'
			     when CURRENTSTATE.LIFECYCLESTATE='REGRETTED' then 'Regretted'
			     when CURRENTSTATE.LIFECYCLESTATE='SWAPPED' then 'Swapped'
			     when CURRENTSTATE.LIFECYCLESTATE='REMOVED' then 'Removed'
			     when CURRENTSTATE.LIFECYCLESTATE='IN_RESTING' then 'In Resting'
			     when CURRENTSTATE.LIFECYCLESTATE='CANCELLED' then 'Cancelled'
			end
			</fieldname>
			<width>50</width>
			<widthType>PERCENTAGE</widthType>
			<header>Life Cycle State:</header>
		</column>
	</header>
	<footer>
		<column>
			<fieldname>=COUNT({SUBNUM})</fieldname>
			<header>Number of Subscriptions:</header>
			<width>40</width>
			<widthType>PERCENTAGE</widthType>
		</column>
	</footer>
</group>