Index: trunk/RaportySQL/RankingAgentow2009.rdl
===================================================================
--- trunk/RaportySQL/RankingAgentow2009.rdl (revision 186)
+++ trunk/RaportySQL/RankingAgentow2009.rdl (revision 186)
@@ -0,0 +1,367 @@
+
+
+
+
+ d5cd74ea-0203-4897-b23b-608b6e7c9ee7
+ BAZA_REKLAM
+
+
+ 29.7cm
+ true
+ 21cm
+ 0.25cm
+ true
+ 1cm
+ 1cm
+ 2.5cm
+ b9375294-f8e7-4520-8f81-374698915f18
+ 21cm
+
+
+
+
+ symbol
+ System.String
+
+
+ WARTOSC
+ System.Decimal
+
+
+ ILOSC
+ System.Int32
+
+
+ srednio
+ System.Decimal
+
+
+
+ BAZA_REKLAM
+ SELECT A.symbol, CONVERT(money, SUM(FD.NETTO))
+ AS WARTOSC, COUNT(F.id_faktury) AS ILOSC, CONVERT(money,
+ SUM(FD.NETTO)) / COUNT(f.id_faktury) AS srednio
+FROM dbo.FAKTURY F left join
+ FAKTURA_DETAILS FD on F.id_faktury = FD.id_faktury left join
+ AGENCI A on F.numer_roz = A.f_roz
+WHERE F.numer_rok >=2009 and (({ fn YEAR([zaplata_data]) } = { fn YEAR(GETDATE()) }))
+GROUP BY A.[symbol]
+order by 2 desc
+ true
+
+
+
+
+ RankingAgentow
+ 2cm
+ 18cm
+
+
+
+
+
+
+
+ SYMBOL_AKWIZYTORA
+
+ 3
+ true
+ =Fields!symbol.Value
+
+
+
+
+
+
+ WARTOSC
+
+ 2
+ true
+ =Fields!WARTOSC.Value
+
+
+
+
+
+
+ ILOSC
+
+ 1
+ true
+ =Fields!ILOSC.Value
+
+
+
+
+
+
+ srednio
+
+ true
+ =Fields!srednio.Value
+
+
+
+
+ 0.75cm
+
+
+
+
+
+
+
+
+
+
+ textbox1
+
+ 7
+ true
+ Agent
+
+
+
+
+
+
+ textbox2
+
+ 6
+ true
+ WartoÅÄ
+
+
+
+
+
+
+ textbox3
+
+ 5
+ true
+ IloÅÄ
+
+
+
+
+
+
+ textbox4
+
+ 4
+ true
+ Årednio
+
+
+
+
+ 0.75cm
+
+
+
+
+
+ 5.25cm
+
+
+ 5cm
+
+
+ 3.25cm
+
+
+ 4.5cm
+
+
+ 0.5cm
+
+
+ 3.5cm
+
+ en-US
+ 2.5cm
+ 29.7cm
+
Index: trunk/RaportySQL/RaportySQL.rptproj
===================================================================
--- trunk/RaportySQL/RaportySQL.rptproj (revision 185)
+++ trunk/RaportySQL/RaportySQL.rptproj (revision 186)
@@ -316,4 +316,8 @@
RankingKlientow2009.rdl
RankingKlientow2009.rdl
+
+
+ RankingAgentow2009.rdl
+ RankingAgentow2009.rdl
Index: trunk/BazaReklam/ReportsForm.cs
===================================================================
--- trunk/BazaReklam/ReportsForm.cs (revision 185)
+++ trunk/BazaReklam/ReportsForm.cs (revision 186)
@@ -570,4 +570,9 @@
node.Text = "Ranking klientów od 2009";
raportyTreeView.Nodes["Rankingi"].Nodes.Add(node);
+
+ node = new TreeNode();
+ node.Name = "/" + reportsCatalog + "/RankingAgentow2009";
+ node.Text = "Ranking agentów";
+ raportyTreeView.Nodes["Rankingi"].Nodes.Add(node);
}
@@ -598,10 +603,5 @@
node.Text = "Przychody i koszty biura";
raportyTreeView.Nodes["Koszty biur"].Nodes.Add(node);
-
- node = new TreeNode();
- node.Name = "/" + reportsCatalog + "/RankingAgentow";
- node.Text = "Ranking agentów";
- stareRaportyTreeView.Nodes["Rankingi"].Nodes.Add(node);
-
+
node = new TreeNode();
node.Name = "/" + reportsCatalog + "/WykresWplywyNaNumer";