[List description] [Description] Text=Diagramme mit Berichtsparametern FileVersion=15 DataProviderMode=Interface Units=SCM-Units Metric=3 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:LLStaticTable] { } [Table:Customers] { [UsedIdentifiers] { Customers.CustomerID=True } } [Table:Orders] { [Relations] { Customers2Orders=Customers } [UsedIdentifiers] { Orders.CustomerID=True Orders.OrderDate=True Orders.OrderID=True } } [Table:Order_Details] { [Relations] { Orders2Order Details=Orders } } [Table:Categories] { [UsedIdentifiers] { Categories.CategoryID=True Categories.CategoryName=True } } [Table:Order Details] { [UsedIdentifiers] { Order Details.OrderID=True Order Details.OrderID@Orders.OrderID:OrderDate=True Order Details.ProductID@Products.ProductID:CategoryID=True Order Details.ProductID@Products.ProductID:ProductID=True Order Details.ProductID@Products.ProductID:Products.CategoryID@Categories.CategoryID:CategoryName=True Order Details.Quantity=True Order Details.UnitPrice=True } } [Table:Products] { [UsedIdentifiers] { Products.CategoryID=True Products.CategoryID@Categories.CategoryID:CategoryName=True Products.ProductID=True Products.ProductName=True } } } [DatabaseStructure] { [Table:Categories] { [UsedIdentifiers] { Categories.CategoryID=True } [SortOrders] { @order=CategoryID ASC } } [Table:Products] { [UsedIdentifiers] { Products.CategoryID=True Products.ProductID=True } [SortOrders] { @order=ProductID ASC } [Relations] { Categories2Products=Categories } } } } } [Layout] P1.Template= xGrid=1000 yGrid=1000 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,125340,11730) DefaultSize.Objecttype2=(0,0,187330,238770) DefaultSize.Objecttype6=(0,0,182880,208910) ObjectCount=4 [UserSection] [SumVariables] [Layer] Name=Basis Condition= WorkspaceColor=(102,102,102) Visible=TRUE LayerID=0 [Layer] Name=Erste Seite Condition=Page() = 1 WorkspaceColor=(197,207,10) Visible=TRUE LayerID=1 [Layer] Name=Folgeseiten Condition=Page() <> 1 WorkspaceColor=(161,203,243) Visible=TRUE LayerID=2 [ProjectTemplates] [@ProjectTemplates] { [ProjectTemplates] { } } [Object] ObjectID=1 ObjectName=Text Locked=FALSE LinkUUID={AE82767C-D24D-4DFE-B050-847854DE168E} LinkMode=0 LayerID=0 LayerCond= GroupUUID= Identifier=Überschrift Condition=True UserLocked=False WrapBefore=False bPageWrap=False ExportAsPicture=False Position/Left=20000 Position/Top=25000 Position/Width=150000 Position/Height=12000 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="Berichtsparameter" Tab=0 TabAlign=0 } } } [Object] ObjectID=1 ObjectName=Text Locked=FALSE LinkUUID={6F580447-6BC5-4D62-847B-36517D209DE2} LinkMode=0 LayerID=0 LayerCond= GroupUUID= Identifier=Überschrift 2 Condition=True UserLocked=False WrapBefore=False bPageWrap=False ExportAsPicture=False Position/Left=20000 Position/Top=37000 Position/Width=150000 Position/Height=10000 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=11 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="Das Ergebnis der Ausgabe der nachfolgenden Diagramme können Sie in der Vorschau über Berichtsparameter beeinflussen." Tab=0 TabAlign=0 } } } [Object] ObjectID=6 ObjectName=Berichtscontainer Locked=FALSE LinkUUID={EE7B9354-DF35-4FB5-BAEE-1DC2FF1AD5E2} LinkMode=8224 LayerID=0 LayerCond= GroupUUID= Identifier=Berichtscontainer Condition=True UserLocked=False WrapBefore=False Position/Left=15000 Position/Top=52980 Position/Width=182880 Position/Height=220410 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=LL.Color.Black bFill=0 CurrentTable=0 ColumnCount=1 ColumnCount.Distance=0 [@Tables] { [Tables] { [Table] { TableType=List TableID=LLStaticTable RelationID= [DataLines] { bKeepTogether=True bSuppress=False bForceSumCalculation=True KeepTogether=0 } ZebraPattern=0 PageBreakCondition=False [DefaultFrame] { Layout=1 [Left] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Top] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Right] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } UseSepTicks=True ColumnCount=0 ColumnCount.Distance=1000 ColumnBreakCondition=False ColumnBreakBefore=False bFooterOnBottom=False bFillBottom=False Identifier= Condition=True DistanceTop=0 DistanceBottom=0 WrapBefore=True [WrapBefore] { ResetPageNumberOption=0 } ShowInContextUI=True PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= Expandable=False FormulaFilter=True DesignScheme="PROJECT" Animation="" [Body] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="Umsatz der Kategorien" Width=182880 Height=10000 FixedHeight=0 bIsotropic=True PlainTextFormat=True Align=0 AlignDecPosition=-10000 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=False Layout=1 [Left] { Spacing=5000 Line=False } [Top] { Spacing=1000 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=1000 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=14 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 ReservedMinHeight=20000 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] { } } } [Table] { TableType=Chart TableID=Customers RelationID= [DistanceFromPrintBorder] { Left=5000 Top=7000 Right=5000 Bottom=5000 } Height=85000 ColumnCount=0 ColumnCount.Distance=1000 ColumnBreakCondition=False ColumnBreakBefore=False Identifier=Umsatz nach Kategorien (Balken) Condition=True DistanceTop=0 DistanceBottom=0 WrapBefore=False [WrapBefore] { ResetPageNumberOption=0 } ShowInContextUI=True SortOrderID="" [SourceTablePath] { [Table] { ID=Orders RelationID=Customers2Orders } [Table] { ID=Order_Details RelationID=Orders2Order Details } } CombineWithNextStaticTable=False PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= FormulaFilter=/* Kategorie ist enthalten */¤(Order_Details.ProductID@Products.ProductID:CategoryID =@Categories) and¤/* Produkt ist enthalten */¤(Order_Details.ProductID@Products.ProductID:ProductID =@Products) and¤/* Bestelldatum ist im gewählten Bereich */¤(Orders.OrderDate >= @StartDate) and (Orders.OrderDate <= @EndDate) Animation="" HTMLAnimation="" [LLXParameters] { [Engine] { bFill=0 HasAlternatezAxis=False zAxisSecondaryAssignment=1 Orientation=0 UseLightEffect=False FrameColor=LL.Scheme.BackgroundColor0 [AdditionalProperties] { Type=1 DataMode=0 VisMode=0 Flags=7340032 bNewAxisMode=TRUE } [xAxis] { FormulaValue=Order_Details.ProductID@Products.ProductID:Products.CategoryID@Categories.CategoryID:CategoryName FormulaFilter=True SamplesForDesigner=5 AutoSort=4 MaxEntryCount=0 [MaxEntryCount] { bWithOthers=False } Label="Andere" MinimumPercentage=0 RoundLimits=True FormulaCoord=LL.ChartObject.AxisCoordinate [FormulaCoord.Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=12 Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } FormulaCoord.RotationAngle=0 FormulaCoord.FixedSize=False FormulaCoord.OutputFormatter= FormulaLabel="Kategorie" [FormulaLabel.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() } FormulaLabel.RotationAngle=90 FormulaLabel.OutputFormatter= CoordTextPlacement=1 CoordTextPlacement.Equidistant=True [CoordTextPlacement.bFrame] { Layout=0 [Left] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Top] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Right] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Bottom] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } RelativePartOfAtAxisText=30 RelativePartOfLegendText=0 TickmarkColor=LL.Scheme.BackgroundColor0 CountOfIntermediateTicks=0 SignalRegions=False [AreaList] { [ItemList] { } } } [zAxis0] { FormulaMin=True [FormulaMin] { Value=0 } FormulaMax=True [FormulaMax] { Value=1.0 } FilterZeroes=False HandleNullValue=0 FormulaValue=Sum (Order_Details.Quantity * Order_Details.UnitPrice) FormulaCoordOnObjects=3 [FormulaCoordOnObjects] { [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=Null() Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=LL.Color.White PitchAndFamily=Null() OutPrecision=Null() } OutputFormatter=CURRENCY [OutputFormatter.CURRENCY] { DecimalCharType=-1 ThousandsCharType=-1 NegativeFormatType=-1 Decimals=-1 EmptyIfBool=False LeadingZero=True ForceSign=False ExponentialFormat=0 Units= RemoveTrailingZeroes=False MultiplyBy100=False PositiveFormatType=-1 CurrencySymbol= } Formula=LL.ChartObject.AxisCoordinate [Filling] { bShow=0 } RotationAngle=0 OOTextDrawMethod=0 } AutoTickmarks=True [AutoTickmarks] { Value=1.0 } Visual=1 LineTypeOverride=0 VisualSym=-1 CoordGridLines=True [CoordGridLines] { Color=LL.Scheme.BackgroundColor0 LineType=0 } CoordGridLinesWidth=0 CoordGridZebraPattern=0 BarWidthPercentage=60 Distortion=0 PostProcessing=0 [PostProcessing] { Count=3 } FormulaCoord=LL.ChartObject.AxisCoordinate [FormulaCoord.Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=12 Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } FormulaCoord.RotationAngle=0 FormulaCoord.FixedSize=False FormulaCoord.OutputFormatter=CURRENCY [FormulaCoord.OutputFormatter.CURRENCY] { DecimalCharType=-1 ThousandsCharType=-1 NegativeFormatType=-1 Decimals=0 EmptyIfBool=False LeadingZero=True ForceSign=False ExponentialFormat=0 Units= RemoveTrailingZeroes=False MultiplyBy100=False PositiveFormatType=-1 CurrencySymbol= } FormulaLabel="Umsatz" [FormulaLabel.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() } FormulaLabel.RotationAngle=0 FormulaLabel.OutputFormatter=GENERIC CoordTextPlacement=1 CoordTextPlacement.Equidistant=True [CoordTextPlacement.bFrame] { Layout=0 [Left] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Top] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Right] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Bottom] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } RelativePartOfAtAxisText=30 RelativePartOfLegendText=0 TickmarkColor=LL.Scheme.BackgroundColor0 CountOfIntermediateTicks=0 SignalRegions=False [AreaList] { [ItemList] { } } } [RScriptData] { RSCode= } } TitleFormula= [TitleFormula.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() } TitleFormula.OutputFormatter= TitlePosition=0 Background=False [Background] { [Filling] { bShow=LL.Scheme.BackgroundFillMode Raster=1 Color=LL.Scheme.BackgroundColor0 } [Frame] { bShow=0 } [Shadow] { bShow=0 } Rounding=0 } Colors\Color0=LL.Scheme.Color0 Colors\Color1=LL.Scheme.Color1 Colors\Color2=LL.Scheme.Color2 Colors\Color3=LL.Scheme.Color3 Colors\Color4=LL.Scheme.Color4 Colors\Color5=LL.Scheme.Color5 Colors\Color6=LL.Scheme.Color6 Colors\Color7=LL.Scheme.Color7 Colors\Color8=LL.Scheme.Color8 Colors\Color9=LL.Scheme.Color9 EnhancedColorContrast=False Version=2 UUID={BD08D2A6-9AA4-4E26-9DCC-9C62D69019A3} } } [Table] { TableType=List TableID=LLStaticTable RelationID= [DataLines] { bKeepTogether=True bSuppress=False bForceSumCalculation=True KeepTogether=0 } ZebraPattern=0 PageBreakCondition=False [DefaultFrame] { Layout=1 [Left] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Top] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Right] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Bottom] { Spacing=500 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } UseSepTicks=True ColumnCount=0 ColumnCount.Distance=1000 ColumnBreakCondition=False ColumnBreakBefore=False bFooterOnBottom=False bFillBottom=False Identifier= Condition=True DistanceTop=5000 DistanceBottom=0 WrapBefore=False [WrapBefore] { ResetPageNumberOption=0 } ShowInContextUI=True PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= Expandable=False FormulaFilter=True DesignScheme="PROJECT" Animation="" [Body] { [Lines] { [Line] { [Columns] { [Column] { Identifier= Text="Umsatzverlauf der Kategorien" Width=182880 Height=10000 FixedHeight=0 bIsotropic=True PlainTextFormat=True Align=0 AlignDecPosition=-10000 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=False Layout=1 [Left] { Spacing=5000 Line=False } [Top] { Spacing=1000 Line=False } [Right] { Spacing=0 Line=False } [Bottom] { Spacing=1000 Line=False } } [Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=14 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 ReservedMinHeight=20000 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] { } } } [Table] { TableType=Chart TableID=Customers RelationID= [DistanceFromPrintBorder] { Left=5000 Top=7000 Right=5000 Bottom=5000 } Height=85000 ColumnCount=0 ColumnCount.Distance=1000 ColumnBreakCondition=False ColumnBreakBefore=False Identifier=Umsatzverlauf der Kategorien (Linie) Condition=True DistanceTop=0 DistanceBottom=0 WrapBefore=False [WrapBefore] { ResetPageNumberOption=0 } ShowInContextUI=True SortOrderID="" [SourceTablePath] { [Table] { ID=Orders RelationID=Customers2Orders } [Table] { ID=Order_Details RelationID=Orders2Order Details } } CombineWithNextStaticTable=False PDFLevel=0 PDFText= IndexPDFLevel=0 IndexPDFText= FormulaFilter=/* Kategorie ist enthalten */¤(Order_Details.ProductID@Products.ProductID:CategoryID =@Categories) and¤/* Produkt ist enthalten */¤(Order_Details.ProductID@Products.ProductID:ProductID =@Products) and¤/* Bestelldatum ist im gewählten Bereich */¤(Orders.OrderDate >= @StartDate) and (Orders.OrderDate <= @EndDate) Animation="" HTMLAnimation="" [LLXParameters] { [Engine] { bFill=0 HasAlternatezAxis=False zAxisSecondaryAssignment=1 LinearAxis=True UseLightEffect=False FrameColor=LL.Scheme.BackgroundColor0 [AdditionalProperties] { Type=2 DataMode=1 VisMode=0 Flags=5406720 bNewAxisMode=TRUE } [xAxis] { FormulaValue=Order_Details.OrderID@Orders.OrderID:OrderDate FormulaFilter=True SamplesForDesigner=5 AutoSort=0 RoundLimits=True CoordGridLines=False [CoordGridLines] { Color=LL.Scheme.BackgroundColor0 LineType=0 } CoordGridLinesWidth=0 FormulaCoord=LL.ChartObject.AxisCoordinate [FormulaCoord.Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=12 Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } FormulaCoord.RotationAngle=0 FormulaCoord.FixedSize=True FormulaCoord.OutputFormatter=DATE [FormulaCoord.OutputFormatter.DATE] { DateFormatString=%q/%y DateFormatType=-3 } FormulaLabel="Datum" [FormulaLabel.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() } FormulaLabel.RotationAngle=0 FormulaLabel.OutputFormatter=GENERIC CoordTextPlacement=1 CoordTextPlacement.Equidistant=True [CoordTextPlacement.bFrame] { Layout=0 [Left] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Top] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Right] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Bottom] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } RelativePartOfAtAxisText=30 RelativePartOfLegendText=0 TickmarkColor=LL.Scheme.BackgroundColor0 CountOfIntermediateTicks=0 SignalRegions=False [AreaList] { [ItemList] { } } } [yAxis] { FormulaValue=Order_Details.ProductID@Products.ProductID:Products.CategoryID@Categories.CategoryID:CategoryName FormulaFilter=True SamplesForDesigner=5 AutoSort=0 RoundLimits=True FormulaCoord=LL.ChartObject.AxisCoordinate [FormulaCoord.Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=12 Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } FormulaCoord.RotationAngle=0 FormulaCoord.FixedSize=False FormulaCoord.OutputFormatter= FormulaLabel="Kategorie" [FormulaLabel.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() } FormulaLabel.RotationAngle=0 FormulaLabel.OutputFormatter= CoordTextPlacement=4 CoordTextPlacement.Equidistant=True [CoordTextPlacement.bFrame] { Layout=0 [Left] { Spacing=1000 Line=False } [Top] { Spacing=1000 Line=False } [Right] { Spacing=1000 Line=False } [Bottom] { Spacing=1000 Line=False } } RelativePartOfAtAxisText=30 RelativePartOfLegendText=0 CountOfIntermediateTicks=0 [AreaList] { [ItemList] { } } } [zAxis0] { FormulaMin=True [FormulaMin] { Value=1.0 } FormulaMax=True [FormulaMax] { Value=1.0 } FilterZeroes=False HandleNullValue=0 FormulaValue=Sum (Order_Details.Quantity * Order_Details.UnitPrice) FormulaCoordOnObjects=0 [FormulaCoordOnObjects] { [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() } OutputFormatter= Formula=LL.ChartObject.AxisCoordinate [Filling] { bShow=0 } RotationAngle=0 OOTextDrawMethod=0 } AutoTickmarks=True [AutoTickmarks] { Value=1.0 } Visual=5 LineTypeOverride=0 VisualSym=-1 CoordGridLines=True [CoordGridLines] { Color=LL.Scheme.BackgroundColor0 LineType=0 } CoordGridLinesWidth=0 CoordGridZebraPattern=0 BarWidthPercentage=60 Distortion=0 PostProcessing=0 [PostProcessing] { Count=3 } FormulaCoord=LL.ChartObject.AxisCoordinate [FormulaCoord.Font] { Default=True FaceName=Null() GdiCharSet=Null() Size=12 Width=#Null() Bold=Null() Italic=Null() Underline=Null() Strikeout=Null() Color=Null() PitchAndFamily=Null() OutPrecision=Null() } FormulaCoord.RotationAngle=0 FormulaCoord.FixedSize=False FormulaCoord.OutputFormatter=CURRENCY [FormulaCoord.OutputFormatter.CURRENCY] { DecimalCharType=-1 ThousandsCharType=-1 NegativeFormatType=-1 Decimals=0 EmptyIfBool=False LeadingZero=True ForceSign=False ExponentialFormat=0 Units= RemoveTrailingZeroes=False MultiplyBy100=False PositiveFormatType=-1 CurrencySymbol= } FormulaLabel="Umsatz" [FormulaLabel.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() } FormulaLabel.RotationAngle=90 FormulaLabel.OutputFormatter=GENERIC CoordTextPlacement=1 CoordTextPlacement.Equidistant=True [CoordTextPlacement.bFrame] { Layout=0 [Left] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Top] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Right] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } [Bottom] { Spacing=1000 Line=True [Line] { Color=LL.Color.Black LineType=0 } LineWidth=0 } } RelativePartOfAtAxisText=30 RelativePartOfLegendText=0 TickmarkColor=LL.Scheme.BackgroundColor0 CountOfIntermediateTicks=0 SignalRegions=False [AreaList] { [ItemList] { } } } [RScriptData] { RSCode= } } TitleFormula="" [TitleFormula.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() } TitleFormula.OutputFormatter= TitlePosition=0 Background=False [Background] { [Filling] { bShow=LL.Scheme.BackgroundFillMode Raster=1 Color=LL.Scheme.BackgroundColor0 } [Frame] { bShow=0 } [Shadow] { bShow=0 } Rounding=0 } Colors\Color0=LL.Scheme.Color0 Colors\Color1=LL.Scheme.Color1 Colors\Color2=LL.Scheme.Color2 Colors\Color3=LL.Scheme.Color3 Colors\Color4=LL.Scheme.Color4 Colors\Color5=LL.Scheme.Color5 Colors\Color6=LL.Scheme.Color6 Colors\Color7=LL.Scheme.Color7 Colors\Color8=LL.Scheme.Color8 Colors\Color9=LL.Scheme.Color9 EnhancedColorContrast=False Version=2 UUID={0134B6FB-F04A-46E3-AFFF-42FECF8575B1} } } } } [Object] ObjectID=1 ObjectName=Text Locked=FALSE LinkUUID={373B6DFF-AF3E-4D2B-A5B7-20655A41B323} LinkMode=32 LayerID=0 LayerCond= GroupUUID= Identifier=Druckinfo Condition=True UserLocked=False WrapBefore=False bPageWrap=False ExportAsPicture=False Position/Left=15000 Position/Top=274960 Position/Width=182880 Position/Height=8740 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="Seite " + FStr$ (Page (),"###",1) + " von " + TotalPages$ () + "¶" + "Stand: " + LocDate$ (Today ()) + " " + LocTime$ (Now (),"",10) Tab=0 TabAlign=0 } } } [UserVariables] [Parameters] [@Parameters] { [Parameters] { LL.DesignScheme="COMBITCOLORWHEEL" LL.ProjectDescription=Diagramme mit Berichtsparametern } } [UsedIdentifiers] Variables= Fields=Categories.CategoryID;Categories.CategoryName;Customers.CustomerID;Order Details.OrderID;Order Details.OrderID@Orders.OrderID:OrderDate;Order Details.ProductID@Products.ProductID:CategoryID;Order Details.ProductID@Products.ProductID:ProductID;Order Details.ProductID@Products.ProductID:Products.CategoryID@Categories.CategoryID:CategoryName;Order Details.Quantity;Order Details.UnitPrice;Order_Details.OrderID;Order_Details.ProductID;Orders.CustomerID;Orders.OrderDate;Orders.OrderID;Products.CategoryID;Products.CategoryID@Categories.CategoryID:CategoryName;Products.ProductID;Products.ProductName ChartFields= [PageLayouts] [@PageLayouts] { [PageLayouts] { [PageLayout] { DisplayName=Standard-Layout Condition=True SourceTray=0 ForcePaperFormat=True UsePhysicalPaper=True PaperFormat=9 PaperFormat.cx=209970 PaperFormat.cy=296930 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 } } [ReportParameters] { [ReportParameter] { Identifier=@Categories ID={72F8F91A-DDC3-41A9-B478-5AFAB7465687} DefaultValue.UseAll=False DefaultValue=1␉2␉3 Source=0 [Source] { TableID=Categories Field=Categories.CategoryID SortOrderID="CategoryID ASC" OutputFormatter= DisplayFormula=Categories.CategoryName } Filter=True Type=0 Tooltip= Prompt="Kategorien:" VisibleInReport=True AllowBlank=False AllowNULL=False AllowMultipleValues=True ParentID= } [ReportParameter] { Identifier=@Products ID={40DB1317-0658-4CED-90B5-B6F3686E0FB5} DefaultValue.UseAll=True Source=0 [Source] { TableID=Products;Categories2Products Field=Products.ProductID SortOrderID="ProductID ASC" OutputFormatter= DisplayFormula=Products.CategoryID@Categories.CategoryID:CategoryName + ": " + Products.ProductName } Filter=True Type=0 Tooltip= Prompt="Produkte:" VisibleInReport=True AllowBlank=False AllowNULL=False AllowMultipleValues=True ParentID={72F8F91A-DDC3-41A9-B478-5AFAB7465687} } [ReportParameter] { Identifier=@StartDate ID={3F38ADFF-B8DE-4471-8930-FA8AF9DB73D0} DefaultValue.UseAll=False DefaultValue=Date ("01.01.1995") Source=2 [Source] { ContentsType=67108864 } Type=1 Tooltip= Prompt="Startdatum:" VisibleInReport=True AllowBlank=False AllowNULL=False AllowMultipleValues=False ParentID= } [ReportParameter] { Identifier=@EndDate ID={435FB920-74C1-4325-86A1-B686296A9A0D} DefaultValue.UseAll=False DefaultValue=Today () Source=2 [Source] { ContentsType=67108864 } Type=1 Tooltip= Prompt="Enddatum:" VisibleInReport=True AllowBlank=False AllowNULL=False AllowMultipleValues=False ParentID= } } [UIDescriptions] { 0=Diagramme mit Berichtsparametern } }