Alternative Artikelzeilen im Angebot nach Totalbetrag drucken

Daniel Ebi

Hallo,
wir moechten gerne beim Angebot alle Alternativen Artikel (LineType = A) sowie die dazugehörenden Textzeilen (einfach alle Texte nach der Alternativ-Zeile) nach dem Druck des Gesamtbetrages ausgeben.
Hierzu habe ich nun das Standard-DIN-Layout so geändert, dass ich den Bereich "detail5" vom Datenband "DocumentRow" hinter den Gesamtbetrag verschoben habe (in einen neues Datenbank für DocumentRow). Für die Alternativen Artikelzeilen funktioniert das nun: Vor dem Totalbetrag werden diese nicht gedruckt, stattdessen aber danach.
Wie bekomme ich aber nun die Texte dahin? Diese können ja nicht unterschieden werden, ob sie vor oder nach der Alternativzeile kommen.

Vielen Dank für Eure Ideen...

Daniel Ebi

Philipp Knecht

Hallo Daniel

Habe dir einen Schnippsel vorbereitet.
Einfach Copy Paste im Designer ins DIN Layout in den DocumentFooter rein.
Dann kannst du abkupfern.

hth

[quote]<?xml version="1.0" encoding="utf-16" standalone="yes"?><root type="PerpetuumSoft.Reporting.Designer.ReportClipboard" id="1" version="2"><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="2"><Item type="swissLD.Reporting.AdvancedDataBand" id="3" DataSource="B1_Data.Row" ColumnsGap="0" Location="0;5716.535433070866" Name="AlternativeItem" Size="2480.3149606299212;507.87401574803152"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="4" /><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="5"><Item type="swissLD.Reporting.AdvancedDataBand" id="6" CanShrink="true" DataSource="B1_Data.Row.RowRowSubtotalText" ColumnsGap="0" CanGrow="true" Location="0;212.5984251968504" Name="AlternativeText" Size="2480.3149606299212;212.5984251968504"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="7" /><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="8"><Item type="PerpetuumSoft.Reporting.DOM.Detail" id="9" CanShrink="true" MinSpaceAfter="59.055118110236222" CanBreak="true" CanGrow="true" Location="0;59.055118110236222" Name="detail10" Size="2480.3149606299212;94.488189697265625"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="10"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="11" Expression="AlternativeText(&quot;LineType&quot;)=&quot;T&quot; AND AlternativeItem(&quot;LineType&quot;)=&quot;A&quot;" PropertyName="Visible" /><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="12" Expression="AlternativeText(&quot;LineText&quot;).StartsWith(&quot;&lt;/np&gt;&quot;)" PropertyName="NewPageBefore" /></DataBindings><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="13"><Item type="PerpetuumSoft.Reporting.DOM.AdvancedText" id="14" CanShrink="true" Location="295.27560424804688;23.622047424316406" CanBreak="true" Text="Textline" TextAlign="TopLeft" CanGrow="true" StyleName="RowContent" Name="advancedText5" Size="1677.1654052734375;59.055118560791016"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="15"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="16" Expression="LD.MultiLineRTF(AlternativeText(&quot;LineText&quot;))" PropertyName="Text" /></DataBindings></Item></Controls><Aggregates type="PerpetuumSoft.Reporting.DOM.AggregateCollection" id="17" /></Item></Controls><Aggregates type="PerpetuumSoft.Reporting.DOM.AggregateCollection" id="18" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Detail" id="19" MinSpaceAfter="177.16535433070868" CanGrow="true" Location="0;82.677165354330711" StyleName="RowContent" Name="detail14" Size="2480.3149606299212;59.055118560791016"><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="20"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="21" Expression="AlternativeItem(&quot;LineType&quot;)=&quot;A&quot;" PropertyName="Visible" /></DataBindings><Controls type="PerpetuumSoft.Reporting.DOM.ReportControlCollection" id="22"><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="23" CanShrink="true" Location="295.2755905511811;11.811023622047244" Text="Bezeichnung" TextAlign="TopLeft" CanGrow="true" StyleName="RowContent" GrowToBottom="true" Name="textBox135" Size="1157.4803466796875;47.244094848632812"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="24" Color="DimGray" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="25" FamilyName="Arial" Size="9" Underline="Off" Italic="On" Bold="Off" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="26"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="27" Expression="AlternativeItem(&quot;DescML&quot;)" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="28" CanShrink="true" Location="1452.7559055118111;11.811023622047244" Text="Quantity" TextAlign="TopRight" StyleName="RowContent" GrowToBottom="true" Name="textBox136" Size="177.16535949707031;47.244094848632812"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="29" Color="DimGray" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="30" FamilyName="Arial" Size="9" Underline="Off" Italic="On" Bold="Off" /><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="31" UseCultureSettings="false" FormatStyle="Number" UseGroupSeparator="false" DecimalPlaces="1" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="32"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="33" Expression="AlternativeItem(&quot;Quantity&quot;)" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="34" CanShrink="true" Location="2102.3623046875;11.811023712158203" Text="LineTotal" TextAlign="TopRight" StyleName="RowContent" GrowToBottom="true" Name="textBox137" Size="259.842529296875;47.244094848632812"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="35" Color="DimGray" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="36" FamilyName="Arial" Size="9" Underline="Off" Italic="On" Bold="Off" /><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="37" UseCultureSettings="false" GroupSeparator="" FormatStyle="Number" UseGroupSeparator="false" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="38"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="39" Expression="iif (isFC,AlternativeItem(&quot;TotalFrgn&quot;),AlternativeItem(&quot;LineTotal&quot;))" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="40" CanShrink="true" Location="1736.220458984375;11.811023712158203" Text="Price" TextAlign="TopRight" GrowToBottom="true" Name="textBox138" Size="224.40945434570313;47.244094848632812"><TextFill type="PerpetuumSoft.Framework.Drawing.SolidFill" id="41" Color="DimGray" /><Font type="PerpetuumSoft.Framework.Drawing.FontDescriptor" id="42" FamilyName="Arial" Size="9" Underline="Off" Italic="On" Bold="Off" /><TextFormat type="PerpetuumSoft.Framework.Text.TextFormat" id="43" UseCultureSettings="false" GroupSeparator="" FormatStyle="Number" UseGroupSeparator="false" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="44"><Item type="PerpetuumSoft.Reporting.DOM.ReportDataBinding" id="45" Expression="AlternativeItem(&quot;Price&quot;)" PropertyName="Value" /></DataBindings></Item><Item type="PerpetuumSoft.Reporting.DOM.TextBox" id="46" CanShrink="true" Location="295.27560424804688;47.244094848632812" CanGrow="true" GrowToBottom="true" Name="textBox139" Size="2066.92919921875;11.811023712158203"><Border type="PerpetuumSoft.Framework.Drawing.Border" id="47" BottomLine="0.5 Solid Gray" /><DataBindings type="PerpetuumSoft.Reporting.DOM.ReportDataBindingCollection" id="48" /></Item></Controls><Aggregates type="PerpetuumSoft.Reporting.DOM.AggregateCollection" id="49"><Item type="PerpetuumSoft.Reporting.DOM.Aggregate" id="50" Running="true" Name="RunningSum" Expression="iif(isFC,DocumentRow(&quot;TotalFrgn&quot;),DocumentRow(&quot;LineTotal&quot;))"><Groups type="PerpetuumSoft.Reporting.DOM.AggregateGroupCollection" id="51" /></Item><Item type="PerpetuumSoft.Reporting.DOM.Aggregate" id="52" Name="PageSum" Expression="iif(isFC,DocumentRow(&quot;TotalFrgn&quot;),DocumentRow(&quot;LineTotal&quot;))"><Groups type="PerpetuumSoft.Reporting.DOM.AggregateGroupCollection" id="53" /></Item></Aggregates></Item></Controls><Aggregates type="PerpetuumSoft.Reporting.DOM.AggregateCollection" id="54" /></Item></Controls></root>

Daniel Ebi

Hallo Philipp,

vielen Dank für die schnelle supertolle Hilfe. Funktioniert einwandfrei. Naja, es fehlte bei mir leider ne Kleinigkeit, jetzt weiß ich aber was es war.

Nochmals Danke.

Schöne Grüsse

Daniel