[List description] [Description] Text=Item list with grouping FileVersion=15 RootTable=Item Units=SCM-Units Metric=2 TextQuote.Start=1 TextQuote.End=1 RepresentationCode.CondStart=171 RepresentationCode.CondSep=166 RepresentationCode.CondEnd=187 RepresentationCode.Tab=247 RepresentationCode.Ret=182 RepresentationCode.PhantomSpace=8203 RepresentationCode.LockNextChar=8288 RepresentationCode.ExprSep=164 LCID=1031 UserVars.ManualSortOrder=1 CreatedByCallFrom= [@DatabaseStructure] { [DatabaseStructures] { [DatabaseStructure] { [Table:Item] { } } } } [Layout] P1.Template= xGrid=991 yGrid=991 GridShow=FALSE GridSnap=FALSE EnhancedExpressions=TRUE EnhancedOldExpressions=FALSE Decimals=2 DefaultMedium=PRV RealDataPreviewPageLimit=-2 DefFont={(0,0,0),10.000000,-13,0,0,0,400,0,0,0,0,3,2,1,34,Calibri} HelpLines.Horizontal= HelpLines.Vertical= PDF.MaxOutlineDepth=2 PDF.MaxOutlineDepth.IDX=3 DefaultSize.Objecttype1=(0,0,31344,7417) DefaultSize.Objecttype2=(0,0,33909,11100) DefaultSize.Objecttype3=(0,0,27051,-36449) DefaultSize.Objecttype5=(0,0,42647,28169) DefaultSize.Objecttype6=(0,0,182880,202819) ObjectCount=5 [UserSection] [SumVariables] Sum1=@GroupCounter;F;1 [Layer] Name=Base Condition= WorkspaceColor=(102,102,102) Visible=TRUE LayerID=0 [Layer] Name=First Page Condition=Page() = 1 WorkspaceColor=(197,207,10) Visible=TRUE LayerID=1 [Layer] Name=Following Pages Condition=Page() <> 1 WorkspaceColor=(161,203,243) Visible=TRUE LayerID=2 [ProjectTemplates] [@ProjectTemplates] { [ProjectTemplates] { } } [Object] ObjectID=1 ObjectName=Text Locked=FALSE LinkUUID={F3BA948B-3113-46A2-A68F-08C815845511} LinkMode=0 LayerID=0 LayerCond= GroupUUID= Identifier=Header Condition=True UserLocked=False WrapBefore=False bPageWrap=False ExportAsPicture=False Position/Left=19990 Position/Top=24994 Position/Width=150012 Position/Height=11989 Direction=0 bFill=0 Frame/Layout=0 Frame/Left/Spacing=0 Frame/Left/Line=False Frame/Top/Spacing=0 Frame/Top/Line=False Frame/Right/Spacing=0 Frame/Right/Line=False Frame/Bottom/Spacing=0 Frame/Bottom/Line=False PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= IssueCondition=True Link.URL= Animation="" HTMLAnimation="" bBottomAligned=0 [@Lines] { [Lines] { [Line] { [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=28 Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Align=0 Adjusted=False Uneraseable=False LineWrap=1 PageWrapAllowed=True ForceWrap=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True [ConditionalFormatter] { } Text="Item List" Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Text Locked=FALSE LinkUUID={3E4FBFC4-A0D2-4012-B82C-9A96D7F2A051} LinkMode=0 LayerID=0 LayerCond= GroupUUID= Identifier=Items from Condition=not Empty(ItemList.ItemNo.From) UserLocked=False WrapBefore=False bPageWrap=False ExportAsPicture=False Position/Left=19990 Position/Top=36982 Position/Width=50013 Position/Height=5994 Direction=0 bFill=0 Frame/Layout=0 Frame/Left/Spacing=0 Frame/Left/Line=False Frame/Top/Spacing=0 Frame/Top/Line=False Frame/Right/Spacing=0 Frame/Right/Line=False Frame/Bottom/Spacing=0 Frame/Bottom/Line=False PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= IssueCondition=True Link.URL= Animation="" HTMLAnimation="" bBottomAligned=0 [@Lines] { [Lines] { [Line] { [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=14 Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Align=0 Adjusted=False Uneraseable=False LineWrap=1 PageWrapAllowed=True ForceWrap=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True [ConditionalFormatter] { } Text="Items from " + ItemList.ItemNo.From Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Text Locked=FALSE LinkUUID={15D6B099-0502-457C-B8D9-00C96B89D0D5} LinkMode=32 LayerID=0 LayerCond= GroupUUID= Identifier=Print info Condition=True UserLocked=False WrapBefore=False bPageWrap=False ExportAsPicture=False Position/Left=15011 Position/Top=274955 Position/Width=182880 Position/Height=8738 Direction=0 bFill=0 Frame/Layout=0 Frame/Left/Spacing=0 Frame/Left/Line=False Frame/Top/Spacing=0 Frame/Top/Line=False Frame/Right/Spacing=0 Frame/Right/Line=False Frame/Bottom/Spacing=0 Frame/Bottom/Line=False PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= IssueCondition=True Link.URL= Animation="" HTMLAnimation="" bBottomAligned=0 [@Lines] { [Lines] { [Line] { [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Align=0 Adjusted=False Uneraseable=False LineWrap=1 PageWrapAllowed=True ForceWrap=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True [ConditionalFormatter] { } Text="Page " + FStr$ (Page (),"###",1) + " of " + TotalPages$ () + "¶" + "Effective: " + LocDate$ (Today ()) + " " + LocTime$ (Now (),"",10) Tab=0 TabAlign=0 } } } [Object] ObjectID=6 ObjectName=Report Container Locked=FALSE LinkUUID={7B1F6B7B-795F-4F09-A0A2-62FE011671ED} LinkToUUID={3E4FBFC4-A0D2-4012-B82C-9A96D7F2A051} LinkMode=0 LayerID=0 LayerCond= GroupUUID= Identifier=Report Container Condition=True UserLocked=False WrapBefore=False Position/Left=15011 Position/Top=52984 Position/Width=182880 Position/Height=220421 Direction=0 Frame/Layout=0 Frame/Left/Spacing=0 Frame/Left/Line=False Frame/Top/Spacing=0 Frame/Top/Line=False Frame/Right/Spacing=0 Frame/Right/Line=False Frame/Bottom/Spacing=0 Frame/Bottom/Line=False PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= IssueCondition=True Link.URL= DefaultFont/Default=True DefaultFont/FaceName="Calibri" DefaultFont/GdiCharSet=0 DefaultFont/Size=NULL() DefaultFont/Width=#NULL() DefaultFont/Bold=NULL() DefaultFont/Italic=NULL() DefaultFont/Underline=NULL() DefaultFont/Strikeout=NULL() DefaultFont/Color=NULL() DefaultFont/PitchAndFamily=NULL() DefaultFont/OutPrecision=NULL() FgColor=RGB(0,0,0) bFill=0 CurrentTable=0 ColumnCount=1 ColumnCount.Distance=0 [@Tables] { [Tables] { [Table] { TableType=List TableID=Item RelationID= [GroupHeaderLines] { bConcatDataLines=True bKeepTogether=False } [GroupFooterLines] { bAlsoOnEmptyGroup=False bKeepTogether=True } [DataLines] { bKeepTogether=True [bKeepTogether] { IndexedGroups=False } bSuppress=False bForceSumCalculation=False } ZebraPattern=0 [FooterLines] { bKeepTogether=False } PageBreakCondition=False [DefaultFrame] { Layout=1 [Left] { Spacing=991 Line=False } [Top] { Spacing=508 Line=True [Line] { Color=RGB(0,0,0) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(0,0,0) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(0,0,0) LineType=0 } LineWidth=0 } } UseSepTicks=True ColumnCount=0 ColumnCount.Distance=991 FillPrioHorizonal=False ColumnBreakCondition=False ColumnBreakBefore=False bFooterOnBottom=True bFillBottom=False Identifier= Condition=True DistanceTop=0 DistanceBottom=0 WrapBefore=False [WrapBefore] { ResetPageNumberOption=0 } ShowInContextUI=True SortOrderID="" PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= Expandable=False FormulaFilter=True DesignScheme="PROJECT" Animation="" [Body] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text=@GroupCounter+1 Width=33985 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=2 [Left] { Spacing=5004 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=991 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=True Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text=Item.No_EAN128 Width=39345 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=0 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=LL.Color.Black SpaceOptimization=False Link.URL= WithText=False MatchDevicePixel=True [MatchDevicePixel] { DotSizeReduction=0 } [Frame] { Default=False Layout=2 [Left] { Spacing=7010 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=7010 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text=Item.Description1 Width=76657 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=2 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text=Item.UnitPrice Width=32868 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=3 AlignDecPosition=-5004 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=2 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=5004 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } } [Options] { Description=Data line [LFont] { Default=True FaceName=NULL() GdiCharSet=NULL() Size=NULL() Width=#NULL() Bold=NULL() Italic=NULL() Underline=NULL() Strikeout=NULL() Color=NULL() PitchAndFamily=NULL() OutPrecision=NULL() } DisplayInDesigner=True PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= [ReservedSpace] { Left=0 Top=0 Right=0 Bottom=2007 } LCondition=True IndexedGroups=0 Anchor=0 Anchor.ToTop=True } } } [Options] { } } [Header] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="Item no" Width=33985 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=1 Raster=1 BkColor=LL.Scheme.BackgroundColor2 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [SortOrders] { Ascending="" Descending="" } [Frame] { Default=False Layout=1 [Left] { Spacing=5004 Line=False } [Top] { Spacing=991 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=991 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=12 Width=#Null() Bold=True Italic=Null() Underline=Null() Strikeout=Null() Color=LL.Color.White PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text="Barcode" Width=39345 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=1 Raster=1 BkColor=LL.Scheme.BackgroundColor2 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [SortOrders] { Ascending="" Descending="" } [Frame] { Default=False Layout=1 [Left] { Spacing=7010 Line=False } [Top] { Spacing=991 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=991 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=12 Width=#Null() Bold=True Italic=Null() Underline=Null() Strikeout=Null() Color=LL.Color.White PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text="Description" Width=76657 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=1 Raster=1 BkColor=LL.Scheme.BackgroundColor2 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [SortOrders] { Ascending="" Descending="" } [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=991 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=991 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=12 Width=#Null() Bold=True Italic=Null() Underline=Null() Strikeout=Null() Color=LL.Color.White PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text="Price in " + Locale$ (20) Width=32868 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=2 AlignDecPosition=10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=1 Raster=1 BkColor=LL.Scheme.BackgroundColor2 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [SortOrders] { Ascending="" Descending="" } [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=991 Line=False } [Right] { Spacing=5004 Line=False } [Bottom] { Spacing=991 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=12 Width=#Null() Bold=True Italic=Null() Underline=Null() Strikeout=Null() Color=LL.Color.White PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } } [Options] { Description=Header [LFont] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } DisplayInDesigner=True PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= [ReservedSpace] { Left=0 Top=0 Right=0 Bottom=7010 } LCondition=True Anchor=0 Anchor.ToTop=True } } } [Options] { } } [Footer] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="" Width=10008 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text="" Width=23978 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text="" Width=39345 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text=Str$ (Cond (not LastPage (), Count (Item.No, True), Count (Item.No, False)), 0, 0) + ¤Cond (LastPage (), " items in total ", " items on this page ") Width=76657 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=1 Raster=1 BkColor=LL.Scheme.BackgroundColor0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=2007 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=True Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text=Cond (not LastPage (), Sum (Item.UnitPrice, True), Sum (Item.UnitPrice, False)) Width=29870 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=3 AlignDecPosition=-5004 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=1 Raster=1 BkColor=LL.Scheme.BackgroundColor0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=2007 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=True Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text="" Width=2997 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } } [Options] { Description=Footer [LFont] { Default=True FaceName=NULL() GdiCharSet=NULL() Size=NULL() Width=#NULL() Bold=NULL() Italic=NULL() Underline=NULL() Strikeout=NULL() Color=NULL() PitchAndFamily=NULL() OutPrecision=NULL() } DisplayInDesigner=True PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= [ReservedSpace] { Left=0 Top=5004 Right=0 Bottom=5004 } LCondition=True IndexedGroups=0 Anchor=0 Anchor.ToTop=True } } } [Options] { } } [GroupHeader] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="Main group " + "'" + Left$ (Item.No, 1) + "'" Width=182880 Height=10008 FixedHeight=0 bIsotropic=True PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=8 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=5004 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=12 Width=#Null() Bold=True Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } } [Options] { Description=Main group header [LFont] { Default=True FaceName=NULL() GdiCharSet=NULL() Size=NULL() Width=#NULL() Bold=NULL() Italic=NULL() Underline=NULL() Strikeout=NULL() Color=NULL() PitchAndFamily=NULL() OutPrecision=NULL() } DisplayInDesigner=True PDFLevel=1 PDFText= IndexPDFLevel=0 IndexPDFText= [ReservedSpace] { Left=0 Top=0 Right=0 Bottom=5004 } Anchor=0 Anchor.ToTop=True GroupCondition=Left$ (Item.No, 1) ResetSums=@GroupCounter OnNewPage=False [OnNewPage] { ResetPageNumberOption=0 } PrintRightAfterHeader=False KeepTogether.Group=False LCondition=True Expandable=False } } } [Options] { } } [GroupFooter] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="" Width=10008 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text="" Width=23978 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text="" Width=39345 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text=CStr$ (Count (Item.No, True), '%.0f') + " items in " + "'" + Left$ (Item.No, 1) + "' " Width=76657 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=1 Raster=1 BkColor=LL.Scheme.BackgroundColor0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=2007 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=True Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text=Sum (Item.UnitPrice, True) Width=29870 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=3 AlignDecPosition=-5004 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=1 Raster=1 BkColor=LL.Scheme.BackgroundColor0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=2007 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=True Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } [Column] { Identifier= Text="" Width=2997 Height=10008 FixedHeight=0 bIsotropic=False PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=RGB(0,0,0) SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=False Layout=1 [Left] { Spacing=0 Line=False } [Top] { Spacing=0 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=0 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Direction=0 BarWidth=0 [BarWidth] { Align=0 } BarRatio=0 ExportAsPicture=False DwgSaveAsJPEG=0 Condition=True Animation="" HTMLAnimation="" } } [Options] { Description=Group footer main group [LFont] { Default=True FaceName=NULL() GdiCharSet=NULL() Size=NULL() Width=#NULL() Bold=NULL() Italic=NULL() Underline=NULL() Strikeout=NULL() Color=NULL() PitchAndFamily=NULL() OutPrecision=NULL() } DisplayInDesigner=True PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= [ReservedSpace] { Left=0 Top=0 Right=0 Bottom=991 } Anchor=0 Anchor.ToTop=True GroupCondition=Left$ (Item.No, 1) ResetSums= TriggerNewPage=False LCondition=True } } } [Options] { } } } } } [Object] ObjectID=1 ObjectName=Text Locked=FALSE LinkUUID={B70159B7-FC94-43B2-84F8-92027AADA1E7} LinkToUUID={7B1F6B7B-795F-4F09-A0A2-62FE011671ED} LinkMode=0 LayerID=0 LayerCond= GroupUUID= Identifier=Items to Condition=not Empty(ItemList.ItemNo.To) UserLocked=False WrapBefore=False bPageWrap=False ExportAsPicture=False Position/Left=70002 Position/Top=37008 Position/Width=45999 Position/Height=5994 Direction=0 bFill=0 Frame/Layout=0 Frame/Left/Spacing=0 Frame/Left/Line=False Frame/Top/Spacing=0 Frame/Top/Line=False Frame/Right/Spacing=0 Frame/Right/Line=False Frame/Bottom/Spacing=0 Frame/Bottom/Line=False PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= IssueCondition=True Link.URL= Animation="" HTMLAnimation="" bBottomAligned=0 [@Lines] { [Lines] { [Line] { [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=14 Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } Align=0 Adjusted=False Uneraseable=False LineWrap=1 PageWrapAllowed=True ForceWrap=False SpaceOptimization=True Spacing.Paragraph=0 Spacing.Line=0 OutputFormatter= Condition=True [ConditionalFormatter] { } Text=" to " + ItemList.ItemNo.To Tab=0 TabAlign=0 } } } [UserVariables] [Parameters] [@Parameters] { [Parameters] { LL.DesignScheme="COMBITCOLORWHEEL" LL.ProjectDescription=Item list with grouping } } [UsedIdentifiers] Variables=ItemList.ItemNo.From;ItemList.ItemNo.To Fields=Item.Description1;Item.No;Item.No_EAN128;Item.UnitPrice ChartFields= [PageLayouts] [@PageLayouts] { [PageLayouts] { [PageLayout] { DisplayName=Standard-Layout Condition=True SourceTray=0 ForcePaperFormat=True UsePhysicalPaper=True PaperFormat=9 PaperFormat.cx=209982 PaperFormat.cy=296926 PaperFormat.Orientation=1 Copies=1 Duplex=0 Collate=0 FitPage=False ShowInPrintDialog=True } } } [ExtendedInfo] [@ExtendedInfos] { [UserDefinedDesignScheme] { [Foreground] { Color=(233,72,88) Color=(243,163,42) Color=(241,231,132) Color=(130,191,110) Color=(60,180,203) Color=(140,101,154) Color=(25,71,110) Color=(193,193,193) Color=(150,118,96) Color=(25,25,25) } [Background] { Color=(220,220,220) Color=(170,170,170) Color=(120,120,120) Color=(49,49,49) FillMode=1 } } [UIDescriptions] { } }