Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Roadshow 2019 - Codesnippets
[List description]
[Description]
Text=List & Label Projektdatei
FileVersion=15
RootTable=CachedCustomers
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
[@DatabaseStructure]
{
[DatabaseStructures]
{
[DatabaseStructure]
{
[Table:CachedCustomers]
{
[UsedIdentifiers]
{
CachedCustomers.Country=True
CachedCustomers.CustomerID=True
}
}
[Table:CachedOrders]
{
[Relations]
{
CachedCustomers2CachedOrders=CachedCustomers
}
[UsedIdentifiers]
{
CachedOrders.CustomerID=True
CachedOrders.OrderDate=True
CachedOrders.OrderID=True
CachedOrders.ShipCountry=True
}
}
}
}
}
[Layout]
P1.Template=
xGrid=1000
yGrid=1000
GridShow=FALSE
GridSnap=FALSE
EnhancedExpressions=TRUE
EnhancedOldExpressions=FALSE
Decimals=2
RealDataPreviewPageLimit=-2
DefFont={(0,0,0),16.000000,-27,0,0,0,400,0,0,0,0,3,2,1,34,Arial}
HelpLines.Horizontal=
HelpLines.Vertical=
PDF.MaxOutlineDepth=2
PDF.MaxOutlineDepth.IDX=3
ObjectCount=1
[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=6
ObjectName=Berichtscontainer
Locked=FALSE
LinkUUID={C505EF9D-7D60-4BEF-A006-3C7751049B15}
LinkMode=32
LayerID=0
LayerCond=
GroupUUID=
Identifier=Customers
Condition=True
UserLocked=False
WrapBefore=False
Position/Left=18840
Position/Top=6100
Position/Width=267300
Position/Height=189010
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=1000
[@Tables]
{
[Tables]
{
[Table]
{
TableType=Crosstab
TableID=CachedCustomers
RelationID=
[DistanceFromPrintBorder]
{
Left=0
Top=0
Right=0
Bottom=0
}
ColumnCount=0
ColumnCount.Distance=1000
FillPrioHorizonal=False
ColumnBreakCondition=False
ColumnBreakBefore=False
Identifier=
Condition=True
DistanceTop=2000
DistanceBottom=3000
WrapBefore=False
[WrapBefore]
{
ResetPageNumberOption=0
}
ShowInContextUI=True
[SourceTablePath]
{
[Table]
{
ID=CachedOrders
RelationID=CachedCustomers2CachedOrders
}
}
PDFLevel=0
PDFText=
IndexPDFLevel=0
IndexPDFText=
FormulaFilter=True
Animation=""
[LLXParameters]
{
[Properties]
{
bFill=0
[Split]
{
Percentage=100
[Cols]
{
RepeatLabels=False
BreakLevel=0
[BreakLevel]
{
Force=False
}
}
[Rows]
{
RepeatLabels=False
BreakLevel=0
[BreakLevel]
{
Force=False
}
}
}
ShadowPages=True
DistanceTop=1000
PDFOutline=
Link.URL=
MinHeight=100000
[DefaultFrame]
{
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
DesignScheme="PROJECT"
HarmonicLineHeights=True
SamplesForDesigner=3
}
[CellDefinitions]
{
[Level 0-0]
{
[Coord.Row]
{
Formula=CachedCustomers.Country
}
[Coord.Col]
{
Formula=Quarter(CachedOrders.OrderDate)
}
[Properties.Cell]
{
OutputFormatter=
Formula=Count(1)
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=True
VALUE=Count(1)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
[CrosstabCellDefinitionPropList.Next]
{
OutputFormatter=PERCENTAGE
[OutputFormatter.PERCENTAGE]
{
DecimalCharType=-2
ThousandsCharType=-2
NegativeFormatType=-2
Decimals=0
EmptyIfBool=False
LeadingZero=True
ForceSign=True
ExponentialFormat=0
Units=
RemoveTrailingZeroes=False
MultiplyBy100=True
}
Formula=Div(Crosstab.Value(0,0,0), Crosstab.Value(0,-1,0)) - 1
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=True
VALUE=Count(CachedOrders.OrderID)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
[Item]
{
[Condition]
{
Condition=LL.CurrentValue < 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.OrangeRed
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
[Item]
{
[Condition]
{
Condition=LL.CurrentValue > 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.ForestGreen
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
}
}
}
[Properties.Label.Row]
{
OutputFormatter=
Formula="Gesamt"
[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
bFill=1
Raster=1
BkColor=LL.Scheme.BackgroundColor1
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
ShowSummary=True
ShowSummary.BeforeEntries=False
Align=1
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
}
[Properties.Label.Col]
{
OutputFormatter=
Formula="Gesamt"
[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
bFill=1
Raster=1
BkColor=LL.Scheme.BackgroundColor1
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
ShowSummary=True
ShowSummary.BeforeEntries=False
Align=1
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
}
[Properties.Span.Row]
{
OutputFormatter=
Formula=CachedCustomers.Country
[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
bFill=1
Raster=1
BkColor=LL.Scheme.BackgroundColor1
Link.URL=
[DrillDownItem]
{
DrillDownType=1
MenuText="ordersbycountry.lst"
ProjectFileName=ProjectPath$() + "ordersbycountry.lst"
SubReportDescription=List & Label Projektdatei
[ReportParameters]
{
@CountryName=CachedOrders.ShipCountry
[@CountryName.Info]
{
ContentsType=4
AllowMultipleValues=False
}
}
ReportParameterList=
ShowReportParameterPreviewPane=False
}
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
ShowSpanLabel=True
SortOrderAscending=4
[SortOrderAscending]
{
SubCellIndex=0
}
MaxEntryCount=5
[MaxEntryCount]
{
bWithOthers=True
}
Label="Andere"
MinimumPercentage=0
AutoFill=0
Expandable=False
Align=1
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
SpaceOptimization=True
[ConditionalFormatter]
{
}
}
[Properties.Span.Col]
{
OutputFormatter=
Formula=Quarter(CachedOrders.OrderDate)
[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
bFill=1
Raster=1
BkColor=LL.Scheme.BackgroundColor1
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
ShowSpanLabel=True
SortOrderAscending=0
[SortOrderAscending]
{
SubCellIndex=0
}
MaxEntryCount=0
[MaxEntryCount]
{
bWithOthers=False
}
Label="Andere"
MinimumPercentage=0
AutoFill=0
Expandable=False
Align=1
AlignDecPosition=-10000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
}
}
[Level 0-1]
{
[Coord.Col]
{
Formula=Year(CachedOrders.OrderDate)
}
[Properties.Cell]
{
OutputFormatter=
Formula=Count(1)
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=True
VALUE=Count(1)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
[CrosstabCellDefinitionPropList.Next]
{
OutputFormatter=PERCENTAGE
[OutputFormatter.PERCENTAGE]
{
DecimalCharType=-2
ThousandsCharType=-2
NegativeFormatType=-2
Decimals=0
EmptyIfBool=False
LeadingZero=True
ForceSign=True
ExponentialFormat=0
Units=
RemoveTrailingZeroes=False
MultiplyBy100=True
}
Formula=Div(Crosstab.Value(0,0,0), Crosstab.Value(0,-1,0)) - 1
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=True
VALUE=Count(CachedOrders.OrderID)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
[Item]
{
[Condition]
{
Condition=LL.CurrentValue < 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.OrangeRed
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
[Item]
{
[Condition]
{
Condition=LL.CurrentValue > 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.ForestGreen
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
}
}
}
[Properties.Label.Col]
{
OutputFormatter=
Formula="Gesamt"
[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
bFill=1
Raster=1
BkColor=LL.Scheme.BackgroundColor1
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
ShowSummary=True
ShowSummary.BeforeEntries=False
Align=1
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
}
[Properties.Span.Col]
{
OutputFormatter=
Formula=Year(CachedOrders.OrderDate)
[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
bFill=1
Raster=1
BkColor=LL.Scheme.BackgroundColor1
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
ShowSpanLabel=True
SortOrderAscending=0
[SortOrderAscending]
{
SubCellIndex=0
}
MaxEntryCount=0
[MaxEntryCount]
{
bWithOthers=False
}
Label="Andere"
MinimumPercentage=0
AutoFill=0
Expandable=True
Align=1
AlignDecPosition=-10000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
}
}
[Level 0-2]
{
[Coord.Col]
{
}
[Properties.Cell]
{
OutputFormatter=
Formula=Count(1)
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=True
VALUE=Count(1)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
[CrosstabCellDefinitionPropList.Next]
{
OutputFormatter=PERCENTAGE
[OutputFormatter.PERCENTAGE]
{
DecimalCharType=-2
ThousandsCharType=-2
NegativeFormatType=-2
Decimals=0
EmptyIfBool=False
LeadingZero=True
ForceSign=True
ExponentialFormat=0
Units=
RemoveTrailingZeroes=False
MultiplyBy100=True
}
Formula=Div(Crosstab.Value(0,0,0), Crosstab.Value(0,-1,0)) - 1
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=False
VALUE=Count(CachedOrders.OrderID)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
[Item]
{
[Condition]
{
Condition=LL.CurrentValue < 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.OrangeRed
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
[Item]
{
[Condition]
{
Condition=LL.CurrentValue > 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.ForestGreen
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
}
}
}
[Properties.Label.Col]
{
OutputFormatter=
Formula="Gesamt"
[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
bFill=1
Raster=1
BkColor=LL.Scheme.BackgroundColor1
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
ShowSummary=True
ShowSummary.BeforeEntries=False
Align=1
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
}
[Properties.Span.Col]
{
OutputFormatter=
Formula="Überschrift"
[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
bFill=1
Raster=1
BkColor=LL.Scheme.BackgroundColor1
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
ShowSpanLabel=False
SortOrderAscending=0
[SortOrderAscending]
{
SubCellIndex=0
}
MaxEntryCount=0
[MaxEntryCount]
{
bWithOthers=False
}
Label="Andere"
MinimumPercentage=0
AutoFill=0
Expandable=False
Align=1
AlignDecPosition=-10000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
}
}
[Level 1-0]
{
[Coord.Row]
{
}
[Properties.Cell]
{
OutputFormatter=
Formula=Count(1)
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=True
VALUE=Count(1)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
[CrosstabCellDefinitionPropList.Next]
{
OutputFormatter=PERCENTAGE
[OutputFormatter.PERCENTAGE]
{
DecimalCharType=-2
ThousandsCharType=-2
NegativeFormatType=-2
Decimals=0
EmptyIfBool=False
LeadingZero=True
ForceSign=True
ExponentialFormat=0
Units=
RemoveTrailingZeroes=False
MultiplyBy100=True
}
Formula=Div(Crosstab.Value(0,0,0), Crosstab.Value(0,-1,0)) - 1
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=True
VALUE=Count(CachedOrders.OrderID)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
[Item]
{
[Condition]
{
Condition=LL.CurrentValue < 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.OrangeRed
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
[Item]
{
[Condition]
{
Condition=LL.CurrentValue > 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.ForestGreen
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
}
}
}
[Properties.Label.Row]
{
OutputFormatter=
Formula="Gesamt"
[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
bFill=1
Raster=1
BkColor=LL.Scheme.BackgroundColor1
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
ShowSummary=True
ShowSummary.BeforeEntries=False
Align=1
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
}
[Properties.Span.Row]
{
OutputFormatter=
Formula="Überschrift"
[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
bFill=1
Raster=1
BkColor=LL.Scheme.BackgroundColor1
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
ShowSpanLabel=False
SortOrderAscending=0
[SortOrderAscending]
{
SubCellIndex=0
}
MaxEntryCount=0
[MaxEntryCount]
{
bWithOthers=False
}
Label="Andere"
MinimumPercentage=0
AutoFill=0
Expandable=False
Align=1
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
SpaceOptimization=True
[ConditionalFormatter]
{
}
}
}
[Level 1-1]
{
[Properties.Cell]
{
OutputFormatter=
Formula=Count(1)
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=True
VALUE=Count(1)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
[CrosstabCellDefinitionPropList.Next]
{
OutputFormatter=PERCENTAGE
[OutputFormatter.PERCENTAGE]
{
DecimalCharType=-2
ThousandsCharType=-2
NegativeFormatType=-2
Decimals=0
EmptyIfBool=False
LeadingZero=True
ForceSign=True
ExponentialFormat=0
Units=
RemoveTrailingZeroes=False
MultiplyBy100=True
}
Formula=Div(Crosstab.Value(0,0,0), Crosstab.Value(0,-1,0)) - 1
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=True
VALUE=Count(CachedOrders.OrderID)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
[Item]
{
[Condition]
{
Condition=LL.CurrentValue < 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.OrangeRed
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
[Item]
{
[Condition]
{
Condition=LL.CurrentValue > 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.ForestGreen
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
}
}
}
}
[Level 1-2]
{
[Properties.Cell]
{
OutputFormatter=
Formula=Count(1)
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=True
VALUE=Count(1)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
}
[CrosstabCellDefinitionPropList.Next]
{
OutputFormatter=PERCENTAGE
[OutputFormatter.PERCENTAGE]
{
DecimalCharType=-2
ThousandsCharType=-2
NegativeFormatType=-2
Decimals=0
EmptyIfBool=False
LeadingZero=True
ForceSign=True
ExponentialFormat=0
Units=
RemoveTrailingZeroes=False
MultiplyBy100=True
}
Formula=Div(Crosstab.Value(0,0,0), Crosstab.Value(0,-1,0)) - 1
[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
bFill=0
Link.URL=
VAlign=1
[Frame]
{
Default=True
Layout=1
[Left]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Top]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Right]
{
Spacing=1000
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
[Bottom]
{
Spacing=500
Line=True
[Line]
{
Color=RGB(180,180,180)
LineType=0
}
LineWidth=0
}
}
Condition=False
VALUE=Count(CachedOrders.OrderID)
SubCellLabel=
Align=2
AlignDecPosition=-10000
MaxCellWidth=0
MinWidth=1000
MinHeight=1000
MaxHeight=0
SpaceOptimization=True
[ConditionalFormatter]
{
[Item]
{
[Condition]
{
Condition=LL.CurrentValue < 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.OrangeRed
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
[Item]
{
[Condition]
{
Condition=LL.CurrentValue > 0
}
[StopIteration]
{
StopIteration=False
}
[FormatterItems]
{
[Item.Font]
{
[Font]
{
Default=True
FaceName=Null()
GdiCharSet=Null()
Size=Null()
Width=#Null()
Bold=Null()
Italic=Null()
Underline=Null()
Strikeout=Null()
Color=LL.Color.ForestGreen
PitchAndFamily=Null()
OutPrecision=Null()
}
}
}
}
}
}
}
}
}
Version=1
UUID={3A93DFDA-5CDC-4F9B-B42F-16A2F5216A87}
}
}
[Table]
{
TableType=Chart
TableID=CachedCustomers
RelationID=
[DistanceFromPrintBorder]
{
Left=0
Top=0
Right=0
Bottom=0
}
Height=100000
ColumnCount=0
ColumnCount.Distance=1000
FillPrioHorizonal=False
ColumnBreakCondition=False
ColumnBreakBefore=False
Identifier=
Condition=True
DistanceTop=0
DistanceBottom=0
WrapBefore=False
[WrapBefore]
{
ResetPageNumberOption=0
}
ShowInContextUI=True
SortOrderID=
[SourceTablePath]
{
[Table]
{
ID=CachedOrders
RelationID=CachedCustomers2CachedOrders
}
}
CombineWithNextStaticTable=False
PDFLevel=0
PDFText=
IndexPDFLevel=0
IndexPDFText=
FormulaFilter=True
Animation=""
HTMLAnimation=""
[LLXParameters]
{
[Engine]
{
bFill=0
HasAlternatezAxis=False
zAxisSecondaryAssignment=0
Orientation=1
LabelAlignment=2
UseLightEffect=True
FrameColor=RGB(180,180,180)
[AdditionalProperties]
{
Type=1
DataMode=3
VisMode=0
Flags=5373952
bNewAxisMode=TRUE
}
[xAxis]
{
FormulaValue=CachedCustomers.Country
FormulaFilter=True
SamplesForDesigner=5
AutoSort=4
MaxEntryCount=5
[MaxEntryCount]
{
bWithOthers=False
}
Label="Andere"
MinimumPercentage=0
RoundLimits=True
FormulaCoord=CachedCustomers.Country
[FormulaCoord.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()
}
FormulaCoord.RotationAngle=0
FormulaCoord.FixedSize=False
FormulaCoord.OutputFormatter=
FormulaLabel=""
[FormulaLabel.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()
}
FormulaLabel.RotationAngle=0
FormulaLabel.OutputFormatter=
CoordTextPlacement=1
CoordTextPlacement.Equidistant=False
[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
LegendAutowrap=-1
TickmarkColor=RGB(180,180,180)
CountOfIntermediateTicks=0
SignalRegions=False
[AreaList]
{
[ItemList]
{
}
}
}
[yAxis]
{
FormulaValue=Year(CachedOrders.OrderDate)
FormulaFilter=True
SamplesForDesigner=5
AutoSort=0
RoundLimits=True
MinPercentageForArcs=0
FormulaCoordOthers="Andere"
[FormulaCoordOthers.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()
}
FormulaCoordOthers.FixedSize=False
FormulaCoordOthers.OutputFormatter=
FormulaCoord=Year(CachedOrders.OrderDate)
[FormulaCoord.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()
}
FormulaCoord.RotationAngle=0
FormulaCoord.FixedSize=False
FormulaCoord.OutputFormatter=
FormulaLabel=""
[FormulaLabel.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()
}
FormulaLabel.RotationAngle=0
FormulaLabel.OutputFormatter=
CoordTextPlacement=4
CoordTextPlacement.Equidistant=False
[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
LegendAutowrap=-1
CountOfIntermediateTicks=0
[AreaList]
{
[ItemList]
{
}
}
}
[zAxis0]
{
FormulaMin=True
[FormulaMin]
{
Value=0
}
FormulaMax=True
[FormulaMax]
{
Value=1.0
}
Distortion=0
FilterZeroes=False
HandleNullValue=0
FormulaValue=Count(1)
FormulaCoordOnObjects=1
[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=Str$(LL.ChartObject.AxisCoordinate,0,0)
[Filling]
{
bShow=0
}
RotationAngle=0
OOTextDrawMethod=0
}
AutoTickmarks=True
[AutoTickmarks]
{
Value=1.0
}
Visual=0
LineTypeOverride=0
VisualSym=-1
CoordGridLines=True
[CoordGridLines]
{
Color=RGB(180,180,180)
LineType=0
}
CoordGridLinesWidth=0
CoordGridZebraPattern=0
BarWidthPercentage=40
PostProcessing=0
[PostProcessing]
{
Count=3
}
FormulaCoord=LL.ChartObject.AxisCoordinate
[FormulaCoord.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()
}
FormulaCoord.RotationAngle=0
FormulaCoord.FixedSize=False
FormulaCoord.OutputFormatter=
FormulaLabel=""
[FormulaLabel.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()
}
FormulaLabel.RotationAngle=90.0
FormulaLabel.OutputFormatter=
CoordTextPlacement=1
CoordTextPlacement.Equidistant=False
[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
LegendAutowrap=-1
TickmarkColor=RGB(180,180,180)
CountOfIntermediateTicks=0
SignalRegions=False
[AreaList]
{
[ItemList]
{
}
}
}
[RScriptData]
{
RSCode=
}
}
TitleFormula="Überschrift"
[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=2
Background=True
[Background]
{
[Filling]
{
bShow=0
}
[Frame]
{
bShow=1
Color=RGB(180,180,180)
Width=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={148620CD-AF4A-4EFF-AF94-B6BABFBE3A3E}
}
}
}
}
[UserVariables]
[Parameters]
[@Parameters]
{
[Parameters]
{
LL.ActiveLayout=Standard-Layout
LL.ProjectDescription=List & Label Projektdatei
}
}
[UsedIdentifiers]
Variables=
Fields=CachedCustomers.Country;CachedCustomers.CustomerID;CachedOrders.CustomerID;CachedOrders.OrderDate;CachedOrders.OrderID;CachedOrders.ShipCountry
ChartFields=
[PageLayouts]
[@PageLayouts]
{
[PageLayouts]
{
[PageLayout]
{
DisplayName=
Condition=True
SourceTray=0
ForcePaperFormat=True
UsePhysicalPaper=True
PaperFormat=9
PaperFormat.cx=210010
PaperFormat.cy=297010
PaperFormat.Orientation=2
Copies=1
Duplex=0
Collate=0
FitPage=False
ShowInPrintDialog=True
}
}
}
[ExtendedInfo]
[@ExtendedInfos]
{
[UserDefinedDesignScheme]
{
[Foreground]
{
Color=(188,221,161)
Color=(154,201,73)
Color=(135,165,101)
Color=(235,93,129)
Color=(75,152,184)
Color=(91,179,213)
Color=(171,214,226)
Color=(153,153,153)
Color=(102,102,102)
Color=(204,204,204)
}
[Background]
{
Color=(251,251,251)
Color=(204,204,204)
Color=(77,77,77)
Color=(51,51,51)
FillMode=1
}
}
[AccumulationGroups]
{
}
[UIDescriptions]
{
}
}
using combit.ListLabel25;
using combit.ListLabel25.DataProviders;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
namespace RoadShowApp
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var builder = new SqlConnectionStringBuilder();
builder.DataSource = "cmbtdev3";
builder.InitialCatalog = "Northwind";
builder.IntegratedSecurity = true;
var connection = new SqlConnection(builder.ConnectionString);
var sqlProvider = new SqlConnectionDataProvider(connection);
var inMemory = new InMemoryDataProvider();
inMemory.AddTable(sqlProvider, "Orders", "CachedOrders");
inMemory.AddTable(sqlProvider, "Customers", "CachedCustomers");
inMemory.AddRelation("CachedCustomers", "CachedOrders", "CustomerID", "CustomerID");
DbCommandSetDataProvider commandset = new DbCommandSetDataProvider();
SqlCommand command = new SqlCommand("dbo.OrdersByCountry", connection);
command.Parameters.AddWithValue("@CountryName", "{{CountryName=Germany}}");
command.CommandType = System.Data.CommandType.StoredProcedure;
commandset.AddCommand(command, "OrdersByCountry");
var collection = new DataProviderCollection();
collection.Add(sqlProvider);
collection.Add(inMemory);
collection.Add(commandset);
using (ListLabel LL = new ListLabel())
{
LL.DataSource = collection;
// schöner Dateiname
LL.ProjectParameters[LlProjectParameter.SaveAsFilename].Value = "Rechnung-Northwind.pdf";
// Signatur und Body
LL.ExportOptions.Add(LlExportOption.ExportMailProvider, "XMAPI");
LL.ExportOptions.Add(LlExportOption.ExportMailHtmlBody, "Hier ist Ihre Rechnung.");
LL.ExportOptions.Add(LlExportOption.ExportMailSignatureName, "standard");
// ZUGFeRD 2.0
LL.ExportOptions.Add(LlExportOption.PdfZUGFeRDXmlPath, @"c:\users\public\zugferd.xml");
LL.Design();
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
var builder = new SqlConnectionStringBuilder();
builder.DataSource = "cmbtdev3";
builder.InitialCatalog = "combit_Small3";
builder.IntegratedSecurity = true;
var connection = new SqlConnection(builder.ConnectionString);
var sqlProvider = new SqlConnectionDataProvider(connection);
using (ListLabel LL = new ListLabel())
{
LL.DataSource = sqlProvider;
LL.AutoDefineTable += LL_AutoDefineTable;
LL.Design();
}
}
private void LL_AutoDefineTable(object sender, AutoDefineDataItemEventArgs e)
{
if (e.Name.StartsWith("cmbt_"))
e.Suppress = true;
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.