0 /I-01Report TemplatesKInKI 0<06DReport Templates2gg /I. /I/01Site Wide VarianceKInKI gg~d]Site Wide Variance60\'! )bSite Wide Varianceg*g$f!'!e]%FieldReportCategory]Variance4.e]%FieldReportDescription]Site wide variance=7e]%FieldReportTitle]S i t e W i d e V a r i a n c e?9e]Address1]%Count0.Site.Profile.Address.StreetAddress()d^e]Address2]%Count0.Site.Profile.Address.City(), %Count0.Site.Profile.Address.ProvinceState();5e]Address3]%Count0.Site.Profile.Address.PostalZip().(e]FieldReportTitle]%FieldReportTitle()e]ListBoxCommands0]%Iterator@1.StoreParam.CodeInfo(%Count0.Site.Profile.CodeCount.CodeSets.FindCodeInfo(%Iterator@1.Current.Barcode.Current()))ye]ListBoxCommands1]%Iterator@1.StoreParam.CodeQuantity(%Iterator@1.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDQuantity))a[e]ListBoxCommands2]%Iterator@1.StoreParam.CountedQuantity(%Iterator@1.Current.Quantity())oie]ListBoxCommands3]%Iterator@1.StoreParam.QuantityDelta(%Iterator@1.GetParam.CountedQuantity.Resolve())e]ListBoxCommands4]%Iterator@1.GetParam.QuantityDelta.Subtract(%Iterator@1.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDQuantity))ice]ListBoxCommands5]%Iterator@1.StoreParam.CostDelta(%Iterator@1.GetParam.QuantityDelta.Resolve())ye]ListBoxCommands6]%Iterator@1.GetParam.CostDelta.Multiply(%Iterator@1.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDCost))_Ye]ListBoxCommands7]%System.SetPrintBandOffIf0(%Iterator@1.GetParam.CostDelta.Resolve())e]QRLabel1]Countede]QRLabel2]Coste]QRLabel3]Qty Delta:4e]QRLabel4]%Count0.Site.Profile.Address.SiteName()e]QRLabel5]Cost Deltae]QRLabelCode]CodeD>e]QRLabelCodeString]%Iterator@1.Current.Barcode.CodeString()SMe]QRLabelCost]$ %Iterator@1.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDCost)E?e]QRLabelCostDelta]$ %Iterator@1.GetParam.CostDelta.Resolve()>8e]QRLabelCounted]Counted %Count0.ReportTime.DateTime()'!e]QRLabelDepartment]Description_Ye]QRLabelDescription]%Iterator@1.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDDescription)e]QRLabelOnHand]On Hand\Ve]QRLabelOnHandValue]%Iterator@1.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDQuantity)HBe]QRLabelQuantity]%Iterator@1.GetParam.CountedQuantity.Resolve()KEe]QRLabelQuantityDelta]%Iterator@1.GetParam.QuantityDelta.Resolve()A;e]QRLabelSiteName]%Count0.Site.Profile.Address.SiteName()]]e]ReportTemplate1.0]object ReportTemplate: TQuickRep Left = 24 Top = 16 Width = 816 Height = 1056 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] Functions.Strings = ( 'PAGENUMBER' 'COLUMNNUMBER' 'REPORTTITLE') Functions.DATA = ( '0' '0' #39#39) Options = [LastPageFooter] Page.Columns = 1 Page.Orientation = poPortrait Page.PaperSize = Letter Page.Values = ( 127 2794 127 2159 127 127 0) PrinterSettings.Copies = 1 PrinterSettings.Duplex = False PrinterSettings.FirstPage = 0 PrinterSettings.LastPage = 0 PrinterSettings.OutputBin = Auto PrintIfEmpty = True ReportTitle = 'RptSiteWideWithEnder' SnapToGrid = True Units = Inches Zoom = 100 object PageHeaderBand1: TQRBand Left = 48 Top = 48 Width = 720 Height = 37 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 97.8958333333333 1905) BandType = rbPageHeader object QRLabel4: TQRLabel Left = 476 Top = 3 Width = 242 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 1259.41666666667 7.9375 640.291666666667) Alignment = taRightJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Count0.Site.Profile.Address.SiteName()' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Height = -13 Font.Name = 'Arial' Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 10 end end object TitleBand1: TQRBand Left = 48 Top = 85 Width = 720 Height = 100 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 264.583333333333 1905) BandType = rbTitle object FieldReportTitle: TQRLabel Left = 276 Top = 4 Width = 167 Height = 24 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 63.5 730.25 10.5833333333333 441.854166666667) Alignment = taCenter AlignToBand = True AutoSize = True AutoStretch = False Caption = '%FieldReportTitle()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clNavy Font.Height = -19 Font.Name = 'Times New Roman' Font.Style = [fsBold] ParentFont = False Transparent = False WordWrap = True FontSize = 14 end object QRLabelCounted: TQRLabel Left = 216 Top = 24 Width = 287 Height = 22 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 58.2083333333333 571.5 63.5 759.354166666667) Alignment = taCenter AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Counted %Count0.ReportTime.DateTime()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clBlack Font.Height = -15 Font.Name = 'Times New Roman' Font.Style = [fsBold] ParentFont = False Transparent = False WordWrap = True FontSize = 11 end object QRLabelSiteName: TQRLabel Left = 1 Top = 40 Width = 250 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 47.625 2.64583333333333 105.833333333333 661.458333333333) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Count0.Site.Profile.Address.SiteName()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clBlack Font.Height = -15 Font.Name = 'Times New Roman' Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 11 end object Address1: TQRLabel Left = 1 Top = 54 Width = 276 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 47.625 2.64583333333333 142.875 730.25) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Count0.Site.Profile.Address.StreetAddress()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clBlack Font.Height = -15 Font.Name = 'Times New Roman' Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 11 end object Address2: TQRLabel Left = 1 Top = 68 Width = 496 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 47.625 2.64583333333333 179.916666666667 1312.33333333333) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Count0.Site.Profile.Address.City(), %Count0.Site.Profile.Addres' + 's.ProvinceState()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clBlack Font.Height = -15 Font.Name = 'Times New Roman' Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 11 end object Address3: TQRLabel Left = 1 Top = 82 Width = 247 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 47.625 2.64583333333333 216.958333333333 653.520833333333) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Count0.Site.Profile.Address.PostalZip()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clBlack Font.Height = -15 Font.Name = 'Times New Roman' Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 11 end end object QRSubDetail1: TQRSubDetail Left = 48 Top = 209 Width = 720 Height = 21 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 55.5625 1905) Master = ReportTemplate HeaderBand = GroupHeaderBand1 PrintBefore = False PrintIfEmpty = True object LabelSiteCodesIterator: TLabel Left = 286 Top = 0 Width = 285 Height = 16 Caption = '%Count0.Site.CreateIterator@1@0(AllSiteCodes)' Visible = False end object QRLabelCodeString: TQRLabel Left = 8 Top = 1 Width = 247 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 21.1666666666667 2.64583333333333 653.520833333333) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Iterator@1.Current.Barcode.CodeString()' Color = clWhite Transparent = False WordWrap = True FontSize = 10 end object QRLabelDescription: TQRLabel Left = 132 Top = 1 Width = 425 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 349.25 2.64583333333333 1124.47916666667) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Iterator@1.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDDescriptio' + 'n)' Color = clWhite Transparent = False WordWrap = True FontSize = 10 end object QRLabelCost: TQRLabel Left = 24 Top = 1 Width = 398 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 63.5 2.64583333333333 1053.04166666667) Alignment = taRightJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '$ %Iterator@1.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDCost)' Color = clWhite Transparent = False WordWrap = True FontSize = 10 end object QRLabelQuantity: TQRLabel Left = 192 Top = 1 Width = 294 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 508 2.64583333333333 777.875) Alignment = taRightJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Iterator@1.GetParam.CountedQuantity.Resolve()' Color = clWhite Transparent = False WordWrap = True FontSize = 10 end object QRLabelOnHandValue: TQRLabel Left = 141 Top = 1 Width = 409 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 373.0625 2.64583333333333 1082.14583333333) Alignment = taRightJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Iterator@1.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDQuantity)' Color = clWhite Transparent = False WordWrap = True FontSize = 10 end object QRLabelQuantityDelta: TQRLabel Left = 346 Top = 1 Width = 276 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 915.458333333333 2.64583333333333 730.25) Alignment = taRightJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Iterator@1.GetParam.QuantityDelta.Resolve()' Color = clWhite Transparent = False WordWrap = True FontSize = 10 end object QRLabelCostDelta: TQRLabel Left = 451 Top = 1 Width = 265 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 1193.27083333333 2.64583333333333 701.145833333333) Alignment = taRightJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '$ %Iterator@1.GetParam.CostDelta.Resolve()' Color = clWhite Transparent = False WordWrap = True FontSize = 10 end object ListBoxCommands: TListBox Left = 708 Top = 4 Width = 17 Height = 11 ItemHeight = 16 Items.Strings = ( '%Iterator@1.StoreParam.CodeInfo(%Count0.Site.Profile.CodeCount.C' + 'odeSets.FindCodeInfo(%Iterator@1.Current.Barcode.Current()))' '%Iterator@1.StoreParam.CodeQuantity(%Iterator@1.GetParam.CodeInf' + 'o.ResolveMsg.FIDLookUp(FIDQuantity))' '%Iterator@1.StoreParam.CountedQuantity(%Iterator@1.Current.Quant' + 'ity())' '%Iterator@1.StoreParam.QuantityDelta(%Iterator@1.GetParam.Counte' + 'dQuantity.Resolve())' '%Iterator@1.GetParam.QuantityDelta.Subtract(%Iterator@1.GetParam' + '.CodeInfo.ResolveMsg.FIDLookUp(FIDQuantity))' '%Iterator@1.StoreParam.CostDelta(%Iterator@1.GetParam.QuantityDe' + 'lta.Resolve())' '%Iterator@1.GetParam.CostDelta.Multiply(%Iterator@1.GetParam.Cod' + 'eInfo.ResolveMsg.FIDLookUp(FIDCost))' '%System.SetPrintBandOffIf0(%Iterator@1.GetParam.CostDelta.Resolv' + 'e())') TabOrder = 7 end end object GroupHeaderBand1: TQRBand Left = 48 Top = 185 Width = 720 Height = 24 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 63.5 1905) BandType = rbGroupHeader object QRLabel1: TQRLabel Left = 436 Top = 4 Width = 54 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 1153.58333333333 10.5833333333333 142.875) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Counted' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold, fsUnderline] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end object QRLabelDepartment: TQRLabel Left = 159 Top = 4 Width = 72 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 420.6875 10.5833333333333 190.5) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Description' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold, fsUnderline] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end object QRLabelOnHand: TQRLabel Left = 503 Top = 4 Width = 56 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 1330.85416666667 10.5833333333333 148.166666666667) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'On Hand' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold, fsUnderline] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end object QRLabel2: TQRLabel Left = 393 Top = 4 Width = 28 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 1039.8125 10.5833333333333 74.0833333333333) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Cost' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold, fsUnderline] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end object QRLabel3: TQRLabel Left = 569 Top = 4 Width = 59 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 1505.47916666667 10.5833333333333 156.104166666667) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Qty Delta' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold, fsUnderline] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end object QRLabel5: TQRLabel Left = 652 Top = 4 Width = 65 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 1725.08333333333 10.5833333333333 171.979166666667) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Cost Delta' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold, fsUnderline] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end object QRLabelCode: TQRLabel Left = 7 Top = 4 Width = 34 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 18.5208333333333 10.5833333333333 89.9583333333333) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Code' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold, fsUnderline] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end end object PageFooterBand1: TQRBand Left = 48 Top = 230 Width = 720 Height = 34 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = True Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 89.9583333333333 1905) BandType = rbPageFooter object QRSysDataPage: TQRSysData Left = 654 Top = 2 Width = 66 Height = 16 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 42.3333333333333 1730.375 5.29166666666667 174.625) Alignment = taRightJustify AlignToBand = True AutoSize = True Color = clWhite Data = qrsPageNumber Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -11 Font.Name = 'Arial' Font.Style = [] ParentFont = False Text = 'Page ' Transparent = False FontSize = 8 end object QRSysDataPrintedDate: TQRSysData Left = 653 Top = 17 Width = 67 Height = 16 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 42.3333333333333 1727.72916666667 44.9791666666667 177.270833333333) Alignment = taRightJustify AlignToBand = True AutoSize = True Color = clWhite Data = qrsDate Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -11 Font.Name = 'Arial' Font.Style = [] ParentFont = False Text = 'Printed ' Transparent = False FontSize = 8 end end end YY  /I0 /I101Misplaced stock by LocationKInKI XXd]Misplaced stock by Location?9\0* )bMisplaced stock by LocationX$Xf'!e]%FieldReportCategory]Variance=7e]%FieldReportDescription]Misplaced Stock by LocationNHe]%FieldReportTitle]M i s p l a c e d S t o c k b y L o c a t i o n?9e]Address1]%Count0.Site.Profile.Address.StreetAddress()d^e]Address2]%Count0.Site.Profile.Address.City(), %Count0.Site.Profile.Address.ProvinceState();5e]Address3]%Count0.Site.Profile.Address.PostalZip().(e]FieldReportTitle]%FieldReportTitle()e]ListBoxCommands0]%Iterator@2.StoreParam.CodeInfo(%Count0.Site.Profile.CodeCount.CodeSets.FindCodeInfo(%Iterator@2.Current.Barcode.Current())){e]ListBoxCommands1]%Iterator@2.StoreParam.LocationLookup(%Iterator@2.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDLocation))a[e]ListBoxCommands2]%Iterator@2.StoreParam.CountedQuantity(%Iterator@2.Current.Quantity())e_e]ListBoxCommands3]%Iterator@2.StoreParam.CountedLocation(%Iterator@1.Current.LocationName())ice]ListBoxCommands4]%System.SetPrintBandOffIfEmtpy(%Iterator@2.GetParam.CountedQuantity.Resolve())e]ListBoxCommands5]%System.SetPrintBandOffIf1(%Iterator@2.GetParam.LocationLookup.Equals(%Iterator@1.Current.LocationName()))e]QRLabel1]Counted#e]QRLabel3]Counted Location:4e]QRLabel4]%Count0.Site.Profile.Address.SiteName() e]QRLabel5]File LocationD>e]QRLabelCodeString]%Iterator@2.Current.Barcode.CodeString()>8e]QRLabelCounted]Counted %Count0.ReportTime.DateTime().(e]QRLabelDepartment]Code & Description_Ye]QRLabelDescription]%Iterator@2.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDDescription)OIe]QRLabelLocationCounted]%Iterator@2.GetParam.CountedLocation.Resolve()MGe]QRLabelLocationLookup]%Iterator@2.GetParam.LocationLookup.Resolve()HBe]QRLabelQuantity]%Iterator@2.GetParam.CountedQuantity.Resolve()A;e]QRLabelSiteName]%Count0.Site.Profile.Address.SiteName()P[PUe]ReportTemplate1.0]object ReportTemplate: TQuickRep Left = 24 Top = 16 Width = 816 Height = 1056 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] Functions.Strings = ( 'PAGENUMBER' 'COLUMNNUMBER' 'REPORTTITLE') Functions.DATA = ( '0' '0' #39#39) Options = [LastPageFooter] Page.Columns = 1 Page.Orientation = poPortrait Page.PaperSize = Letter Page.Values = ( 127 2794 127 2159 127 127 0) PrinterSettings.Copies = 1 PrinterSettings.Duplex = False PrinterSettings.FirstPage = 0 PrinterSettings.LastPage = 0 PrinterSettings.OutputBin = Auto PrintIfEmpty = True ReportTitle = 'RptSiteWideWithEnder' SnapToGrid = True Units = Inches Zoom = 100 object PageHeaderBand1: TQRBand Left = 48 Top = 48 Width = 720 Height = 37 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 97.8958333333333 1905) BandType = rbPageHeader object QRLabel4: TQRLabel Left = 476 Top = 3 Width = 242 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 1259.41666666667 7.9375 640.291666666667) Alignment = taRightJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Count0.Site.Profile.Address.SiteName()' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Height = -13 Font.Name = 'Arial' Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 10 end end object TitleBand1: TQRBand Left = 48 Top = 85 Width = 720 Height = 104 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 275.166666666667 1905) BandType = rbTitle object FieldReportTitle: TQRLabel Left = 276 Top = 4 Width = 167 Height = 24 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 63.5 730.25 10.5833333333333 441.854166666667) Alignment = taCenter AlignToBand = True AutoSize = True AutoStretch = False Caption = '%FieldReportTitle()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clNavy Font.Height = -19 Font.Name = 'Times New Roman' Font.Style = [fsBold] ParentFont = False Transparent = False WordWrap = True FontSize = 14 end object QRLabelCounted: TQRLabel Left = 216 Top = 24 Width = 287 Height = 22 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 58.2083333333333 571.5 63.5 759.354166666667) Alignment = taCenter AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Counted %Count0.ReportTime.DateTime()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clBlack Font.Height = -15 Font.Name = 'Times New Roman' Font.Style = [fsBold] ParentFont = False Transparent = False WordWrap = True FontSize = 11 end object QRLabelSiteName: TQRLabel Left = 1 Top = 40 Width = 250 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 47.625 2.64583333333333 105.833333333333 661.458333333333) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Count0.Site.Profile.Address.SiteName()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clBlack Font.Height = -15 Font.Name = 'Times New Roman' Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 11 end object Address1: TQRLabel Left = 1 Top = 54 Width = 276 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 47.625 2.64583333333333 142.875 730.25) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Count0.Site.Profile.Address.StreetAddress()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clBlack Font.Height = -15 Font.Name = 'Times New Roman' Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 11 end object Address2: TQRLabel Left = 1 Top = 68 Width = 496 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 47.625 2.64583333333333 179.916666666667 1312.33333333333) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Count0.Site.Profile.Address.City(), %Count0.Site.Profile.Addres' + 's.ProvinceState()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clBlack Font.Height = -15 Font.Name = 'Times New Roman' Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 11 end object Address3: TQRLabel Left = 1 Top = 82 Width = 247 Height = 18 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 47.625 2.64583333333333 216.958333333333 653.520833333333) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Count0.Site.Profile.Address.PostalZip()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clBlack Font.Height = -15 Font.Name = 'Times New Roman' Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 11 end end object QRSubDetail1: TQRSubDetail Left = 48 Top = 213 Width = 720 Height = 7 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 18.5208333333333 1905) Master = ReportTemplate HeaderBand = GroupHeaderBand1 PrintBefore = False PrintIfEmpty = True object LabelIteratorLocations: TLabel Left = 630 Top = 0 Width = 210 Height = 16 Caption = '%Count0.Site.CreateIterator@1@0()' Visible = False end end object GroupHeaderBand1: TQRBand Left = 48 Top = 189 Width = 720 Height = 24 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 63.5 1905) BandType = rbGroupHeader object QRLabel1: TQRLabel Left = 516 Top = 4 Width = 54 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 1365.25 10.5833333333333 142.875) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Counted' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold, fsUnderline] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end object QRLabelDepartment: TQRLabel Left = 39 Top = 4 Width = 122 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 103.1875 10.5833333333333 322.791666666667) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Code & Description' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold, fsUnderline] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end object QRLabel3: TQRLabel Left = 356 Top = 4 Width = 113 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 941.916666666667 10.5833333333333 298.979166666667) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'Counted Location' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold, fsUnderline] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end object QRLabel5: TQRLabel Left = 604 Top = 4 Width = 84 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 1598.08333333333 10.5833333333333 222.25) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = 'File Location' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold, fsUnderline] ParentFont = False Transparent = True WordWrap = True FontSize = 10 end end object PageFooterBand1: TQRBand Left = 48 Top = 239 Width = 720 Height = 34 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = True Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 89.9583333333333 1905) BandType = rbPageFooter object QRSysDataPage: TQRSysData Left = 654 Top = 1 Width = 66 Height = 16 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 42.3333333333333 1730.375 2.64583333333333 174.625) Alignment = taRightJustify AlignToBand = True AutoSize = True Color = clWhite Data = qrsPageNumber Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -11 Font.Name = 'Arial' Font.Style = [] ParentFont = False Text = 'Page ' Transparent = False FontSize = 8 end object QRSysDataPrintedDate: TQRSysData Left = 653 Top = 16 Width = 67 Height = 16 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 42.3333333333333 1727.72916666667 42.3333333333333 177.270833333333) Alignment = taRightJustify AlignToBand = True AutoSize = True Color = clWhite Data = qrsDate Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -11 Font.Name = 'Arial' Font.Style = [] ParentFont = False Text = 'Printed ' Transparent = False FontSize = 8 end end object QRSubDetail2: TQRSubDetail Left = 48 Top = 220 Width = 720 Height = 19 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False AlignToBottom = False Color = clWhite ForceNewColumn = False ForceNewPage = False Size.Values = ( 50.2708333333333 1905) Master = QRSubDetail1 PrintBefore = False PrintIfEmpty = True object LabelIteratorCodes: TLabel Left = 694 Top = 16 Width = 254 Height = 16 Caption = '%Iterator@1.CreateIterator@2@1(AllCodes)' Visible = False end object QRLabelQuantity: TQRLabel Left = 272 Top = 1 Width = 294 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 719.666666666667 2.64583333333333 777.875) Alignment = taRightJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Iterator@2.GetParam.CountedQuantity.Resolve()' Color = clWhite Transparent = False WordWrap = True FontSize = 10 end object QRLabelDescription: TQRLabel Left = 68 Top = 1 Width = 425 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 179.916666666667 2.64583333333333 1124.47916666667) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Iterator@2.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDDescriptio' + 'n)' Color = clWhite Transparent = False WordWrap = True FontSize = 10 end object ListBoxCommands: TListBox Left = 696 Top = 20 Width = 17 Height = 11 ItemHeight = 16 Items.Strings = ( '%Iterator@2.StoreParam.CodeInfo(%Count0.Site.Profile.CodeCount.C' + 'odeSets.FindCodeInfo(%Iterator@2.Current.Barcode.Current()))' '%Iterator@2.StoreParam.LocationLookup(%Iterator@2.GetParam.CodeI' + 'nfo.ResolveMsg.FIDLookUp(FIDLocation))' '%Iterator@2.StoreParam.CountedQuantity(%Iterator@2.Current.Quant' + 'ity())' '%Iterator@2.StoreParam.CountedLocation(%Iterator@1.Current.Locat' + 'ionName())' '%System.SetPrintBandOffIfEmtpy(%Iterator@2.GetParam.CountedQuant' + 'ity.Resolve())' '%System.SetPrintBandOffIf1(%Iterator@2.GetParam.LocationLookup.E' + 'quals(%Iterator@1.Current.LocationName()))') TabOrder = 2 end object QRLabelLocationLookup: TQRLabel Left = 608 Top = 1 Width = 288 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 1608.66666666667 2.64583333333333 762) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Iterator@2.GetParam.LocationLookup.Resolve()' Color = clWhite Font.Charset = ANSI_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [] ParentFont = False Transparent = False WordWrap = True FontSize = 10 end object QRLabelCodeString: TQRLabel Left = 0 Top = 1 Width = 247 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 0 2.64583333333333 653.520833333333) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Iterator@2.Current.Barcode.CodeString()' Color = clWhite Transparent = False WordWrap = True FontSize = 10 end object QRLabelLocationCounted: TQRLabel Left = 360 Top = 1 Width = 294 Height = 17 Frame.Color = clBlack Frame.DrawTop = False Frame.DrawBottom = False Frame.DrawLeft = False Frame.DrawRight = False Size.Values = ( 44.9791666666667 952.5 2.64583333333333 777.875) Alignment = taLeftJustify AlignToBand = False AutoSize = True AutoStretch = False Caption = '%Iterator@2.GetParam.CountedLocation.Resolve()' Color = clWhite Transparent = False WordWrap = True FontSize = 10 end end end on /I2 /I301Variance by LocationKInKI nnd]Variance by Location82\)# )bVariance by Locationn+n%f$'!e]%FieldReportCategory]Variance60e]%FieldReportDescription]Variance by Location@:e]%FieldReportTitle]V a r i a n c e by L o c a t i o n?9e]Address1]%Count0.Site.Profile.Address.StreetAddress()d^e]Address2]%Count0.Site.Profile.Address.City(), %Count0.Site.Profile.Address.ProvinceState();5e]Address3]%Count0.Site.Profile.Address.PostalZip().(e]FieldReportTitle]%FieldReportTitle()e]ListBoxCommands0]%Iterator@2.StoreParam.CodeInfo(%Count0.Site.Profile.CodeCount.CodeSets.FindCodeInfo(%Iterator@2.Current.Barcode.Current()))ye]ListBoxCommands1]%Iterator@2.StoreParam.CodeQuantity(%Iterator@2.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDQuantity))_Ye]ListBoxCommands10]%Iterator@1.StoreParam.ItemsCount(%Iterator@1.Current.ItemsCount())a[e]ListBoxCommands11]%System.SetPrintBandOffIf0(%Iterator@1.GetParam.ItemsCount.Resolve())a[e]ListBoxCommands2]%Iterator@2.StoreParam.CountedQuantity(%Iterator@2.Current.Quantity())oie]ListBoxCommands3]%Iterator@2.StoreParam.QuantityDelta(%Iterator@2.GetParam.CountedQuantity.Resolve())e]ListBoxCommands4]%Iterator@2.GetParam.QuantityDelta.Subtract(%Iterator@2.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDQuantity))ice]ListBoxCommands5]%Iterator@2.StoreParam.CostDelta(%Iterator@2.GetParam.QuantityDelta.Resolve())ye]ListBoxCommands6]%Iterator@2.GetParam.CostDelta.Multiply(%Iterator@2.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDCost))_Ye]ListBoxCommands7]%System.SetPrintBandOffIf0(%Iterator@2.GetParam.CostDelta.Resolve())e]QRLabel1]Countede]QRLabel2]Coste]QRLabel3]Qty Delta:4e]QRLabel4]%Count0.Site.Profile.Address.SiteName()e]QRLabel5]Cost Deltae]QRLabel6]CodeD>e]QRLabelCodeString]%Iterator@2.Current.Barcode.CodeString()RLe]QRLabelCost]$%Iterator@2.GetParam.CodeInfo.ResolveMsg.FIDLookUp(FIDCost)D>e]QRLabelCostDelta]$%Iterator@2.GetParam.CostDelta.Resolve()>8e]QRLabelCounted]Counted %Count0.ReportTime.DateTime()'!e]QRLabelDepartment]DescriptionB