{"id":503,"date":"2015-07-26T16:02:06","date_gmt":"2015-07-26T14:02:06","guid":{"rendered":"http:\/\/www.flip-design.de\/?p=503"},"modified":"2015-07-26T16:03:31","modified_gmt":"2015-07-26T14:03:31","slug":"ssrs-summen-aus-anderen-gruppen-erhalten","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=503","title":{"rendered":"SSRS: Summen aus anderen Gruppen erhalten"},"content":{"rendered":"

(see english Version below)<\/p>\n

In diesem Szenario will ich aufzeigen, wie man in SQL Server Reporting Services die Summen aus andere Gruppen (\u00fcber- wie auch untergeordnet) wiederverwenden kann, bspw. um Anteile berechnen zu k\u00f6nnen.
\n\"tablix2\"<\/a><\/p>\n

Im diesem Screen sieht man ein Tablix welches Gruppiert nach Ort ist und die Kopfzeile bildet. Darunter ist nach einem Status gruppiert und die Summen zu der jeweiligen Gruppe werden ausgegeben sowie auch f\u00fcr die Kopfzeile (fett gedruckt).<\/p>\n

Nun ist das Ziel, dass man anteilig ausrechnen kann, welchen Anteil der jeweilige Status an dem Ergebnis pro Ort hat.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Daf\u00fcr kann man die SUM oder auch COUNT Funktion erweitern indem man den Gruppennamen aus dem Tablix mitgibt:<\/p>\n

=SUM(Fields!Betrag.Value)\/SUM(Fields!Betrag.Value, \"Wohnort\")<\/pre>\n
\"tablix1\"<\/a><\/p>\n
Weitere Informationen gibt es hier: https:\/\/technet.microsoft.com\/en-us\/library\/bb630415(v=sql.100).aspx<\/a><\/p>\n
 <\/p>\n
English Version<\/strong><\/p>\n
In this scenario,<\/span> I will<\/span> show how<\/span> you can<\/span> in<\/span> SQL Server Reporting Services<\/span> to reuse<\/span> the<\/span> totals from<\/span> other groups<\/span> (over<\/span> like<\/span> subordinate<\/span>), eg<\/span>. To<\/span> calculate<\/span> the shares<\/span>.
\nIn the following<\/span> screen<\/span> you can see<\/span> a<\/span> Tablix<\/span> is<\/span> that groups<\/span> by location<\/span> and<\/span> forms the<\/span> header<\/span>. Among them<\/span> is<\/span> for a status<\/span> groups<\/span> and<\/span> the totals<\/span> for<\/span> each group<\/span> will be issued<\/span> as well as<\/span> for the header<\/span> (in bold)<\/span>.<\/p>\n
\"tablix2\"<\/a>
\nNow<\/span>, the goal is that you can<\/span> calculate<\/span> proportionally<\/span> the share<\/span> has<\/span> the respective status<\/span> of<\/span> the<\/span> earnings per<\/span> site<\/span>.
\nFor this you can<\/span> expand the<\/span> SUM<\/span> or<\/span> COUNT<\/span> function<\/span> by<\/span> mitgibt<\/span> the group name<\/span> from the<\/span> Tablix<\/span>:
\n=<\/span> SUM<\/span> (<\/span>Fields! Betrag.Value<\/span>) \/<\/span> SUM<\/span> (<\/span>Fields! Betrag.Value<\/span>, „<\/span>Location“)<\/p>\n
Further information is available<\/span> here<\/span>: https:\/\/technet.microsoft.com\/en-us\/library\/bb630415(v=sql.100).aspx <\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
(see english Version below) In diesem Szenario will ich aufzeigen, wie man in SQL Server Reporting Services die Summen aus andere Gruppen (\u00fcber- wie auch untergeordnet) wiederverwenden kann, bspw. um Anteile berechnen zu k\u00f6nnen. Im diesem Screen sieht man ein … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":394,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[25,1,30,33,35],"tags":[],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/503"}],"collection":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=503"}],"version-history":[{"count":2,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/503\/revisions"}],"predecessor-version":[{"id":507,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/503\/revisions\/507"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/media\/394"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}