[List description] [Description] Text=List & Label Project File FileVersion=16 RootTable=Categories DataProviderMode=Interface 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:Categories] { [UsedIdentifiers] { Categories.CategoryID=True Categories.CategoryName=True } } [Table:Products] { [SortOrders] { @order=Discontinued ASC } [UsedIdentifiers] { Products.Discontinued=True Products.CategoryID=True Products.ProductName=True } [Relations] { Categories2Products=Categories } } } } } [Layout] P1.Template= xGrid=2540 yGrid=2540 GridShow=FALSE GridSnap=FALSE EnhancedExpressions=TRUE EnhancedOldExpressions=FALSE Decimals=8 RealDataPreviewPageLimit=-2 DefFont={(0,0,0),12.000000,-16,0,0,0,400,0,0,0,0,4,0,0,0,Arial} HelpLines.Horizontal= HelpLines.Vertical= PDF.MaxOutlineDepth=2 PDF.MaxOutlineDepth.IDX=3 DefaultSize.Objecttype6=(0,0,189001,267284) ObjectCount=1 [UserSection] [SumVariables] Sum1=@ProductCounter;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=6 ObjectName=Report Container Locked=FALSE LinkUUID={53FB49EF-FACE-4FD2-8A81-88DB75A11D1D} LinkMode=32 LayerID=0 LayerCond= GroupUUID= Identifier=Categories Condition=True UserLocked=False WrapBefore=False Position/Left=13564 Position/Top=9042 Position/Width=189001 Position/Height=267284 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=Null() DefaultFont/GdiCharSet=Null() 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(180,180,180) bFill=0 CurrentTable=0 ColumnCount=1 ColumnCount.Distance=991 [@Tables] { [Tables] { [Table] { TableType=List TableID=Categories RelationID= LinkUUID={D99B5F9E-4C2E-44E9-B428-A514E37AEDC3} [GroupHeaderLines] { bConcatDataLines=True bKeepTogether=False } [GroupFooterLines] { bAlsoOnEmptyGroup=False bKeepTogether=False } [DataLines] { bKeepTogether=True [bKeepTogether] { IndexedGroups=False } bSuppress=False bForceSumCalculation=True KeepTogether=0 } ZebraPattern=0 [FooterLines] { bKeepTogether=False } PageBreakCondition=False [DefaultFrame] { Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } UseSepTicks=True ColumnCount=0 ColumnCount.Distance=991 FillPrioHorizonal=False ColumnBreakCondition=False ColumnBreakBefore=False bFooterOnBottom=False bFillBottom=False Identifier= Condition=True DistanceTop=2007 DistanceBottom=2997 WrapBefore=False ShowInContextUI=True SortOrderID= PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= Expandable=False FormulaFilter=True DesignScheme="PROJECT" Animation="" Subreport=False Import=FALSE [Body] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text=Categories.CategoryName Width=189001 Height=10008 FixedHeight=0 bIsotropic=True PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=True Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } [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 ReservedMinHeight=29997 Animation="" HTMLAnimation="" } } [Options] { Description= [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=0 } LCondition=True IndexedGroups=0 Anchor=0 Anchor.ToTop=True } } } [Options] { } } [Header] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="CategoryName" Width=189001 Height=10008 FixedHeight=0 bIsotropic=True 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.BackgroundColor1 FgColor=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [SortOrders] { Ascending= Descending= } [Frame] { Default=True Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } [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 ReservedMinHeight=29997 Animation="" HTMLAnimation="" } } [Options] { Description= [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=0 } LCondition=True Anchor=0 Anchor.ToTop=True } } } [Options] { } } [Footer] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="Overall "+ToString$(GetVar("Continued")) +" Products continued, "+ToString$(GetVar("Discontinued"))+ " Products discontinued" Width=189001 Height=10008 FixedHeight=0 bIsotropic=True 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.BackgroundColor1 FgColor=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=True Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } [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 ReservedMinHeight=29997 Animation="" HTMLAnimation="" } } [Options] { Description= [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=0 } LCondition=True IndexedGroups=0 Anchor=0 Anchor.ToTop=True } } } [Options] { } } [GroupHeader] { [Lines] { [Line] { [Columns] { } [Options] { Description= [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=991 Right=0 Bottom=0 } Anchor=0 Anchor.ToTop=True GroupCondition= ResetSums= OnNewPage=False PrintRightAfterHeader=False KeepTogether.Group=False LCondition=True Expandable=False } } } [Options] { } } [GroupFooter] { [Lines] { [Line] { [Columns] { } [Options] { Description= [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= ResetSums= TriggerNewPage=False LCondition=True } } } [Options] { } } [ChildTables] { [Table] { TableType=List TableID=Products RelationID=Categories2Products LinkUUID={347E82D2-3870-490B-9A2F-EF207DCD5E8F} [GroupHeaderLines] { bConcatDataLines=True bKeepTogether=False } [GroupFooterLines] { bAlsoOnEmptyGroup=False bKeepTogether=False } [DataLines] { bKeepTogether=True [bKeepTogether] { IndexedGroups=False } bSuppress=False bForceSumCalculation=True KeepTogether=0 } ZebraPattern=0 [FooterLines] { bKeepTogether=False } PageBreakCondition=False [DefaultFrame] { Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } UseSepTicks=True ColumnCount=0 ColumnCount.Distance=991 Identifier= Condition=True DistanceTop=2007 DistanceBottom=2997 WrapBefore=False ShowInContextUI=True SortOrderID="Discontinued ASC" PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= Expandable=False FormulaFilter=True DesignScheme="PROJECT" KeepTogether.Subtable=False Subreport=False Import=FALSE [Body] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text=Products.ProductName Width=94488 Height=10008 FixedHeight=0 bIsotropic=True PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=True Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } [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 ReservedMinHeight=29997 Animation="" HTMLAnimation="" } [Column] { Identifier= Text=Products.Discontinued Width=94513 Height=10008 FixedHeight=0 bIsotropic=True PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=True Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } [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 ReservedMinHeight=29997 Animation="" HTMLAnimation="" } } [Options] { Description= [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=0 } LCondition=True IndexedGroups=0 Anchor=0 Anchor.ToTop=True } } } [Options] { } } [Header] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="ProductName" Width=94488 Height=10008 FixedHeight=0 bIsotropic=True 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=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [SortOrders] { Ascending= Descending= } [Frame] { Default=True Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } [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 ReservedMinHeight=29997 Animation="" HTMLAnimation="" } [Column] { Identifier= Text="Discontinued" Width=94513 Height=10008 FixedHeight=0 bIsotropic=True 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=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [SortOrders] { Ascending= Descending= } [Frame] { Default=True Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } [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 ReservedMinHeight=29997 Animation="" HTMLAnimation="" } } [Options] { Description= [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=0 } LCondition=True Anchor=0 Anchor.ToTop=True } } } [Options] { } } [Footer] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="" Width=94488 Height=10008 FixedHeight=0 bIsotropic=True 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=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=True Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } [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 ReservedMinHeight=29997 Animation="" HTMLAnimation="" } [Column] { Identifier= Text="" Width=94513 Height=10008 FixedHeight=0 bIsotropic=True 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=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=True Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } [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 ReservedMinHeight=29997 Animation="" HTMLAnimation="" } } [Options] { Description= [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=0 } LCondition=True IndexedGroups=0 Anchor=0 Anchor.ToTop=True } } } [Options] { } } [GroupHeader] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="Products with 'Discontinued' value " +ToString$(Products.Discontinued) Width=189001 Height=10008 FixedHeight=0 bIsotropic=True PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=True Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } [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 ReservedMinHeight=29997 Animation="" HTMLAnimation="" } } [Options] { Description= [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=991 Right=0 Bottom=0 } Anchor=0 Anchor.ToTop=True GroupCondition=ToString$(Products.Discontinued) ResetSums= OnNewPage=False PrintRightAfterHeader=False KeepTogether.Group=False LCondition=True Expandable=False } } } [Options] { } } [GroupFooter] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="Total Products (running): "+ToString$(Cond(Products.Discontinued, ¤¤/* if product is discontinued, increment the corresponding counter */¤SetVar("Discontinued", val(NullSafe(GetVar("Discontinued")))+@ProductCounter), ¤¤/* if product is still available, increment the corresponding counter */¤SetVar("Continued", val(NullSafe(GetVar("Continued")))+@ProductCounter) ¤)) Width=189001 Height=10008 FixedHeight=0 bIsotropic=True PlainTextFormat=True Align=0 AlignDecPosition=-10008 VAlign=0 DrawingAlignment=0 Adjusted=False LineWrap=1 ForceWrap=False FlowControl=False Spacing.Line=0 bFill=0 FgColor=LL.Color.Black SpaceOptimization=True Link.URL= WithText=False MatchDevicePixel=False [Frame] { Default=True Layout=1 [Left] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Top] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Right] { Spacing=991 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } [Bottom] { Spacing=508 Line=True [Line] { Color=RGB(180,180,180) LineType=0 } LineWidth=0 } } [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 ReservedMinHeight=29997 Animation="" HTMLAnimation="" } } [Options] { Description= [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=ToString$(Products.Discontinued) ResetSums=@ProductCounter TriggerNewPage=False LCondition=True } } } [Options] { } } } } } } } [UserVariables] [Parameters] [@Parameters] { [Parameters] { LL.DesignScheme="COMBITBLUE" LL.MultiPassCondition=PrintPassIndex()=PrintPassCount() LL.MultiPassCount=1 LL.ProjectDescription=List & Label Project File } } [UsedIdentifiers] Variables= Fields=Categories.CategoryID;Categories.CategoryName;Products.CategoryID;Products.Discontinued;Products.ProductName ChartFields= [PageLayouts] [@PageLayouts] { [PageLayouts] { [PageLayout] { DisplayName= Condition=True SourceTray=0 ForcePaperFormat=True UsePhysicalPaper=True PaperFormat=9 PaperFormat.cx=210007 PaperFormat.cy=297002 PaperFormat.Orientation=1 Copies=1 Duplex=0 Collate=0 FitPage=False ShowInPrintDialog=True } } } [ExtendedInfo] [@ExtendedInfos] { [UIDescriptions] { } [Subreports] { } }