Zbiór zmian 596 dla trunk/RaportySQL/Zaleglosci2009.rdl

Data:

2009-04-21 13:24:31 (17 years ago)

Autor:

marek

Opis:

re #129

Pliki:

• trunk/RaportySQL/Zaleglosci2009.rdl (zmodyfikowane) (3 diffs)

trunk/RaportySQL/Zaleglosci2009.rdl

@@ -165 +165 @@
         <Field Name="brutto">
           <DataField>brutto</DataField>
-          <rd:TypeName>System.Decimal</rd:TypeName>
+          <rd:TypeName>System.Double</rd:TypeName>
         </Field>
         <Field Name="suma_zaplat">
@@ -224 +224 @@
 SUM(brutto) AS brutto, 
 SUM(wplata_brutto) AS suma_zaplat, 
-Sum(zalega) AS zalega, 
+CAST(Sum(zalega) AS DECIMAL(9)) AS zalega, 
 SUM(waluta_brutto) AS brutto_waluta, 
 SUM(wplata_brutto_waluta) AS suma_zaplat_waluta, 
@@ -245 +245 @@
 wplaty.brutto AS wplata_brutto, 
 wplaty.waluta_brutto AS wplata_brutto_waluta, 
-V1.brutto - wplaty.brutto AS zalega, 
+ROUND(V1.brutto - wplaty.brutto, 0) AS zalega, 
 V1.waluta_brutto - wplaty.waluta_brutto  as zalega_waluta,
 dbo.AGENCJE.Symbol AS Agencja