Zbiór zmian 222 dla trunk/RaportySQL/RankingKlientow2009.rdl
- Data:
- 2009-01-20 21:55:04 (17 years ago)
- Pliki:
-
- 1 zmodyfikowane
-
trunk/RaportySQL/RankingKlientow2009.rdl (zmodyfikowane) (11 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/RaportySQL/RankingKlientow2009.rdl
r185 r222 76 76 <rd:TypeName>System.Decimal</rd:TypeName> 77 77 </Field> 78 <Field Name="ILOSC">79 <DataField>ILOSC</DataField>80 <rd:TypeName>System.Int32</rd:TypeName>81 </Field>82 78 <Field Name="symbol"> 83 79 <DataField>Symbol</DataField> … … 111 107 <Query> 112 108 <DataSourceName>BAZA_REKLAM</DataSourceName> 113 <CommandText>SELECT K.FirstName, K.LastName, CONVERT(money, SUM(FD. NETTO)) AS WARTOSC, COUNT(DISTINCT FD.reklamaId) AS ILOSC, A1.Symbol,114 YEAR(F.DATA_WYSTAWIENIA) AS rok,A2.Symbol AS agencja109 <CommandText>SELECT K.FirstName, K.LastName, CONVERT(money, SUM(FD.netto)) AS WARTOSC, A1.Symbol, YEAR(F.DATA_WYSTAWIENIA) AS rok, 110 A2.Symbol AS agencja 115 111 FROM FAKTURY AS F LEFT OUTER JOIN 116 FAKTURA_DETAILS AS FD ON F.ID_FAKTURY = FD.ID_FAKTURYLEFT OUTER JOIN112 VIEW_BRUTTO_PO_KOREKTACH AS FD ON F.ID_FAKTURY = FD.id_faktury LEFT OUTER JOIN 117 113 KLIENCI AS K ON F.ID_NABYWCY = K.CustomerID INNER JOIN 118 114 AGENCI AS A1 ON F.NUMER_ROZ = A1.F_ROZ INNER JOIN … … 120 116 WHERE (F.NUMER_ROZ <> 'POZ') AND (F.NUMER_ROZ <> 'KAT') AND (YEAR(F.DATA_WYSTAWIENIA) > 2008) 121 117 GROUP BY K.FirstName, K.LastName, A1.Symbol, YEAR(F.DATA_WYSTAWIENIA), A2.Symbol 122 ORDER BY CONVERT(money, SUM(FD. NETTO)) DESC</CommandText>118 ORDER BY CONVERT(money, SUM(FD.netto)) DESC</CommandText> 123 119 </Query> 124 120 </DataSet> … … 216 212 <PaddingBottom>2pt</PaddingBottom> 217 213 </Style> 218 <ZIndex> 5</ZIndex>214 <ZIndex>4</ZIndex> 219 215 <CanGrow>true</CanGrow> 220 216 <Value>=Fields!FirstName.Value</Value> … … 244 240 <PaddingBottom>2pt</PaddingBottom> 245 241 </Style> 246 <ZIndex> 4</ZIndex>242 <ZIndex>3</ZIndex> 247 243 <CanGrow>true</CanGrow> 248 244 <Value>=Fields!Lastname.Value</Value> … … 274 270 <Language>pl</Language> 275 271 </Style> 276 <ZIndex> 3</ZIndex>272 <ZIndex>2</ZIndex> 277 273 <CanGrow>true</CanGrow> 278 274 <Value>=Fields!WARTOSC.Value</Value> 279 </Textbox>280 </ReportItems>281 </TableCell>282 <TableCell>283 <ReportItems>284 <Textbox Name="ILOSC">285 <rd:DefaultName>ILOSC</rd:DefaultName>286 <Style>287 <BorderColor>288 <Default>LightGrey</Default>289 </BorderColor>290 <BorderStyle>291 <Default>Solid</Default>292 </BorderStyle>293 <BorderWidth>294 <Default>0.5pt</Default>295 </BorderWidth>296 <FontSize>8pt</FontSize>297 <TextAlign>Center</TextAlign>298 <VerticalAlign>Middle</VerticalAlign>299 <PaddingLeft>2pt</PaddingLeft>300 <PaddingRight>2pt</PaddingRight>301 <PaddingTop>2pt</PaddingTop>302 <PaddingBottom>2pt</PaddingBottom>303 </Style>304 <ZIndex>2</ZIndex>305 <CanGrow>true</CanGrow>306 <Value>=Fields!ILOSC.Value</Value>307 275 </Textbox> 308 276 </ReportItems> … … 396 364 <PaddingBottom>2pt</PaddingBottom> 397 365 </Style> 398 <ZIndex> 10</ZIndex>366 <ZIndex>8</ZIndex> 399 367 <CanGrow>true</CanGrow> 400 368 <Value>KLIENT</Value> … … 426 394 <PaddingBottom>2pt</PaddingBottom> 427 395 </Style> 428 <ZIndex> 9</ZIndex>396 <ZIndex>7</ZIndex> 429 397 <CanGrow>true</CanGrow> 430 398 <Value>WARTOÅÄ</Value> 431 </Textbox>432 </ReportItems>433 </TableCell>434 <TableCell>435 <ReportItems>436 <Textbox Name="textbox11">437 <rd:DefaultName>textbox11</rd:DefaultName>438 <Style>439 <BackgroundColor>WhiteSmoke</BackgroundColor>440 <BorderColor>441 <Default>LightGrey</Default>442 </BorderColor>443 <BorderStyle>444 <Default>Solid</Default>445 </BorderStyle>446 <BorderWidth>447 <Default>0.5pt</Default>448 </BorderWidth>449 <FontSize>8pt</FontSize>450 <FontWeight>700</FontWeight>451 <TextAlign>Center</TextAlign>452 <VerticalAlign>Middle</VerticalAlign>453 <PaddingLeft>2pt</PaddingLeft>454 <PaddingRight>2pt</PaddingRight>455 <PaddingTop>2pt</PaddingTop>456 <PaddingBottom>2pt</PaddingBottom>457 </Style>458 <ZIndex>8</ZIndex>459 <CanGrow>true</CanGrow>460 <Value>ILOÅÄ</Value>461 399 </Textbox> 462 400 </ReportItems> … … 486 424 <PaddingBottom>2pt</PaddingBottom> 487 425 </Style> 488 <ZIndex> 7</ZIndex>426 <ZIndex>6</ZIndex> 489 427 <CanGrow>true</CanGrow> 490 428 <Value>AGENT</Value> … … 516 454 <PaddingBottom>2pt</PaddingBottom> 517 455 </Style> 518 <ZIndex> 6</ZIndex>456 <ZIndex>5</ZIndex> 519 457 <CanGrow>true</CanGrow> 520 458 <Value>AGENCJA</Value> … … 529 467 <TableColumns> 530 468 <TableColumn> 531 <Width> 4cm</Width>469 <Width>5cm</Width> 532 470 </TableColumn> 533 471 <TableColumn> 534 <Width> 3.75cm</Width>472 <Width>4.5cm</Width> 535 473 </TableColumn> 536 474 <TableColumn> 537 <Width>2.5cm</Width> 538 </TableColumn> 539 <TableColumn> 540 <Width>2.5cm</Width> 475 <Width>3.25cm</Width> 541 476 </TableColumn> 542 477 <TableColumn>
