ÿ
TSTOKSITUFORM0rTPF0
TStokSituFormStokSituFormLeft‡TopƒWidthôHeight,CaptionStock SituationFont.CharsetDEFAULT_CHARSET
Font.ColorclWindowTextFont.Heightõ	Font.Name
MS Sans Serif
Font.StylePositionpoScreenCenterOnClose	FormCloseOnShowFormShow
PixelsPerInch`
TextHeight
TDecisionPivotDecisionPivot1LeftTop)WidthìHeight)ButtonAutoSize	DecisionSourceDecisionSource1GroupLayoutxtHorizontalGroupsxtRows	xtColumnsxtSummaries
ButtonSpacingButtonWidth@ButtonHeightGroupSpacing
BorderWidthBorderStylebsNoneAlignalTopTabOrder
TDecisionGrid
DecisionGrid1LeftTopRWidthìHeight©DefaultColWidthdDefaultRowHeightCaptionColorclActiveCaptionCaptionFont.CharsetDEFAULT_CHARSETCaptionFont.Color
clCaptionTextCaptionFont.HeightõCaptionFont.Name
MS Sans SerifCaptionFont.Style	DataColorclInfoBkDataSumColorclNoneDataFont.CharsetDEFAULT_CHARSETDataFont.ColorclWindowTextDataFont.Heightõ
DataFont.Name
MS Sans SerifDataFont.StyleLabelFont.CharsetDEFAULT_CHARSETLabelFont.ColorclWindowTextLabelFont.HeightõLabelFont.Name
MS Sans SerifLabelFont.Style
LabelColor	clBtnFace
LabelSumColorclInactiveCaptionDecisionSourceDecisionSource1
Dimensions	FieldName	Prod TypeColorclNone	AlignmenttaCenter	Subtotals		FieldNameTxn CodeColorclNone	AlignmenttaCenter	Subtotals		FieldNameProdColorclNone	AlignmenttaCenter	Subtotals		FieldNameTXNDATEColorclNone	AlignmenttaCenter	Subtotals		FieldNameQTYColorclNone	AlignmenttaCenter	Subtotals		FieldNameTOTVALUEColorclNone	AlignmenttaCenter	Subtotals	Totals	ShowCubeEditorAlignalTopColor	clBtnFace
GridLineWidth
GridLineColorclWindowTextTabOrderTPanelPanel1LeftTopWidthìHeight)AlignalTopTabOrderTDecisionQueryStockSituQueryDatabaseNameVBStockSQL.Strings/SELECT td.PRODTYPE, td.TXNCODE, td.EXTPRODREF, td.txndate,$cast(SUM( td.QTY ) as integer) Qty, @cast(sum(td.qty*sc.stdprice*sv.valuerating) as integer) TotValue0FROM txndet td,stdcostprices sc,stdqltyvalues sv!where td.extprodref=sc.extprodrefand td.txndate>=sc.fromdateand td.txndate<=sc.todateand td.prodtype=sv.prodtypeand td.qlty=sv.qlty;GROUP BY td.PRODTYPE, td.TXNCODE, td.EXTPRODREF,td.txndate,sc.stdprice,sv.prodtype,sv.qlty:ORDER BY td.PRODTYPE, td.TXNCODE, td.EXTPRODREF,td.txndateLeftxToph
TDecisionCube
DecisionCube1DataSetStockSituQueryDimensionMap
ActiveFlag
diAsNeeded	FieldTypeftString	FieldnamePRODTYPEBaseNametd.prodtypeName	Prod TypeDerivedFromÿ
DimensionTypedimDimensionBinTypebinNone
ValueCountActive	
ActiveFlag
diAsNeeded	FieldTypeftString	FieldnameTXNCODEBaseName
td.TXNCODENameTxn CodeDerivedFromÿ
DimensionTypedimDimensionBinTypebinNone
ValueCount	Active	
ActiveFlag
diAsNeeded	FieldTypeftString	Fieldname
EXTPRODREFBaseName
td.extprodrefNameProdDerivedFromÿ
DimensionTypedimDimensionBinTypebinNone
ValueCountnActive	
ActiveFlag
diAsNeeded	FieldType
ftDateTime	FieldnameTXNDATEBaseName
td.txndateNameTXNDATEDerivedFromÿ
DimensionTypedimDimensionBinTypebinMonth
ValueCountActive	
StartValuegŠ@
ActiveFlag
diAsNeeded	FieldType	ftInteger	FieldnameQTYBaseName
SUM( QTY )NameQTYDerivedFromÿ
DimensionType
dimGenericAggBinTypebinNone
ValueCountÿActive	
ActiveFlag
diAsNeeded	FieldType	ftInteger	FieldnameTOTVALUEBaseName)SUM(   (QTY * stdprice)  * valuerating  )NameTOTVALUEDerivedFromÿ
DimensionType
dimGenericAggBinTypebinNone
ValueCountÿActive	ShowProgressDialog	
MaxDimensionsMaxSummaries
MaxCells@BLeft˜TophTDecisionSourceDecisionSource1DecisionCube
DecisionCube1ControlTypextCheck
SparseRows
SparseColsLeft¸TophDimensionCountSummaryCountCurrentSummary
SparseRows
SparseCols
DimensionInfoÿÿÿ