38ed669d-1480-42c9-a131-3541eb1020c1 BAZA_REKLAM 29.7cm true 21cm 0.25cm true 2.5cm 2.5cm 2.5cm d0a91cad-1242-460b-89c7-3902955a12fb 21cm rok1 System.Int32 kk System.Int32 kr System.Int32 BAZA_REKLAM select rok1, kk, kr from (select year(data) as rok1, count(distinct customerId) as kk from dbo.KONTAKTY where year(data) >=2005 group by year(data) ) t1 left join (select year([FAKTURA DATA WYSTAWIENIA]) as rok2, count(distinct customerId) as kr from dbo.reklama where year([FAKTURA DATA WYSTAWIENIA]) >= 2005 AND TYP ='PŁATNA' group by year([FAKTURA DATA WYSTAWIENIA]),typ ) t2 on t1.rok1 = t2.rok2 order by rok1 desc true rok System.Int32 liczba System.Int32 liczba_klientow System.Int32 liczba_kontaktow System.Int32 BAZA_REKLAM select rok, liczba, count(customerId) as liczba_klientow, sum(liczba_kontaktow) as liczba_kontaktow from ( select customerId, rok, sum(liczba) as liczba, liczba_kontaktow from ( select distinct customerId, tytuł, year([FAKTURA DATA WYSTAWIENIA])as rok,5 as liczba from reklama where (tytuł='adMot') and year([FAKTURA DATA WYSTAWIENIA])>=2005 union select distinct customerId, tytuł, year([FAKTURA DATA WYSTAWIENIA]) as rok,3 as liczba from reklama where (tytuł='GS') and year([FAKTURA DATA WYSTAWIENIA])>=2005 union select distinct customerId, tytuł, year([FAKTURA DATA WYSTAWIENIA]) as rok,1 as liczba from reklama where (tytuł='AMT') and year([FAKTURA DATA WYSTAWIENIA])>=2005 ) t1 left join (select count(*) as liczba_kontaktow, customerId as custId, year(data) as rok1 from dbo.KONTAKTY where year(data) >=2005 group by customerId, year(data) ) t2 on t1.customerId = t2.custId and t1.rok = t2.rok1 group by rok, customerId, liczba_kontaktow ) t3 group by rok, liczba order by rok desc, liczba true d1 System.Int32 c1 System.Int32 c2 System.Int32 c3 System.Int32 BAZA_REKLAM select d1,c1,c2,c3 from ( (select count( distinct customerID) as c1, year(data) as d1 from dbo.KONTAKTY where opis like '%G*%' group by year(data)) t1 left join (select count( distinct customerID) as c2, year(data) as d2 from dbo.KONTAKTY where opis like '%T*%' group by year(data)) t2 on t1.d1=t2.d2 left join (select count( distinct customerID) as c3, year(data) as d3 from dbo.KONTAKTY group by year(data)) t3 on t2.d2=t3.d3 ) order by d1 desc true 16.5cm 1cm true BottomCenter <MajorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <MajorTickMarks>Inside</MajorTickMarks> <Min>0</Min> <Visible>true</Visible> </Axis> </CategoryAxis> <ZIndex>2</ZIndex> <DataSetName>Kontakty3</DataSetName> <PlotArea> <Style> <BackgroundColor>LightGrey</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </PlotArea> <ThreeDProperties> <Enabled>true</Enabled> <Shading>Real</Shading> <DrawingStyle>Cylinder</DrawingStyle> </ThreeDProperties> <PointWidth>0</PointWidth> <SeriesGroupings> <SeriesGrouping> <StaticSeries> <StaticMember> <Label>liczba klientów z którymi był kontakt w sprawie reklamy w GS</Label> </StaticMember> <StaticMember> <Label>liczba klientów z którymi był kontakt w sprawie reklamy w AMT</Label> </StaticMember> <StaticMember> <Label>liczba klientów z którymi był kontakt w sprawie reklamy (wszystkie)</Label> </StaticMember> </StaticSeries> </SeriesGrouping> </SeriesGroupings> <Top>11.25cm</Top> <Subtype>Plain</Subtype> <ValueAxis> <Axis> <Title /> <MajorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <MajorTickMarks>Inside</MajorTickMarks> <Min>0</Min> <Margin>true</Margin> <Visible>true</Visible> <Scalar>true</Scalar> </Axis> </ValueAxis> <Type>Column</Type> <Width>16.25cm</Width> <CategoryGroupings> <CategoryGrouping> <DynamicCategories> <Grouping Name="chart2_CategoryGroup1"> <GroupExpressions> <GroupExpression>=Fields!d1.Value</GroupExpression> </GroupExpressions> </Grouping> <Label /> </DynamicCategories> </CategoryGrouping> </CategoryGroupings> <Palette>Pastel</Palette> <ChartData> <ChartSeries> <DataPoints> <DataPoint> <DataValues> <DataValue> <Value>=Fields!c1.Value</Value> </DataValue> </DataValues> <DataLabel> <Value>=Fields!c1.Value</Value> <Visible>true</Visible> </DataLabel> <Marker> <Size>6pt</Size> </Marker> </DataPoint> </DataPoints> </ChartSeries> <ChartSeries> <DataPoints> <DataPoint> <DataValues> <DataValue> <Value>=Fields!c2.Value</Value> </DataValue> </DataValues> <DataLabel> <Value>=Fields!c2.Value</Value> <Visible>true</Visible> </DataLabel> <Marker> <Size>6pt</Size> </Marker> </DataPoint> </DataPoints> </ChartSeries> <ChartSeries> <DataPoints> <DataPoint> <DataValues> <DataValue> <Value>=Fields!c3.Value</Value> </DataValue> </DataValues> <DataLabel> <Value>=Fields!c3.Value</Value> <Visible>true</Visible> </DataLabel> <Marker> <Size>6pt</Size> </Marker> </DataPoint> </DataPoints> </ChartSeries> </ChartData> <Style> <BackgroundColor>White</BackgroundColor> </Style> <Title> <Caption>Analiza klientów 2</Caption> 11.25cm 1 Kontakty2 rok 15cm 1 true 0.5cm 0.63492cm =Fields!rok.Value Kontakty20.75cm15.08334cm
liczba 2 true =switch(Fields!liczba.Value = 1,"AMT", Fields!liczba.Value = 3,"GS", Fields!liczba.Value = 5,"adMoto",Fields!liczba.Value = 4,"AMT i GS", Fields!liczba.Value = 6,"AMT i adMoto",Fields!liczba.Value =8,"GS i adMoto", Fields!liczba.Value = 9,"AMT, GS, adMoto") liczba_klientow 1 true =Fields!liczba_klientow.Value liczba_kontaktow true =Fields!liczba_kontaktow.Value 0.63492cm
textbox2 5 true Tytuł textbox3 4 true Liczba klientów textbox4 3 true Liczba kontaktów 0.63492cm
4.25cm 5.41667cm 5.41667cm 1.26984cm0.5cm
 22.75cm 16.25cm =Fields!rok.Value true true BottomCenter <MajorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <MajorTickMarks>Inside</MajorTickMarks> <Min>0</Min> <Visible>true</Visible> </Axis> </CategoryAxis> <DataSetName>Kontakty</DataSetName> <PlotArea> <Style> <BackgroundColor>LightGrey</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </PlotArea> <ThreeDProperties> <Enabled>true</Enabled> <Shading>Real</Shading> <DrawingStyle>Cylinder</DrawingStyle> </ThreeDProperties> <PointWidth>0</PointWidth> <SeriesGroupings> <SeriesGrouping> <StaticSeries> <StaticMember> <Label>liczba klientów, z którymi był kontakt w danym roku </Label> </StaticMember> <StaticMember> <Label>liczba klientów, którzy kupili reklamę w danym roku</Label> </StaticMember> </StaticSeries> </SeriesGrouping> </SeriesGroupings> <Subtype>Plain</Subtype> <ValueAxis> <Axis> <Title /> <MajorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <MajorTickMarks>Inside</MajorTickMarks> <Min>0</Min> <Margin>true</Margin> <Visible>true</Visible> <Scalar>true</Scalar> </Axis> </ValueAxis> <Type>Column</Type> <Width>16.25cm</Width> <CategoryGroupings> <CategoryGrouping> <DynamicCategories> <Grouping Name="chart1_CategoryGroup1"> <GroupExpressions> <GroupExpression>=Fields!rok1.Value</GroupExpression> </GroupExpressions> </Grouping> <Label /> </DynamicCategories> </CategoryGrouping> </CategoryGroupings> <Palette>Pastel</Palette> <ChartData> <ChartSeries> <DataPoints> <DataPoint> <DataValues> <DataValue> <Value>=Fields!kk.Value</Value> </DataValue> </DataValues> <DataLabel> <Value>=Fields!kk.Value</Value> <Position>Top</Position> <Visible>true</Visible> </DataLabel> <Marker> <Size>6pt</Size> </Marker> </DataPoint> </DataPoints> </ChartSeries> <ChartSeries> <DataPoints> <DataPoint> <DataValues> <DataValue> <Value>=Fields!kr.Value</Value> </DataValue> </DataValues> <DataLabel> <Value>=Fields!kr.Value</Value> <Position>Top</Position> <Visible>true</Visible> </DataLabel> <Marker> <Size>6pt</Size> </Marker> </DataPoint> </DataPoints> </ChartSeries> </ChartData> <Style> <BackgroundColor>White</BackgroundColor> </Style> <Title> <Caption>Analiza klientów</Caption> 11cm 25cm en-US 2.5cm 29.7cm