<config><ViewMode>11</ViewMode><DataMode>8</DataMode><CheckpointId>0</CheckpointId><ShowAllBonierungen>False</ShowAllBonierungen><ShowAufwandBonierungen>False</ShowAufwandBonierungen><ShowExternalReceipts>False</ShowExternalReceipts><ShowNormalAndExternalReceipts>False</ShowNormalAndExternalReceipts><ArrangeByAufwandArea>False</ArrangeByAufwandArea><ShowStorno>False</ShowStorno><ArrangeByPayment>False</ArrangeByPayment><ArticleArrangeByWaiter>False</ArticleArrangeByWaiter><ArticleArrangeByTableArea>False</ArticleArrangeByTableArea><JournalShowBoniert>False</JournalShowBoniert><FromDate>637918848000000000</FromDate><ToDate>637919711990000000</ToDate><ArrangeByEP>False</ArrangeByEP><GroupSameDate>True</GroupSameDate><TimeSalesAverage>False</TimeSalesAverage><LockToWaiter>False</LockToWaiter></config> Umsatz <?xml version="1.0"?><Reports><!--Report *** Gesamtumsatz ***--><Report version="2.5.20073.258"><Name>Gesamtumsatz</Name><ReportInfo><Author>andi</Author></ReportInfo><DataSource><ConnectionString>C:\Users\reite\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_artikelgruppen_kassiert</RecordSource></DataSource><Layout><Width>4125</Width><Orientation>1</Orientation></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups /><Sections><Section><Name>Detail</Name><Type>0</Type><Height>440</Height><Visible>0</Visible></Section><Section><Name>Header</Name><Type>1</Type><Height>5</Height></Section><Section><Name>Footer</Name><Type>2</Type><Height>435</Height></Section><Section><Name>PageHeader</Name><Type>3</Type></Section><Section><Name>PageFooter</Name><Type>4</Type><Height>5</Height></Section></Sections><Fields><Field><Name>Field1</Name><Section>2</Section><Text>SUM(summe)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>2040</Left><Top>75</Top><Width>2010</Width><Height>360</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>14.25</Size></Font></Field><Field><Name>Field2</Name><Section>2</Section><Text>Umsatz GESAMT</Text><Left>75</Left><Top>75</Top><Width>2505</Width><Height>360</Height><Align>0</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>14.25</Size></Font></Field></Fields></Report><!--Report *** Kellnerumsatz ohne TIP ***--><Report version="2.5.20073.258"><Name>Kellnerumsatz ohne TIP</Name><ReportInfo><Author>andi</Author></ReportInfo><DataSource><ConnectionString>C:\Users\reite\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_journal</RecordSource><Filter>is_tip = 0 AND tisch_bondetail_istUmsatz=1</Filter></DataSource><Layout><Width>4260</Width><Orientation>1</Orientation></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups><Group><Name>kellner_kurzName</Name><GroupBy>kellner_kurzName</GroupBy><Sort>1</Sort></Group><Group><Name>zahlungsart_bezeichnung</Name><GroupBy>zahlungsart_bezeichnung</GroupBy><Sort>1</Sort></Group></Groups><Sections><Section><Name>Detail</Name><Type>0</Type><Visible>0</Visible></Section><Section><Name>Header</Name><Type>1</Type></Section><Section><Name>Footer</Name><Type>2</Type><Visible>0</Visible></Section><Section><Name>PageHeader</Name><Type>3</Type></Section><Section><Name>PageFooter</Name><Type>4</Type></Section><Section><Name>kellner_kurzName_Header</Name><Type>5</Type><Height>450</Height></Section><Section><Name>kellner_kurzName_Footer</Name><Type>6</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Header</Name><Type>7</Type></Section><Section><Name>zahlungsart_bezeichnung_Footer</Name><Type>8</Type><Height>285</Height></Section></Sections><Fields><Field><Name>Field1</Name><Section>5</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1860</Left><Width>2340</Width><Height>345</Height><Align>2</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field2</Name><Section>5</Section><Text>kellner_kurzName</Text><Calculated>-1</Calculated><Left>150</Left><Width>2235</Width><Height>345</Height><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field3</Name><Section>5</Section><Text>(exklusive TIP)</Text><Calculated>-1</Calculated><Left>150</Left><Top>240</Top><Width>1815</Width><Height>210</Height><Font><Name>Tahoma</Name><Size>8.25</Size></Font></Field><Field><Name>Field4</Name><Section>8</Section><Text>zahlungsart_bezeichnung</Text><Calculated>-1</Calculated><Left>1110</Left><Width>1890</Width><Height>285</Height><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field5</Name><Section>8</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>2820</Left><Width>1320</Width><Height>285</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field></Fields></Report><!--Report *** Report ***--><Report version="2.5.20073.258"><Name>Report</Name><ReportInfo /><DataSource><ConnectionString>C:\Users\reite\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_journal</RecordSource><Filter>tisch_bondetail_istUmsatz=1</Filter></DataSource><Layout><Width>4335</Width><MarginLeft>0</MarginLeft><MarginTop>0</MarginTop><MarginRight>0</MarginRight><MarginBottom>0</MarginBottom><Orientation>1</Orientation><PaperSize>9</PaperSize></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups><Group><Name>kellner_kurzName</Name><GroupBy>kellner_kurzName</GroupBy><Sort>1</Sort></Group><Group><Name>warengruppe</Name><GroupBy>warengruppe</GroupBy><Sort>1</Sort></Group><Group><Name>zahlungsart_bezeichnung</Name><GroupBy>zahlungsart_bezeichnung</GroupBy><Sort>1</Sort></Group></Groups><Sections><Section><Name>Detail</Name><Type>0</Type><CanShrink>-1</CanShrink></Section><Section><Name>Header</Name><Type>1</Type><Height>2400</Height></Section><Section><Name>Footer</Name><Type>2</Type><Height>2295</Height></Section><Section><Name>PageHeader</Name><Type>3</Type><Height>1950</Height></Section><Section><Name>PageFooter</Name><Type>4</Type></Section><Section><Name>kellner_kurzName_Header</Name><Type>5</Type><Height>1650</Height></Section><Section><Name>kellner_kurzName_Footer</Name><Type>6</Type></Section><Section><Name>warengruppe_Header</Name><Type>7</Type><Height>375</Height><Visible>0</Visible></Section><Section><Name>warengruppe_Footer</Name><Type>8</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Header</Name><Type>9</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Footer</Name><Type>10</Type></Section></Sections><Fields><Field><Name>Logo</Name><Section>1</Section><Width>4110</Width><Height>1935</Height><Picture encoding="base64"></Picture><PictureAlign>7</PictureAlign><PictureScale>2</PictureScale></Field><Field><Name>company</Name><Section>3</Section><Text></Text><Calculated>-1</Calculated><Width>4125</Width><Height>285</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field><Field><Name>titleLbl1</Name><Section>3</Section><Text>{[checkpointNum]}</Text><Top>225</Top><Width>4125</Width><Height>390</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>15.75</Size></Font></Field><Field><Name>Field10</Name><Section>3</Section><Text>TIP Aufstellung</Text><Calculated>-1</Calculated><Top>1095</Top><Width>4125</Width><Height>270</Height><Align>7</Align><BackColor>0</BackColor><BackStyle>1</BackStyle><ForeColor>16777215</ForeColor><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field><Field><Name>company2</Name><Section>3</Section><Text>"Seite " &amp; [Page] &amp; " von " &amp; [Pages]</Text><Calculated>-1</Calculated><Top>1665</Top><Width>4125</Width><Height>285</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field><Field><Name>Field12</Name><Section>2</Section><Text>ausgedruckt von:</Text><Calculated>-1</Calculated><Left>120</Left><Top>1395</Top><Width>1695</Width><Height>285</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field13</Name><Section>2</Section><Text>ausgedruckt um:</Text><Calculated>-1</Calculated><Left>120</Left><Top>1575</Top><Width>1695</Width><Height>285</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field14</Name><Section>2</Section><Text>ausgedruckt am:</Text><Calculated>-1</Calculated><Left>120</Left><Top>1815</Top><Width>1695</Width><Height>210</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field15</Name><Section>2</Section><Text>{[name]}</Text><Calculated>-1</Calculated><Left>1830</Left><Top>1395</Top><Width>2280</Width><Height>285</Height><Align>8</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field16</Name><Section>2</Section><Text>Format(Now, "long time")</Text><Calculated>-1</Calculated><Left>1830</Left><Top>1575</Top><Width>2280</Width><Height>285</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field17</Name><Section>2</Section><Text>Format(Now, "long date")</Text><Calculated>-1</Calculated><Left>1830</Left><Top>1815</Top><Width>2280</Width><Height>210</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field2</Name><Section>2</Section><Left>105</Left><Top>30</Top><Width>4230</Width><Height>15</Height><BackColor>0</BackColor><BackStyle>1</BackStyle><BorderStyle>1</BorderStyle></Field><Field><Name>Field4</Name><Section>5</Section><Top>60</Top><Width>4230</Width><Height>15</Height><BackColor>0</BackColor><BackStyle>1</BackStyle><BorderStyle>1</BorderStyle></Field><Field><Name>Field9</Name><Section>7</Section><Text>warengruppe</Text><Calculated>-1</Calculated><Left>180</Left><Top>30</Top><Width>2235</Width><Height>345</Height><Font><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field11</Name><Section>7</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1890</Left><Top>30</Top><Width>2235</Width><Height>345</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field1</Name><Section>5</Section><Text>"kellner_kurzName = '" &amp; kellner_kurzName &amp;"'"</Text><Left>150</Left><Top>930</Top><Width>4095</Width><Height>105</Height><CanGrow>-1</CanGrow><Subreport>TIP</Subreport></Field><Field><Name>Field3</Name><Section>5</Section><Text>"kellner_kurzName = '" &amp; kellner_kurzName &amp; "'"</Text><Left>75</Left><Top>180</Top><Width>4230</Width><Height>510</Height><CanGrow>-1</CanGrow><Subreport>Kellnerumsatz ohne TIP</Subreport></Field><Field><Name>Field5</Name><Section>5</Section><Text>(inklusive TIP)</Text><Calculated>-1</Calculated><Left>225</Left><Top>1440</Top><Width>1815</Width><Height>210</Height><Font><Name>Tahoma</Name><Size>8.25</Size></Font></Field><Field><Name>Field6</Name><Section>5</Section><Text>kellner_kurzName &amp; " - Gesamt"</Text><Calculated>-1</Calculated><Left>225</Left><Top>1200</Top><Width>2610</Width><Height>345</Height><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field18</Name><Section>5</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1935</Left><Top>1200</Top><Width>2340</Width><Height>345</Height><Align>2</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field19</Name><Section>2</Section><Left>90</Left><Top>180</Top><Width>4155</Width><Height>615</Height><CanGrow>-1</CanGrow><Subreport>Gesamtumsatz</Subreport></Field><Field><Name>titleLbl2</Name><Section>3</Section><Text>{[dateFrom]} - {[dateTo]}</Text><Left>15</Left><Top>615</Top><Width>4125</Width><Height>390</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>15.75</Size></Font></Field><Field><Name>logotext</Name><Section>1</Section><Text></Text><Top>2115</Top><Width>4125</Width><Height>285</Height><Align>7</Align><CanGrow>-1</CanGrow><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field></Fields></Report><!--Report *** TIP ***--><Report version="2.5.20073.258"><Name>TIP</Name><ReportInfo><Author>andi</Author></ReportInfo><DataSource><ConnectionString>C:\Users\reite\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_journal</RecordSource><Filter>is_tip = '1' AND tisch_bondetail_istUmsatz=1</Filter></DataSource><Layout><Width>4320</Width><Orientation>1</Orientation></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups><Group><Name>kellner_kurzName</Name><GroupBy>kellner_kurzName</GroupBy><Sort>1</Sort></Group><Group><Name>zahlungsart_bezeichnung</Name><GroupBy>zahlungsart_bezeichnung</GroupBy><Sort>1</Sort><KeepTogether>1</KeepTogether></Group></Groups><Sections><Section><Name>Detail</Name><Type>0</Type></Section><Section><Name>Header</Name><Type>1</Type></Section><Section><Name>Footer</Name><Type>2</Type></Section><Section><Name>PageHeader</Name><Type>3</Type></Section><Section><Name>PageFooter</Name><Type>4</Type><Height>5</Height></Section><Section><Name>kellner_kurzName_Header</Name><Type>5</Type><Height>345</Height></Section><Section><Name>kellner_kurzName_Footer</Name><Type>6</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Header</Name><Type>7</Type><Height>285</Height></Section><Section><Name>zahlungsart_bezeichnung_Footer</Name><Type>8</Type></Section></Sections><Fields><Field><Name>Field1</Name><Section>7</Section><Text>"TIP - " &amp; zahlungsart_bezeichnung</Text><Calculated>-1</Calculated><Left>915</Left><Width>2205</Width><Height>285</Height><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field2</Name><Section>7</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>2325</Left><Width>1725</Width><Height>285</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field3</Name><Section>5</Section><Text>kellner_kurzName &amp; " - TIP"</Text><Calculated>-1</Calculated><Left>120</Left><Width>2250</Width><Height>345</Height><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field4</Name><Section>5</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1845</Left><Width>2235</Width><Height>345</Height><Align>2</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>11.25</Size></Font></Field></Fields></Report></Reports> True DateSelection TIP-ZEITSPANNE <ScriptDocument><MainCode>DataSet ds = GetData(); var data = ds.Tables["umsatz_journal"]; var dt = new DataTable("preview"); dt.Columns.Add("Kellner", typeof(String)); dt.Columns.Add("Warengruppe", typeof(String)); dt.Columns.Add("Zahlungsart", typeof(String)); dt.Columns.Add("Summe", typeof(decimal)); System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;&gt;&gt; sums = new System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;string, decimal&gt;&gt;&gt;(); System.Collections.Generic.Dictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;&gt; tipForWaiter = new System.Collections.Generic.Dictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;&gt;(); foreach(DataRow previewRow in data.Rows){ if((bool)previewRow["tisch_bondetail_istUmsatz"] == false) continue; string kellner = (string)previewRow["kellner_kurzName"]; string warengruppe = (string)previewRow["warengruppe"]; string zahlungsart = (string)previewRow["zahlungsart_bezeichnung"]; bool isTip = (int)previewRow["is_tip"] != 0; decimal sum = (decimal)previewRow["tisch_bondetail_preis"] * (decimal)(int)previewRow["tisch_bondetail_absmenge"]; if(isTip){ if(!tipForWaiter.ContainsKey(kellner)) tipForWaiter.Add(kellner, new System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;()); if(!tipForWaiter[kellner].ContainsKey(zahlungsart)){ tipForWaiter[kellner].Add(zahlungsart, sum); } else{ tipForWaiter[kellner][zahlungsart] = tipForWaiter[kellner][zahlungsart] + sum; } } else { if(!sums.ContainsKey(kellner)) sums.Add(kellner, new System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;string, decimal&gt;&gt;()); if(!sums[kellner].ContainsKey(warengruppe)) sums[kellner].Add(warengruppe, new System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;()); if(!sums[kellner][warengruppe].ContainsKey(zahlungsart)) sums[kellner][warengruppe].Add(zahlungsart, sum); else sums[kellner][warengruppe][zahlungsart] = sums[kellner][warengruppe][zahlungsart] + sum; } } foreach(String kellner in sums.Keys){ foreach(String warengruppe in sums[kellner].Keys){ foreach(String zahlungsart in sums[kellner][warengruppe].Keys){ var dr = dt.NewRow(); dr["Kellner"] = kellner; dr["Warengruppe"] = warengruppe; dr["Zahlungsart"] = zahlungsart; dr["Summe"] = sums[kellner][warengruppe][zahlungsart]; dt.Rows.Add(dr); } } if(tipForWaiter.ContainsKey(kellner)){ foreach(string zahlungsart in tipForWaiter[kellner].Keys){ var dr = dt.NewRow(); dr["Kellner"] = kellner; dr["Warengruppe"] = "TIP"; dr["Zahlungsart"] = zahlungsart; dr["Summe"] = tipForWaiter[kellner][zahlungsart]; dt.Rows.Add(dr); } } } var dataTables = new System.Collections.Generic.List&lt;DataTable&gt;(); foreach(DataTable d in ds.Tables){ dataTables.Add(d); } ds.Tables.Clear(); ds.Tables.Add(dt); foreach(var d in dataTables){ ds.Tables.Add(d); } </MainCode></ScriptDocument> Wiffzack.Query.Visualisation.UmsatzRequestVisualizer 17 58 Kellner 87 Warengruppe 89 Zahlungsart 50 Summe <config><ViewMode>11</ViewMode><DataMode>4</DataMode><CheckpointId>0</CheckpointId><ShowAllBonierungen>False</ShowAllBonierungen><ShowAufwandBonierungen>False</ShowAufwandBonierungen><ShowExternalReceipts>False</ShowExternalReceipts><ShowNormalAndExternalReceipts>False</ShowNormalAndExternalReceipts><ArrangeByAufwandArea>False</ArrangeByAufwandArea><ShowStorno>False</ShowStorno><ArrangeByPayment>False</ArrangeByPayment><ArticleArrangeByWaiter>False</ArticleArrangeByWaiter><ArticleArrangeByTableArea>False</ArticleArrangeByTableArea><JournalShowBoniert>False</JournalShowBoniert><FromDate>637906752000000000</FromDate><ToDate>637910207990000000</ToDate><ArrangeByEP>False</ArrangeByEP><GroupSameDate>True</GroupSameDate><TimeSalesAverage>False</TimeSalesAverage><LockToWaiter>False</LockToWaiter></config> Umsatz <?xml version="1.0"?><Reports><!--Report *** Gesamtumsatz ***--><Report version="2.5.20073.258"><Name>Gesamtumsatz</Name><ReportInfo><Author>andi</Author></ReportInfo><DataSource><ConnectionString>C:\Users\reite\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_artikelgruppen_kassiert</RecordSource></DataSource><Layout><Width>4125</Width><Orientation>1</Orientation></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups /><Sections><Section><Name>Detail</Name><Type>0</Type><Height>35</Height><Visible>0</Visible></Section><Section><Name>Header</Name><Type>1</Type><Height>5</Height></Section><Section><Name>Footer</Name><Type>2</Type><Height>435</Height></Section><Section><Name>PageHeader</Name><Type>3</Type></Section><Section><Name>PageFooter</Name><Type>4</Type><Height>5</Height></Section></Sections><Fields><Field><Name>Field1</Name><Section>2</Section><Text>SUM(summe)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>2040</Left><Top>75</Top><Width>2010</Width><Height>360</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>14.25</Size></Font></Field><Field><Name>Field2</Name><Section>2</Section><Text>Umsatz GESAMT</Text><Left>75</Left><Top>75</Top><Width>2505</Width><Height>360</Height><Align>0</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>14.25</Size></Font></Field></Fields></Report><!--Report *** Kellnerumsatz ohne TIP ***--><Report version="2.5.20073.258"><Name>Kellnerumsatz ohne TIP</Name><ReportInfo><Author>andi</Author></ReportInfo><DataSource><ConnectionString>C:\Users\reite\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_journal</RecordSource><Filter>is_tip = 0 AND tisch_bondetail_istUmsatz=1</Filter></DataSource><Layout><Width>4260</Width><Orientation>1</Orientation></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups><Group><Name>kellner_kurzName</Name><GroupBy>kellner_kurzName</GroupBy><Sort>1</Sort></Group><Group><Name>zahlungsart_bezeichnung</Name><GroupBy>zahlungsart_bezeichnung</GroupBy><Sort>1</Sort></Group></Groups><Sections><Section><Name>Detail</Name><Type>0</Type><Visible>0</Visible></Section><Section><Name>Header</Name><Type>1</Type></Section><Section><Name>Footer</Name><Type>2</Type><Visible>0</Visible></Section><Section><Name>PageHeader</Name><Type>3</Type></Section><Section><Name>PageFooter</Name><Type>4</Type></Section><Section><Name>kellner_kurzName_Header</Name><Type>5</Type><Height>450</Height></Section><Section><Name>kellner_kurzName_Footer</Name><Type>6</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Header</Name><Type>7</Type></Section><Section><Name>zahlungsart_bezeichnung_Footer</Name><Type>8</Type><Height>285</Height></Section></Sections><Fields><Field><Name>Field1</Name><Section>5</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1860</Left><Width>2340</Width><Height>345</Height><Align>2</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field2</Name><Section>5</Section><Text>kellner_kurzName</Text><Calculated>-1</Calculated><Left>150</Left><Width>2235</Width><Height>345</Height><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field3</Name><Section>5</Section><Text>(exklusive TIP)</Text><Calculated>-1</Calculated><Left>150</Left><Top>240</Top><Width>1815</Width><Height>210</Height><Font><Name>Tahoma</Name><Size>8.25</Size></Font></Field><Field><Name>Field4</Name><Section>8</Section><Text>zahlungsart_bezeichnung</Text><Calculated>-1</Calculated><Left>1110</Left><Width>1890</Width><Height>285</Height><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field5</Name><Section>8</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>2820</Left><Width>1320</Width><Height>285</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field></Fields></Report><!--Report *** Report ***--><Report version="2.5.20073.258"><Name>Report</Name><ReportInfo /><DataSource><ConnectionString>C:\Users\reite\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_journal</RecordSource><Filter>tisch_bondetail_istUmsatz=1</Filter></DataSource><Layout><Width>4335</Width><MarginLeft>0</MarginLeft><MarginTop>0</MarginTop><MarginRight>0</MarginRight><MarginBottom>0</MarginBottom><Orientation>1</Orientation><PaperSize>9</PaperSize></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups><Group><Name>kellner_kurzName</Name><GroupBy>kellner_kurzName</GroupBy><Sort>1</Sort></Group><Group><Name>warengruppe</Name><GroupBy>warengruppe</GroupBy><Sort>1</Sort></Group><Group><Name>zahlungsart_bezeichnung</Name><GroupBy>zahlungsart_bezeichnung</GroupBy><Sort>1</Sort></Group></Groups><Sections><Section><Name>Detail</Name><Type>0</Type><CanShrink>-1</CanShrink></Section><Section><Name>Header</Name><Type>1</Type><Height>2400</Height></Section><Section><Name>Footer</Name><Type>2</Type><Height>2295</Height></Section><Section><Name>PageHeader</Name><Type>3</Type><Height>1755</Height></Section><Section><Name>PageFooter</Name><Type>4</Type></Section><Section><Name>kellner_kurzName_Header</Name><Type>5</Type><Height>1575</Height></Section><Section><Name>kellner_kurzName_Footer</Name><Type>6</Type></Section><Section><Name>warengruppe_Header</Name><Type>7</Type><Height>375</Height><Visible>0</Visible></Section><Section><Name>warengruppe_Footer</Name><Type>8</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Header</Name><Type>9</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Footer</Name><Type>10</Type></Section></Sections><Fields><Field><Name>company</Name><Section>3</Section><Text></Text><Calculated>-1</Calculated><Width>4125</Width><Height>285</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field><Field><Name>titleLbl1</Name><Section>3</Section><Top>225</Top><Width>4125</Width><Height>390</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>15.75</Size></Font></Field><Field><Name>Field10</Name><Section>3</Section><Text>TIP Aufstellung</Text><Calculated>-1</Calculated><Left>75</Left><Top>1155</Top><Width>4125</Width><Height>270</Height><Align>7</Align><BackColor>0</BackColor><BackStyle>1</BackStyle><ForeColor>16777215</ForeColor><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field><Field><Name>company2</Name><Section>3</Section><Text>"Seite " &amp; [Page] &amp; " von " &amp; [Pages]</Text><Calculated>-1</Calculated><Top>1440</Top><Width>4125</Width><Height>285</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field><Field><Name>Field12</Name><Section>2</Section><Text>ausgedruckt von:</Text><Calculated>-1</Calculated><Left>120</Left><Top>1395</Top><Width>1695</Width><Height>285</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field13</Name><Section>2</Section><Text>ausgedruckt um:</Text><Calculated>-1</Calculated><Left>120</Left><Top>1575</Top><Width>1695</Width><Height>285</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field14</Name><Section>2</Section><Text>ausgedruckt am:</Text><Calculated>-1</Calculated><Left>120</Left><Top>1815</Top><Width>1695</Width><Height>210</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field15</Name><Section>2</Section><Text>{[name]}</Text><Calculated>-1</Calculated><Left>1830</Left><Top>1395</Top><Width>2280</Width><Height>285</Height><Align>8</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field16</Name><Section>2</Section><Text>Format(Now, "long time")</Text><Calculated>-1</Calculated><Left>1830</Left><Top>1575</Top><Width>2280</Width><Height>285</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field17</Name><Section>2</Section><Text>Format(Now, "long date")</Text><Calculated>-1</Calculated><Left>1830</Left><Top>1815</Top><Width>2280</Width><Height>210</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field2</Name><Section>2</Section><Left>105</Left><Top>30</Top><Width>4230</Width><Height>15</Height><BackColor>0</BackColor><BackStyle>1</BackStyle><BorderStyle>1</BorderStyle></Field><Field><Name>Field4</Name><Section>5</Section><Top>60</Top><Width>4230</Width><Height>15</Height><BackColor>0</BackColor><BackStyle>1</BackStyle><BorderStyle>1</BorderStyle></Field><Field><Name>Field9</Name><Section>7</Section><Text>warengruppe</Text><Calculated>-1</Calculated><Left>180</Left><Top>30</Top><Width>2235</Width><Height>345</Height><Font><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field11</Name><Section>7</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1890</Left><Top>30</Top><Width>2235</Width><Height>345</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field1</Name><Section>5</Section><Text>"kellner_kurzName = '" &amp; kellner_kurzName &amp;"'"</Text><Left>150</Left><Top>930</Top><Width>4095</Width><Height>105</Height><CanGrow>-1</CanGrow><CanShrink>-1</CanShrink><Subreport>TIP</Subreport></Field><Field><Name>Field3</Name><Section>5</Section><Text>"kellner_kurzName = '" &amp; kellner_kurzName &amp; "'"</Text><Left>75</Left><Top>180</Top><Width>4230</Width><Height>510</Height><CanGrow>-1</CanGrow><Subreport>Kellnerumsatz ohne TIP</Subreport></Field><Field><Name>Field5</Name><Section>5</Section><Text>(inklusive TIP)</Text><Calculated>-1</Calculated><Left>225</Left><Top>1365</Top><Width>1815</Width><Height>210</Height><Font><Name>Tahoma</Name><Size>8.25</Size></Font></Field><Field><Name>Field6</Name><Section>5</Section><Text>kellner_kurzName &amp; " - Gesamt"</Text><Calculated>-1</Calculated><Left>225</Left><Top>1125</Top><Width>2715</Width><Height>345</Height><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field18</Name><Section>5</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1935</Left><Top>1125</Top><Width>2340</Width><Height>345</Height><Align>2</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field19</Name><Section>2</Section><Left>90</Left><Top>180</Top><Width>4155</Width><Height>615</Height><CanGrow>-1</CanGrow><Subreport>Gesamtumsatz</Subreport></Field><Field><Name>titleLbl2</Name><Section>3</Section><Text>Format(Now, "short date") &amp; " " &amp; Format(now, "short time")</Text><Calculated>-1</Calculated><Left>75</Left><Top>645</Top><Width>4125</Width><Height>390</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>15.75</Size></Font></Field><Field><Name>Logo</Name><Section>1</Section><Width>4110</Width><Height>1935</Height><Picture encoding="base64"></Picture><PictureAlign>7</PictureAlign><PictureScale>2</PictureScale></Field><Field><Name>logotext</Name><Section>1</Section><Text></Text><Top>2115</Top><Width>4125</Width><Height>285</Height><Align>7</Align><CanGrow>-1</CanGrow><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field></Fields></Report><!--Report *** TIP ***--><Report version="2.5.20073.258"><Name>TIP</Name><ReportInfo><Author>andi</Author></ReportInfo><DataSource><ConnectionString>C:\Users\reite\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_journal</RecordSource><Filter>is_tip = '1' AND tisch_bondetail_istUmsatz=1</Filter></DataSource><Layout><Width>4320</Width><Orientation>1</Orientation></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups><Group><Name>kellner_kurzName</Name><GroupBy>kellner_kurzName</GroupBy><Sort>1</Sort></Group><Group><Name>zahlungsart_bezeichnung</Name><GroupBy>zahlungsart_bezeichnung</GroupBy><Sort>1</Sort><KeepTogether>1</KeepTogether></Group></Groups><Sections><Section><Name>Detail</Name><Type>0</Type></Section><Section><Name>Header</Name><Type>1</Type></Section><Section><Name>Footer</Name><Type>2</Type></Section><Section><Name>PageHeader</Name><Type>3</Type></Section><Section><Name>PageFooter</Name><Type>4</Type><Height>5</Height></Section><Section><Name>kellner_kurzName_Header</Name><Type>5</Type><Height>345</Height></Section><Section><Name>kellner_kurzName_Footer</Name><Type>6</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Header</Name><Type>7</Type><Height>285</Height></Section><Section><Name>zahlungsart_bezeichnung_Footer</Name><Type>8</Type></Section></Sections><Fields><Field><Name>Field1</Name><Section>7</Section><Text>"TIP - " &amp; zahlungsart_bezeichnung</Text><Calculated>-1</Calculated><Left>915</Left><Width>2205</Width><Height>285</Height><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field2</Name><Section>7</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>2325</Left><Width>1725</Width><Height>285</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field3</Name><Section>5</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1845</Left><Width>2235</Width><Height>345</Height><Align>2</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field4</Name><Section>5</Section><Text>kellner_kurzName &amp; " - TIP"</Text><Calculated>-1</Calculated><Left>120</Left><Width>2250</Width><Height>345</Height><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>11.25</Size></Font></Field></Fields></Report></Reports> True Default TIP-HEUTE <ScriptDocument><MainCode>DataSet ds = GetData(); var data = ds.Tables["umsatz_journal"]; var dt = new DataTable("preview"); dt.Columns.Add("Kellner", typeof(String)); dt.Columns.Add("Warengruppe", typeof(String)); dt.Columns.Add("Zahlungsart", typeof(String)); dt.Columns.Add("Summe", typeof(decimal)); System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;&gt;&gt; sums = new System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;string, decimal&gt;&gt;&gt;(); System.Collections.Generic.Dictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;&gt; tipForWaiter = new System.Collections.Generic.Dictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;&gt;(); foreach(DataRow previewRow in data.Rows){ if((bool)previewRow["tisch_bondetail_istUmsatz"] == false) continue; string kellner = (string)previewRow["kellner_kurzName"]; string warengruppe = (string)previewRow["warengruppe"]; string zahlungsart = (string)previewRow["zahlungsart_bezeichnung"]; bool isTip = (int)previewRow["is_tip"] != 0; decimal sum = (decimal)previewRow["tisch_bondetail_preis"] * (decimal)(int)previewRow["tisch_bondetail_absmenge"]; if(isTip){ if(!tipForWaiter.ContainsKey(kellner)) tipForWaiter.Add(kellner, new System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;()); if(!tipForWaiter[kellner].ContainsKey(zahlungsart)){ tipForWaiter[kellner].Add(zahlungsart, sum); } else{ tipForWaiter[kellner][zahlungsart] = tipForWaiter[kellner][zahlungsart] + sum; } } else { if(!sums.ContainsKey(kellner)) sums.Add(kellner, new System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;string, decimal&gt;&gt;()); if(!sums[kellner].ContainsKey(warengruppe)) sums[kellner].Add(warengruppe, new System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;()); if(!sums[kellner][warengruppe].ContainsKey(zahlungsart)) sums[kellner][warengruppe].Add(zahlungsart, sum); else sums[kellner][warengruppe][zahlungsart] = sums[kellner][warengruppe][zahlungsart] + sum; } } foreach(String kellner in sums.Keys){ foreach(String warengruppe in sums[kellner].Keys){ foreach(String zahlungsart in sums[kellner][warengruppe].Keys){ var dr = dt.NewRow(); dr["Kellner"] = kellner; dr["Warengruppe"] = warengruppe; dr["Zahlungsart"] = zahlungsart; dr["Summe"] = sums[kellner][warengruppe][zahlungsart]; dt.Rows.Add(dr); } } if(tipForWaiter.ContainsKey(kellner)){ foreach(string zahlungsart in tipForWaiter[kellner].Keys){ var dr = dt.NewRow(); dr["Kellner"] = kellner; dr["Warengruppe"] = "TIP"; dr["Zahlungsart"] = zahlungsart; dr["Summe"] = tipForWaiter[kellner][zahlungsart]; dt.Rows.Add(dr); } } } var dataTables = new System.Collections.Generic.List&lt;DataTable&gt;(); foreach(DataTable d in ds.Tables){ dataTables.Add(d); } ds.Tables.Clear(); ds.Tables.Add(dt); foreach(var d in dataTables){ ds.Tables.Add(d); } </MainCode></ScriptDocument> Wiffzack.Query.Visualisation.UmsatzRequestVisualizer 17 78 Kellner 106 Warengruppe 139 Zahlungsart 50 Summe <config><ViewMode>11</ViewMode><DataMode>1</DataMode><CheckpointId>4787</CheckpointId><ShowAllBonierungen>False</ShowAllBonierungen><ShowAufwandBonierungen>False</ShowAufwandBonierungen><ShowExternalReceipts>False</ShowExternalReceipts><ShowNormalAndExternalReceipts>False</ShowNormalAndExternalReceipts><ArrangeByAufwandArea>False</ArrangeByAufwandArea><ShowStorno>False</ShowStorno><ArrangeByPayment>False</ArrangeByPayment><ArticleArrangeByWaiter>False</ArticleArrangeByWaiter><ArticleArrangeByTableArea>False</ArticleArrangeByTableArea><JournalShowBoniert>False</JournalShowBoniert><FromDate>637921440000000000</FromDate><ToDate>637922303990000000</ToDate><ArrangeByEP>False</ArrangeByEP><GroupSameDate>True</GroupSameDate><TimeSalesAverage>False</TimeSalesAverage><LockToWaiter>False</LockToWaiter></config> Umsatz <?xml version="1.0"?><Reports><!--Report *** Gesamtumsatz ***--><Report version="2.5.20073.258"><Name>Gesamtumsatz</Name><ReportInfo><Author>andi</Author></ReportInfo><DataSource><ConnectionString>C:\Users\KASSE\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_artikelgruppen_kassiert</RecordSource></DataSource><Layout><Width>4125</Width><Orientation>1</Orientation></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups /><Sections><Section><Name>Detail</Name><Type>0</Type><Height>440</Height><Visible>0</Visible></Section><Section><Name>Header</Name><Type>1</Type><Height>5</Height></Section><Section><Name>Footer</Name><Type>2</Type><Height>435</Height></Section><Section><Name>PageHeader</Name><Type>3</Type></Section><Section><Name>PageFooter</Name><Type>4</Type><Height>5</Height></Section></Sections><Fields><Field><Name>Field1</Name><Section>2</Section><Text>SUM(summe)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>2040</Left><Top>75</Top><Width>2010</Width><Height>360</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>14.25</Size></Font></Field><Field><Name>Field2</Name><Section>2</Section><Text>Umsatz GESAMT</Text><Left>75</Left><Top>75</Top><Width>2505</Width><Height>360</Height><Align>0</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>14.25</Size></Font></Field></Fields></Report><!--Report *** Kellnerumsatz ohne TIP ***--><Report version="2.5.20073.258"><Name>Kellnerumsatz ohne TIP</Name><ReportInfo><Author>andi</Author></ReportInfo><DataSource><ConnectionString>C:\Users\KASSE\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_journal</RecordSource><Filter>is_tip = 0 AND tisch_bondetail_istUmsatz=1</Filter></DataSource><Layout><Width>4260</Width><Orientation>1</Orientation></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups><Group><Name>kellner_kurzName</Name><GroupBy>kellner_kurzName</GroupBy><Sort>1</Sort></Group><Group><Name>zahlungsart_bezeichnung</Name><GroupBy>zahlungsart_bezeichnung</GroupBy><Sort>1</Sort></Group></Groups><Sections><Section><Name>Detail</Name><Type>0</Type><Visible>0</Visible></Section><Section><Name>Header</Name><Type>1</Type></Section><Section><Name>Footer</Name><Type>2</Type><Visible>0</Visible></Section><Section><Name>PageHeader</Name><Type>3</Type></Section><Section><Name>PageFooter</Name><Type>4</Type></Section><Section><Name>kellner_kurzName_Header</Name><Type>5</Type><Height>450</Height></Section><Section><Name>kellner_kurzName_Footer</Name><Type>6</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Header</Name><Type>7</Type></Section><Section><Name>zahlungsart_bezeichnung_Footer</Name><Type>8</Type><Height>285</Height></Section></Sections><Fields><Field><Name>Field1</Name><Section>5</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1860</Left><Width>2340</Width><Height>345</Height><Align>2</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field2</Name><Section>5</Section><Text>kellner_kurzName</Text><Calculated>-1</Calculated><Left>150</Left><Width>2235</Width><Height>345</Height><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field3</Name><Section>5</Section><Text>(exklusive TIP)</Text><Calculated>-1</Calculated><Left>150</Left><Top>240</Top><Width>1815</Width><Height>210</Height><Font><Name>Tahoma</Name><Size>8.25</Size></Font></Field><Field><Name>Field4</Name><Section>8</Section><Text>zahlungsart_bezeichnung</Text><Calculated>-1</Calculated><Left>1110</Left><Width>1890</Width><Height>285</Height><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field5</Name><Section>8</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>2820</Left><Width>1320</Width><Height>285</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field></Fields></Report><!--Report *** Report ***--><Report version="2.5.20073.258"><Name>Report</Name><ReportInfo /><DataSource><ConnectionString>C:\Users\KASSE\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_journal</RecordSource><Filter>tisch_bondetail_istUmsatz=1</Filter></DataSource><Layout><Width>4335</Width><MarginLeft>0</MarginLeft><MarginTop>0</MarginTop><MarginRight>0</MarginRight><MarginBottom>0</MarginBottom><Orientation>1</Orientation><PaperSize>9</PaperSize></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups><Group><Name>kellner_kurzName</Name><GroupBy>kellner_kurzName</GroupBy><Sort>1</Sort></Group><Group><Name>warengruppe</Name><GroupBy>warengruppe</GroupBy><Sort>1</Sort></Group><Group><Name>zahlungsart_bezeichnung</Name><GroupBy>zahlungsart_bezeichnung</GroupBy><Sort>1</Sort></Group></Groups><Sections><Section><Name>Detail</Name><Type>0</Type><CanShrink>-1</CanShrink></Section><Section><Name>Header</Name><Type>1</Type><Height>2400</Height></Section><Section><Name>Footer</Name><Type>2</Type><Height>2295</Height></Section><Section><Name>PageHeader</Name><Type>3</Type><Height>1635</Height></Section><Section><Name>PageFooter</Name><Type>4</Type></Section><Section><Name>kellner_kurzName_Header</Name><Type>5</Type><Height>1650</Height></Section><Section><Name>kellner_kurzName_Footer</Name><Type>6</Type></Section><Section><Name>warengruppe_Header</Name><Type>7</Type><Height>375</Height><Visible>0</Visible></Section><Section><Name>warengruppe_Footer</Name><Type>8</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Header</Name><Type>9</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Footer</Name><Type>10</Type></Section></Sections><Fields><Field><Name>Logo</Name><Section>1</Section><Width>4110</Width><Height>1935</Height><Picture encoding="base64"></Picture><PictureAlign>7</PictureAlign><PictureScale>2</PictureScale></Field><Field><Name>company</Name><Section>3</Section><Text></Text><Calculated>-1</Calculated><Width>4125</Width><Height>285</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field><Field><Name>Field10</Name><Section>3</Section><Text>TIP Aufstellung</Text><Calculated>-1</Calculated><Left>30</Left><Top>120</Top><Width>4125</Width><Height>270</Height><Align>7</Align><BackColor>0</BackColor><BackStyle>1</BackStyle><ForeColor>16777215</ForeColor><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field><Field><Name>Field12</Name><Section>2</Section><Text>ausgedruckt von:</Text><Calculated>-1</Calculated><Left>120</Left><Top>1395</Top><Width>1695</Width><Height>285</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field13</Name><Section>2</Section><Text>ausgedruckt um:</Text><Calculated>-1</Calculated><Left>120</Left><Top>1575</Top><Width>1695</Width><Height>285</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field14</Name><Section>2</Section><Text>ausgedruckt am:</Text><Calculated>-1</Calculated><Left>120</Left><Top>1815</Top><Width>1695</Width><Height>210</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field15</Name><Section>2</Section><Text>{[name]}</Text><Calculated>-1</Calculated><Left>1830</Left><Top>1395</Top><Width>2280</Width><Height>285</Height><Align>8</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field16</Name><Section>2</Section><Text>Format(Now, "long time")</Text><Calculated>-1</Calculated><Left>1830</Left><Top>1575</Top><Width>2280</Width><Height>285</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field17</Name><Section>2</Section><Text>Format(Now, "long date")</Text><Calculated>-1</Calculated><Left>1830</Left><Top>1815</Top><Width>2280</Width><Height>210</Height><Align>8</Align><Font><Name>Times New Roman</Name><Size>8.25</Size></Font></Field><Field><Name>Field2</Name><Section>2</Section><Left>105</Left><Top>30</Top><Width>4230</Width><Height>15</Height><BackColor>0</BackColor><BackStyle>1</BackStyle><BorderStyle>1</BorderStyle></Field><Field><Name>Field4</Name><Section>5</Section><Top>60</Top><Width>4230</Width><Height>15</Height><BackColor>0</BackColor><BackStyle>1</BackStyle><BorderStyle>1</BorderStyle></Field><Field><Name>Field9</Name><Section>7</Section><Text>warengruppe</Text><Calculated>-1</Calculated><Left>180</Left><Top>30</Top><Width>2235</Width><Height>345</Height><Font><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field11</Name><Section>7</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1890</Left><Top>30</Top><Width>2235</Width><Height>345</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field1</Name><Section>5</Section><Text>"kellner_kurzName = '" &amp; kellner_kurzName &amp;"'"</Text><Left>150</Left><Top>930</Top><Width>4095</Width><Height>105</Height><CanGrow>-1</CanGrow><Subreport>TIP</Subreport></Field><Field><Name>Field3</Name><Section>5</Section><Text>"kellner_kurzName = '" &amp; kellner_kurzName &amp; "'"</Text><Left>75</Left><Top>180</Top><Width>4230</Width><Height>510</Height><CanGrow>-1</CanGrow><Subreport>Kellnerumsatz ohne TIP</Subreport></Field><Field><Name>Field5</Name><Section>5</Section><Text>(inklusive TIP)</Text><Calculated>-1</Calculated><Left>225</Left><Top>1440</Top><Width>1815</Width><Height>210</Height><Font><Name>Tahoma</Name><Size>8.25</Size></Font></Field><Field><Name>Field6</Name><Section>5</Section><Text>kellner_kurzName &amp; " - Gesamt"</Text><Calculated>-1</Calculated><Left>225</Left><Top>1200</Top><Width>2610</Width><Height>345</Height><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field18</Name><Section>5</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1935</Left><Top>1200</Top><Width>2340</Width><Height>345</Height><Align>2</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>12</Size></Font></Field><Field><Name>Field19</Name><Section>2</Section><Left>90</Left><Top>180</Top><Width>4155</Width><Height>615</Height><CanGrow>-1</CanGrow><Subreport>Gesamtumsatz</Subreport></Field><Field><Name>logotext</Name><Section>1</Section><Text></Text><Top>2115</Top><Width>4125</Width><Height>285</Height><Align>7</Align><CanGrow>-1</CanGrow><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field><Field><Name>titleLbl3</Name><Section>3</Section><Text>{[title]} {[checkpointNum]}</Text><Left>60</Left><Top>495</Top><Width>4125</Width><Height>285</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field><Field><Name>company1</Name><Section>3</Section><Calculated>-1</Calculated><Left>15</Left><Top>780</Top><Width>4125</Width><Height>285</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field><Field><Name>Field20</Name><Section>3</Section><Left>15</Left><Top>1425</Top><Width>4125</Width><BorderStyle>1</BorderStyle><LineSlant>1</LineSlant></Field><Field><Name>company3</Name><Section>3</Section><Text>"Seite " &amp; [Page] &amp; " von " &amp; [Pages]</Text><Calculated>-1</Calculated><Left>30</Left><Top>915</Top><Width>4125</Width><Height>285</Height><Align>7</Align><Font><Bold>-1</Bold><Name>Times New Roman</Name><Size>9.75</Size></Font></Field></Fields></Report><!--Report *** TIP ***--><Report version="2.5.20073.258"><Name>TIP</Name><ReportInfo><Author>andi</Author></ReportInfo><DataSource><ConnectionString>C:\Users\KASSE\AppData\Local\Wiffzack\Query\3.13.2.0\data.xml</ConnectionString><RecordSource>umsatz_journal</RecordSource><Filter>is_tip = '1' AND tisch_bondetail_istUmsatz=1</Filter></DataSource><Layout><Width>4320</Width><Orientation>1</Orientation></Layout><Font><Name>Times New Roman</Name><Size>9</Size></Font><Groups><Group><Name>kellner_kurzName</Name><GroupBy>kellner_kurzName</GroupBy><Sort>1</Sort></Group><Group><Name>zahlungsart_bezeichnung</Name><GroupBy>zahlungsart_bezeichnung</GroupBy><Sort>1</Sort><KeepTogether>1</KeepTogether></Group></Groups><Sections><Section><Name>Detail</Name><Type>0</Type></Section><Section><Name>Header</Name><Type>1</Type></Section><Section><Name>Footer</Name><Type>2</Type></Section><Section><Name>PageHeader</Name><Type>3</Type></Section><Section><Name>PageFooter</Name><Type>4</Type><Height>5</Height></Section><Section><Name>kellner_kurzName_Header</Name><Type>5</Type><Height>345</Height></Section><Section><Name>kellner_kurzName_Footer</Name><Type>6</Type><Visible>0</Visible></Section><Section><Name>zahlungsart_bezeichnung_Header</Name><Type>7</Type><Height>285</Height></Section><Section><Name>zahlungsart_bezeichnung_Footer</Name><Type>8</Type></Section></Sections><Fields><Field><Name>Field1</Name><Section>7</Section><Text>"TIP - " &amp; zahlungsart_bezeichnung</Text><Calculated>-1</Calculated><Left>915</Left><Width>2205</Width><Height>285</Height><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field2</Name><Section>7</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>2325</Left><Width>1725</Width><Height>285</Height><Align>2</Align><Font><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field3</Name><Section>5</Section><Text>kellner_kurzName &amp; " - TIP"</Text><Calculated>-1</Calculated><Left>120</Left><Width>2250</Width><Height>345</Height><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>11.25</Size></Font></Field><Field><Name>Field4</Name><Section>5</Section><Text>sum(tisch_bondetail_absmenge * tisch_bondetail_preis)</Text><Calculated>-1</Calculated><Format>#,##0.00</Format><Left>1845</Left><Width>2235</Width><Height>345</Height><Align>2</Align><Font><Bold>-1</Bold><Name>Tahoma</Name><Size>11.25</Size></Font></Field></Fields></Report></Reports> True CheckpointSelection TIP-ABSCHLUSSDATUM <ScriptDocument><MainCode>DataSet ds = GetData(); var data = ds.Tables["umsatz_journal"]; var dt = new DataTable("preview"); dt.Columns.Add("Kellner", typeof(String)); dt.Columns.Add("Warengruppe", typeof(String)); dt.Columns.Add("Zahlungsart", typeof(String)); dt.Columns.Add("Summe", typeof(decimal)); System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;&gt;&gt; sums = new System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;string, decimal&gt;&gt;&gt;(); System.Collections.Generic.Dictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;&gt; tipForWaiter = new System.Collections.Generic.Dictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;&gt;(); foreach(DataRow previewRow in data.Rows){ if((bool)previewRow["tisch_bondetail_istUmsatz"] == false) continue; string kellner = (string)previewRow["kellner_kurzName"]; string warengruppe = (string)previewRow["warengruppe"]; string zahlungsart = (string)previewRow["zahlungsart_bezeichnung"]; bool isTip = (int)previewRow["is_tip"] != 0; decimal sum = (decimal)previewRow["tisch_bondetail_preis"] * (decimal)(int)previewRow["tisch_bondetail_absmenge"]; if(isTip){ if(!tipForWaiter.ContainsKey(kellner)) tipForWaiter.Add(kellner, new System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;()); if(!tipForWaiter[kellner].ContainsKey(zahlungsart)){ tipForWaiter[kellner].Add(zahlungsart, sum); } else{ tipForWaiter[kellner][zahlungsart] = tipForWaiter[kellner][zahlungsart] + sum; } } else { if(!sums.ContainsKey(kellner)) sums.Add(kellner, new System.Collections.Generic.SortedDictionary&lt;String, System.Collections.Generic.SortedDictionary&lt;string, decimal&gt;&gt;()); if(!sums[kellner].ContainsKey(warengruppe)) sums[kellner].Add(warengruppe, new System.Collections.Generic.SortedDictionary&lt;String, decimal&gt;()); if(!sums[kellner][warengruppe].ContainsKey(zahlungsart)) sums[kellner][warengruppe].Add(zahlungsart, sum); else sums[kellner][warengruppe][zahlungsart] = sums[kellner][warengruppe][zahlungsart] + sum; } } foreach(String kellner in sums.Keys){ foreach(String warengruppe in sums[kellner].Keys){ foreach(String zahlungsart in sums[kellner][warengruppe].Keys){ var dr = dt.NewRow(); dr["Kellner"] = kellner; dr["Warengruppe"] = warengruppe; dr["Zahlungsart"] = zahlungsart; dr["Summe"] = sums[kellner][warengruppe][zahlungsart]; dt.Rows.Add(dr); } } if(tipForWaiter.ContainsKey(kellner)){ foreach(string zahlungsart in tipForWaiter[kellner].Keys){ var dr = dt.NewRow(); dr["Kellner"] = kellner; dr["Warengruppe"] = "TIP"; dr["Zahlungsart"] = zahlungsart; dr["Summe"] = tipForWaiter[kellner][zahlungsart]; dt.Rows.Add(dr); } } } var dataTables = new System.Collections.Generic.List&lt;DataTable&gt;(); foreach(DataTable d in ds.Tables){ dataTables.Add(d); } ds.Tables.Clear(); ds.Tables.Add(dt); foreach(var d in dataTables){ ds.Tables.Add(d); } </MainCode></ScriptDocument> Wiffzack.Query.Visualisation.UmsatzRequestVisualizer 17 67 Kellner 85 Warengruppe 106 Zahlungsart 51 Summe