BAZA_REKLAM 6a2bec57-03d9-4f28-a49c-65e1805de702 1cm 1cm 29.7cm String =Year(Today) od roku ListaLat rok rok String =Year(Today) true do roku ListaLat rok rok String true tytuł: ListaTytulow value label String true agencja ListaAgencji Id_agencji Symbol String true agent ListaAgentow ID_AGENTA Symbol true 21cm 0.25cm true 1cm true RightCenter Plain <CategoryAxis> <Axis> <Title /> <MajorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <MajorTickMarks>Outside</MajorTickMarks> <Min>0</Min> <Visible>true</Visible> </Axis> </CategoryAxis> <PointWidth>0</PointWidth> <Left>4.25cm</Left> <ThreeDProperties> <Enabled>true</Enabled> <ProjectionMode>Orthographic</ProjectionMode> <Rotation>25</Rotation> <Inclination>-30</Inclination> <Perspective>49</Perspective> <Shading>Real</Shading> <WallThickness>49</WallThickness> <DrawingStyle>Cylinder</DrawingStyle> <Clustered>true</Clustered> </ThreeDProperties> <DataSetName>wgDatyFakturywgPanstw</DataSetName> <Top>4.25cm</Top> <PlotArea> <Style> <BackgroundColor>White</BackgroundColor> </Style> </PlotArea> <ValueAxis> <Axis> <Title /> <MajorGridLines> <ShowGridLines>true</ShowGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <MajorTickMarks>Outside</MajorTickMarks> <Min>0</Min> <Margin>true</Margin> <Visible>true</Visible> <Scalar>true</Scalar> </Axis> </ValueAxis> <ZIndex>3</ZIndex> <Type>Pie</Type> <Width>12cm</Width> <CategoryGroupings> <CategoryGrouping> <DynamicCategories> <Grouping Name="chart2_CategoryGroup1"> <GroupExpressions> <GroupExpression>=Fields!b.Value</GroupExpression> </GroupExpressions> </Grouping> <Label>=iif(Fields!b.Value=1,"POLSKA","INNE")</Label> </DynamicCategories> </CategoryGrouping> </CategoryGroupings> <Palette>Light</Palette> <ChartData> <ChartSeries> <DataPoints> <DataPoint> <DataValues> <DataValue> <Value>=Sum(Fields!netto.Value)</Value> </DataValue> </DataValues> <DataLabel> <Value>=Code.Formatuj(Sum(Fields!netto.Value))</Value> <Visible>true</Visible> </DataLabel> <Marker> <Size>6pt</Size> </Marker> </DataPoint> </DataPoints> </ChartSeries> </ChartData> <Style> <BackgroundColor>White</BackgroundColor> </Style> </Chart> <Textbox Name="textbox8"> <Left>10.75cm</Left> <Top>0.25cm</Top> <rd:DefaultName>textbox8</rd:DefaultName> <ZIndex>2</ZIndex> <Width>9.25cm</Width> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Height>0.63492cm</Height> <Value>(wg daty wystawienia faktury)</Value> </Textbox> <Textbox Name="textbox9"> <Left>1cm</Left> <Top>0.25cm</Top> <rd:DefaultName>textbox9</rd:DefaultName> <ZIndex>1</ZIndex> <Width>9.25cm</Width> <Style> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>12pt</FontSize> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Height>0.63492cm</Height> <Value>ZESTAWIENIE SPRZEDAŻY WG PAŃST</Value> </Textbox> <Table Name="table1"> <Footer> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox12"> <rd:DefaultName>textbox12</rd:DefaultName> <ZIndex>2</ZIndex> <Style> <TextAlign>Right</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <VerticalAlign>Middle</VerticalAlign> <Format>C</Format> <BorderColor> <Default>LightGrey</Default> </BorderColor> <PaddingRight>12pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox13"> <rd:DefaultName>textbox13</rd:DefaultName> <ZIndex>1</ZIndex> <Style> <TextAlign>Right</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <VerticalAlign>Middle</VerticalAlign> <Format>C</Format> <BorderColor> <Default>LightGrey</Default> </BorderColor> <PaddingRight>12pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox14"> <rd:DefaultName>textbox14</rd:DefaultName> <Style> <TextAlign>Right</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <VerticalAlign>Middle</VerticalAlign> <Format>C</Format> <BorderColor> <Default>LightGrey</Default> </BorderColor> <PaddingRight>12pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.25cm</Height> </TableRow> <TableRow> <TableCells> <TableCell> <ColSpan>3</ColSpan> <ReportItems> <Textbox Name="textbox7"> <rd:DefaultName>textbox7</rd:DefaultName> <ZIndex>3</ZIndex> <Style> <BorderStyle> <Bottom>Solid</Bottom> <Top>Solid</Top> <Left>Solid</Left> <Right>Solid</Right> </BorderStyle> <TextAlign>Right</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <VerticalAlign>Middle</VerticalAlign> <Format>C</Format> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BackgroundColor>WhiteSmoke</BackgroundColor> <PaddingRight>12pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <Language>pl</Language> </Style> <CanGrow>true</CanGrow> <Value>="SUMA: " & Code.Formatuj(Sum(Fields!netto.Value))</Value> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.63492cm</Height> </TableRow> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox10"> <rd:DefaultName>textbox10</rd:DefaultName> <ZIndex>6</ZIndex> <Style> <BorderStyle> <Bottom>Solid</Bottom> <Top>Solid</Top> <Left>Solid</Left> <Right>Solid</Right> </BorderStyle> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <VerticalAlign>Middle</VerticalAlign> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox11"> <rd:DefaultName>textbox11</rd:DefaultName> <ZIndex>5</ZIndex> <Style> <BorderStyle> <Bottom>Solid</Bottom> <Top>Solid</Top> <Left>Solid</Left> <Right>Solid</Right> </BorderStyle> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <VerticalAlign>Middle</VerticalAlign> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="MAX"> <ZIndex>4</ZIndex> <Style> <BorderStyle> <Bottom>Solid</Bottom> <Top>Solid</Top> <Left>Solid</Left> <Right>Solid</Right> </BorderStyle> <TextAlign>Right</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <VerticalAlign>Middle</VerticalAlign> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <Language>pl-PL</Language> </Style> <CanGrow>true</CanGrow> <Value>=Max(Fields!netto.Value)</Value> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.63492cm</Height> <Visibility> <Hidden>true</Hidden> </Visibility> </TableRow> </TableRows> </Footer> <Left>1cm</Left> <DataSetName>wgDatyFakturywgPanstw</DataSetName> <Top>1cm</Top> <TableGroups> <TableGroup> <Header> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox4"> <rd:DefaultName>textbox4</rd:DefaultName> <ZIndex>12</ZIndex> <Style> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <VerticalAlign>Middle</VerticalAlign> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox5"> <rd:DefaultName>textbox5</rd:DefaultName> <ZIndex>11</ZIndex> <Style> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <VerticalAlign>Middle</VerticalAlign> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox6"> <rd:DefaultName>textbox6</rd:DefaultName> <ZIndex>10</ZIndex> <Style> <VerticalAlign>Middle</VerticalAlign> <BackgroundColor>White</BackgroundColor> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.25cm</Height> </TableRow> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="kraj"> <rd:DefaultName>kraj</rd:DefaultName> <ZIndex>9</ZIndex> <Style> <TextAlign>Left</TextAlign> <PaddingLeft>12pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <VerticalAlign>Middle</VerticalAlign> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>=Iif(IsNothing(Fields!kraj.Value),"Pozostałe",Fields!kraj.Value)</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="ilosc"> <rd:DefaultName>ilosc</rd:DefaultName> <ZIndex>8</ZIndex> <Style> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <VerticalAlign>Middle</VerticalAlign> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>=Sum(Fields!ilosc.Value)</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Chart Name="chart1"> <Legend> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> <Position>RightCenter</Position> </Legend> <Subtype>Plain</Subtype> <Title> <Style /> <MajorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <Min>0</Min> </Axis> </CategoryAxis> <PointWidth>0</PointWidth> <ThreeDProperties> <Enabled>true</Enabled> <Shading>Real</Shading> <DrawingStyle>Cylinder</DrawingStyle> </ThreeDProperties> <DataSetName>wgDatyFakturywgPanstw</DataSetName> <SeriesGroupings> <SeriesGrouping> <StaticSeries> <StaticMember> <Label>Value1</Label> </StaticMember> </StaticSeries> </SeriesGrouping> </SeriesGroupings> <PlotArea> <Style> <BackgroundColor>White</BackgroundColor> </Style> </PlotArea> <ValueAxis> <Axis> <Title /> <MajorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <Min>0</Min> <Max>=ReportItems!MAX.Value</Max> <Scalar>true</Scalar> </Axis> </ValueAxis> <ZIndex>7</ZIndex> <Type>Bar</Type> <Palette>Excel</Palette> <ChartData> <ChartSeries> <DataPoints> <DataPoint> <DataValues> <DataValue> <Value>=Fields!netto.Value</Value> </DataValue> </DataValues> <DataLabel> <Value>=Code.Formatuj(Fields!netto.Value)</Value> <Visible>true</Visible> </DataLabel> <Marker> <Size>6pt</Size> </Marker> </DataPoint> </DataPoints> </ChartSeries> </ChartData> <Style> <VerticalAlign>Middle</VerticalAlign> <BackgroundColor>White</BackgroundColor> </Style> </Chart> </ReportItems> </TableCell> </TableCells> <Height>0.63492cm</Height> </TableRow> </TableRows> </Header> <Grouping Name="table1_Group1"> <GroupExpressions> <GroupExpression>=Fields!kraj.Value</GroupExpression> </GroupExpressions> </Grouping> </TableGroup> </TableGroups> <Width>19cm</Width> <Header> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox1"> <rd:DefaultName>textbox1</rd:DefaultName> <ZIndex>15</ZIndex> <Style> <BorderStyle> <Bottom>Solid</Bottom> <Top>Solid</Top> <Left>Solid</Left> <Right>None</Right> </BorderStyle> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <BorderWidth> <Default>0.5pt</Default> </BorderWidth> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>9pt</FontSize> <VerticalAlign>Middle</VerticalAlign> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BackgroundColor>WhiteSmoke</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>KRAJ</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox2"> <rd:DefaultName>textbox2</rd:DefaultName> <ZIndex>14</ZIndex> <Style> <BorderStyle> <Bottom>Solid</Bottom> <Top>Solid</Top> <Left>None</Left> <Right>None</Right> </BorderStyle> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <BorderWidth> <Default>0.5pt</Default> </BorderWidth> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>9pt</FontSize> <VerticalAlign>Middle</VerticalAlign> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BackgroundColor>WhiteSmoke</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>ILOŚĆ</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox3"> <rd:DefaultName>textbox3</rd:DefaultName> <ZIndex>13</ZIndex> <Style> <BorderStyle> <Bottom>Solid</Bottom> <Top>Solid</Top> <Left>None</Left> <Right>Solid</Right> </BorderStyle> <TextAlign>Center</TextAlign> <PaddingLeft>2pt</PaddingLeft> <BorderWidth> <Default>0.5pt</Default> </BorderWidth> <PaddingBottom>2pt</PaddingBottom> <FontWeight>700</FontWeight> <FontSize>9pt</FontSize> <VerticalAlign>Middle</VerticalAlign> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BackgroundColor>WhiteSmoke</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>NETTO</Value> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.75cm</Height> </TableRow> </TableRows> </Header> <TableColumns> <TableColumn> <Width>3.5cm</Width> </TableColumn> <TableColumn> <Width>2.25cm</Width> </TableColumn> <TableColumn> <Width>13.25cm</Width> </TableColumn> </TableColumns> <Height>3.15476cm</Height> </Table> </ReportItems> <Height>11.61905cm</Height> </Body> <rd:ReportID>58bc7198-b2fa-4939-89e9-e74e3118e4d0</rd:ReportID> <LeftMargin>1cm</LeftMargin> <DataSets> <DataSet Name="wgDatyFakturywgPanstw"> <Query> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> <CommandText>SELECT b, kraj , SUM(NETTO) AS netto,COUNT(ILOSC) AS ilosc FROM ( SELECT ROUND(NETTO, 0) AS NETTO, 1 AS ILOSC, DATEPART(YEAR, dbo.REKLAMA.[FAKTURA DATA WYSTAWIENIA]) AS ROK, DATEPART(QUARTER, dbo.REKLAMA.[FAKTURA DATA WYSTAWIENIA]) AS KW, CONVERT(INTEGER,(1.0+DATEPART(QUARTER, dbo.REKLAMA.[FAKTURA DATA WYSTAWIENIA]))/2) AS ROK_PO, DATEPART(MONTH, dbo.REKLAMA.[FAKTURA DATA WYSTAWIENIA]) AS MS, DATEPART(Week, dbo.REKLAMA.[FAKTURA DATA WYSTAWIENIA]) AS WW, dbo.REKLAMA.[FAKTURA DATA WYSTAWIENIA], REKLAMA.TYTUŁ AS tytul, Agencje.Symbol as agencja, Agenci.Symbol as agent, dbo.REKLAMA.ZAPŁACONO, dbo.KLIENCI.Country as kraj, CASE dbo.KLIENCI.Country WHEN 'Polska' THEN 1 ELSE 0 END as b FROM dbo.AGENCJE INNER JOIN dbo.AGENCI ON dbo.AGENCJE.Id_agencji = dbo.AGENCI.ID_AGENCJI INNER JOIN dbo.REKLAMA ON dbo.AGENCI.Symbol = dbo.REKLAMA.[SYMBOL AKWIZYTORA] INNER JOIN dbo.Klienci on dbo.Klienci.CustomerId = dbo.Reklama.CustomerId WHERE (dbo.REKLAMA.TYP = 'PŁATNA' OR dbo.REKLAMA.TYP = 'BARTER') AND (dbo.REKLAMA.[ZATWIERDZONO DO DRUKU] = -1) AND (dbo.REKLAMA.[FAKTURA WYSTAWIONO] = 1) AND (DATEPART(YEAR, dbo.REKLAMA.[FAKTURA DATA WYSTAWIENIA]) >= @od) AND (DATEPART(YEAR, dbo.REKLAMA.[FAKTURA DATA WYSTAWIENIA]) <= @do) AND (@tytul is null OR REKLAMA.TYTUŁ = @tytul) AND (@agencja is null OR Agencje.id_agencji = @agencja) AND (@agent is null OR Agenci.ID_AGENTA = @agent) ) AS R GROUP BY kraj,b ORDER BY kraj</CommandText> <QueryParameters> <QueryParameter Name="@od"> <Value>=Parameters!od.Value</Value> </QueryParameter> <QueryParameter Name="@do"> <Value>=Parameters!do.Value</Value> </QueryParameter> <QueryParameter Name="@tytul"> <Value>=Parameters!tytul.Value</Value> </QueryParameter> <QueryParameter Name="@agencja"> <Value>=Parameters!agencja.Value</Value> </QueryParameter> <QueryParameter Name="@agent"> <Value>=Parameters!agent.Value</Value> </QueryParameter> </QueryParameters> <DataSourceName>BAZA_REKLAM</DataSourceName> </Query> <Fields> <Field Name="b"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>b</DataField> </Field> <Field Name="kraj"> <rd:TypeName>System.String</rd:TypeName> <DataField>kraj</DataField> </Field> <Field Name="netto"> <rd:TypeName>System.Double</rd:TypeName> <DataField>netto</DataField> </Field> <Field Name="ilosc"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>ilosc</DataField> </Field> </Fields> </DataSet> <DataSet Name="ListaAgencji"> <Query> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> <CommandText>SELECT Id_agencji, Symbol FROM AGENCJE where aktywna=1 union select NULL ,'Wszystkie' order by Symbol</CommandText> <DataSourceName>BAZA_REKLAM</DataSourceName> </Query> <Fields> <Field Name="Id_agencji"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>Id_agencji</DataField> </Field> <Field Name="Symbol"> <rd:TypeName>System.String</rd:TypeName> <DataField>Symbol</DataField> </Field> </Fields> </DataSet> <DataSet Name="ListaAgentow"> <Query> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> <CommandText>SELECT A.ID_AGENTA, A.Symbol, A2.Symbol agencja FROM AGENCI A left join Agencje A2 on A.ID_AGENCJI = A2.ID_Agencji where (A2.ID_Agencji in (@agencja)) and a.aktywny=1 union select NULL,'Wszyscy','costam' order by A.Symbol</CommandText> <QueryParameters> <QueryParameter Name="@agencja"> <Value>=Parameters!agencja.Value</Value> </QueryParameter> </QueryParameters> <DataSourceName>BAZA_REKLAM</DataSourceName> </Query> <Fields> <Field Name="ID_AGENTA"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>ID_AGENTA</DataField> </Field> <Field Name="Symbol"> <rd:TypeName>System.String</rd:TypeName> <DataField>Symbol</DataField> </Field> <Field Name="agencja"> <rd:TypeName>System.String</rd:TypeName> <DataField>agencja</DataField> </Field> </Fields> </DataSet> <DataSet Name="ListaTytulow"> <Query> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> <CommandText>SELECT SYMB as label, SYMB as value FROM [LISTA TYTUŁÓW] where st_aktywny = -1 union select 'Wszystkie',NULL</CommandText> <DataSourceName>BAZA_REKLAM</DataSourceName> </Query> <Fields> <Field Name="label"> <rd:TypeName>System.String</rd:TypeName> <DataField>label</DataField> </Field> <Field Name="value"> <rd:TypeName>System.String</rd:TypeName> <DataField>value</DataField> </Field> </Fields> </DataSet> <DataSet Name="ListaLat"> <Query> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> <CommandText>select distinct year(DATA_W) as rok from dbo.NR where DATA_W is not null order by year(DATA_W)desc</CommandText> <DataSourceName>BAZA_REKLAM</DataSourceName> </Query> <Fields> <Field Name="rok"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>rok</DataField> </Field> </Fields> </DataSet> </DataSets> <Code>Public Shared Function Formatuj(ByVal Value As Integer) As String Formatuj = Format(Value, "### ### ##0.## zł") End Function</Code> <Width>21cm</Width> <InteractiveHeight>29.7cm</InteractiveHeight> <Language>en-US</Language> <TopMargin>1cm</TopMargin> <PageHeight>21cm</PageHeight> </Report>