BAZA_REKLAM
d5cd74ea-0203-4897-b23b-608b6e7c9ee7
2.5cm
1cm
21cm
true
21cm
0.25cm
true
1cm
0.5cm
0.25cm
1
18cm
true
0.63492cm
RANKING AGENTÓW
0.5cm
RankingAgentow
1.25cm
18cm
SYMBOL_AKWIZYTORA
3
true
=Fields!SYMBOL_AKWIZYTORA.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
2.75cm
b9375294-f8e7-4520-8f81-374698915f18
1cm
true
SELECT [SYMBOL AKWIZYTORA], CONVERT(money, SUM(NETTO))
AS WARTOSC, COUNT(*) AS ILOSC, CONVERT(money,
SUM(NETTO)) / COUNT(*) AS srednio
FROM dbo.REKLAMA R
WHERE (({ fn YEAR([DATA ZAPŁATY]) } = { fn YEAR(GETDATE()) })) and [ZAPŁACONO]=-1
GROUP BY [SYMBOL AKWIZYTORA]
order by 2 desc
BAZA_REKLAM
System.String
SYMBOL AKWIZYTORA
System.Decimal
WARTOSC
System.Int32
ILOSC
System.Decimal
srednio
19cm
29.7cm
en-US
2.5cm
29.7cm