Disconnected Item List Quick Report

<report name="Discontinued Items Report" AutoLinks="true" autoRun="true" HideUndeclaredColumns="true">

	<search name = "Start Date" Type="DateTime" column="start" searchOp="&gt;"  />
	<search name = "End Date" Type="DateTime" column="end"  searchOp="&lt;" />

	<query addWhere="false">

		exec udp_DiscontinuedItems
		
	</query>

	<column name="Itemnmbr" Caption="Item" BestFit="true"/>
	<column name="Item_Description" Caption="Description" BestFit="true"/>
	<column name="Item_Class" Caption="Class" BestFit="true"/>
	<column name="CurCost" Caption="Item Cost" DisplayFormat="#,##0.00" SummaryType="Sum" BestFit="true"/> 
	<column name="ExtCost" Caption="Extended Cost" DisplayFormat="#,##0.00" SummaryType="Sum" BestFit="true"/> 
	<column name="QtyOnHand" Caption="On Hand" DisplayFormat="#,##0.00" SummaryType="Sum" BestFit="true"/> 
	<column name="QtyAllocated" Caption="Allocated" DisplayFormat="#,##0.00" SummaryType="Sum" BestFit="true"/> 
	<column name="QtyAvailable" Caption="Available" DisplayFormat="#,##0.00" SummaryType="Sum" BestFit="true"/> 

</report>

Leave a Reply