Changeset 547 for trunk/web-app

Timestamp:

May 26, 2010, 3:50:50 AM (15 years ago)

Author:

gav

Message:

Improvements to Inventory Stock Take reports, MSSQL does not like using distinct the way it was, also improved protection against too many results.

File:

• trunk/web-app/reports/stockTakeByLocation.jrxml (modified) (2 diffs)

trunk/web-app/reports/stockTakeByLocation.jrxml

@@ -85 +85 @@
         <field name="inventoryItemCount" class="java.lang.Integer"/>
         <field name="locations" class="java.lang.String"/>
+        <field name="countWarning" class="java.lang.String"/>
         <background>
                 <band splitType="Stretch"/>
@@ -105 +106 @@
                                 <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"/>
                                 <textFieldExpression class="java.lang.String"><![CDATA["Inventory Items: "+$F{inventoryItemCount}+", Locations: "+$F{locations}+"."]]></textFieldExpression>
+                        </textField>
+                        <textField>
+                                <reportElement mode="Opaque" x="400" y="4" width="382" height="46" isPrintWhenDetailOverflows="true" forecolor="#FF0000" backcolor="#FFCCCC">
+                                        <printWhenExpression><![CDATA[$F{countWarning} != null ? true:false]]></printWhenExpression>
+                                </reportElement>
+                                <textElement textAlignment="Center" verticalAlignment="Middle">
+                                        <font size="12" isBold="true"/>
+                                </textElement>
+                                <textFieldExpression class="java.lang.String"><![CDATA[$F{countWarning}]]></textFieldExpression>
                         </textField>
                 </band>