Index: trunk/RaportySQL/RaportySQL.rptproj
===================================================================
--- trunk/RaportySQL/RaportySQL.rptproj (revision 554)
+++ trunk/RaportySQL/RaportySQL.rptproj (revision 575)
@@ -46,4 +46,8 @@
+ ErrorLog.rdl
+ ErrorLog.rdl
+
+
FakturyGrzbiet.rdl
FakturyGrzbiet.rdl
@@ -402,6 +406,6 @@
- ErrorLog.rdl
- ErrorLog.rdl
+ SredniaCenaModulow.rdl
+ SredniaCenaModulow.rdl
Index: trunk/RaportySQL/SredniaCenaModulow.rdl
===================================================================
--- trunk/RaportySQL/SredniaCenaModulow.rdl (revision 575)
+++ trunk/RaportySQL/SredniaCenaModulow.rdl (revision 575)
@@ -0,0 +1,516 @@
+
+
+
+
+ 7a3117ba-2e48-4045-91d5-12c8618a9930
+ BAZA_REKLAM
+
+
+ 11in
+
+
+ String
+
+
+ =Year(Today)
+
+
+ true
+ Rok:
+
+
+ ListaLat
+ rok
+ rok
+
+
+
+
+ String
+
+
+ =Month(Today)
+
+
+ Miesiąc:
+
+
+
+ 1
+
+
+ 2
+
+
+ 3
+
+
+ 4
+
+
+ 5
+
+
+ 6
+
+
+ 7
+
+
+ 8
+
+
+ 9
+
+
+ 10
+
+
+ 11
+
+
+ 12
+
+
+
+ true
+
+
+ String
+
+
+ AMT
+ GS
+ adMot
+
+
+ Tytuł:
+
+
+
+ AMT
+
+
+ GS
+
+
+ adMot
+
+
+
+ true
+
+
+ true
+ 8.5in
+ 0.25cm
+ true
+ 2.5cm
+ 2.5cm
+ 2.5cm
+ cddaaabe-22d1-4745-812e-083e6fb21360
+ 21cm
+
+
+
+
+ Agent
+ System.String
+
+
+ Modul
+ System.String
+
+
+ Sprzedano
+ System.Decimal
+
+
+ Cennik
+ System.Decimal
+
+
+
+ BAZA_REKLAM
+ SELECT
+LOWER(A.Symbol) AS Agent,
+M.Mod_Typ AS Modul,
+CAST(SUM(((R.[Cena Jedn] - R.[Rabat Wartość]) * R.[Krotność]) / (R.Szer * R.Wys * R.[Krotność]))/Count(R.ReklamaId) AS DECIMAL(9,2)) AS Sprzedano,
+CAST(SUM(M.Cena)/Count(R.ReklamaId) AS DECIMAL(9,2)) AS Cennik
+FROM [ukaże się w nr] U
+INNER JOIN Reklama R ON R.ReklamaID = U.ReklamaID
+INNER JOIN [Nazwy Modułów] M ON M.Mod_Typ=R.Mod_Typ
+INNER JOIN [Nr] N ON N.TYT=R.[TYTUŁ] AND N.NRW=U.[Nr Wydania]
+INNER JOIN Faktury F ON F.ID_Faktury = U.idFaktury
+INNER JOIN Agenci A ON F.Numer_Roz=A.F_Roz
+WHERE R.[TYTUŁ] IN (@title)
+AND R.Typ='PŁATNA'
+AND YEAR(F.[DATA_SPRZEDAZY])=@year
+AND MONTH(F.[DATA_SPRZEDAZY]) IN (@month)
+AND U.idFaktury IS NOT NULL
+GROUP BY A.Symbol, M.Mod_Typ
+ORDER BY A.Symbol, M.Mod_Typ
+
+
+ =Parameters!title.Value
+
+
+ =Parameters!year.Value
+
+
+ =Parameters!month.Value
+
+
+ true
+
+
+
+
+
+ rok
+ System.Int32
+
+
+
+ BAZA_REKLAM
+ select distinct year(DATA_W) as rok from dbo.NR where DATA_W is not null AND year(DATA_W)>2008 order by year(DATA_W) desc
+ true
+
+
+
+ Public Function GetMonths(P as Parameter) as String
+ Dim i As Integer
+ Dim s As String
+ s = p.value(0)
+ For i = 1 to Ubound(P.Value)
+ s = s & ", " & p.Value(i)
+ Next i
+ Return s
+End Function
+ 13.45cm
+
+ 1cm
+
+
+ 0.75cm
+ 13.25cm
+
+ 2
+ true
+ 0.75cm
+ ="Tytuł(y): " + Code.GetMonths(Parameters!title)
+
+
+ textbox1
+ 13.25cm
+
+ 1
+ true
+ 0.75cm
+ ="Średnia cena modułów sprzedanych w " + CStr(Parameters!year.Value) + " - " + Code.GetMonths(Parameters!month)
+
+
+ Moduly
+ 1.75cm
+
+
+
+
+
+
+
+ Agent
+
+ 4
+ true
+ =Fields!Agent.Value
+
+
+
+
+
+
+ Modul
+
+ 3
+ true
+ =Fields!Modul.Value
+
+
+
+
+
+
+ Sprzedano
+
+ 2
+ true
+ =Fields!Sprzedano.Value
+
+
+
+
+
+
+ Cennik
+
+ 1
+ true
+ =Fields!Cennik.Value
+
+
+
+
+
+
+ textbox7
+
+ true
+ =(1 - (Fields!Sprzedano.Value/Fields!Cennik.Value))
+
+
+
+
+ 0.53333cm
+
+
+
+
+
+
+
+
+
+
+ textbox2
+
+ 9
+ true
+ Agent
+
+
+
+
+
+
+ textbox3
+
+ 8
+ true
+ Moduł
+
+
+
+
+
+
+ textbox4
+
+ 7
+ true
+ Cena sprzedaży
+
+
+
+
+
+
+ textbox5
+
+ 6
+ true
+ Cena w cenniku
+
+
+
+
+
+
+ textbox6
+
+ 5
+ true
+ Procent rabatu
+
+
+
+
+ 0.53333cm
+
+
+ true
+
+
+
+ 2.55cm
+
+
+ 2.55cm
+
+
+ 2.55cm
+
+
+ 2.55cm
+
+
+ 3.25cm
+
+
+
+
+ 2.81666cm
+
+ pl-PL
+ 2.5cm
+ 29.7cm
+