Changeset 547 for trunk/web-app


Ignore:
Timestamp:
May 26, 2010, 3:50:50 AM (14 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:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/web-app/reports/stockTakeByLocation.jrxml

    r546 r547  
    8585        <field name="inventoryItemCount" class="java.lang.Integer"/>
    8686        <field name="locations" class="java.lang.String"/>
     87        <field name="countWarning" class="java.lang.String"/>
    8788        <background>
    8889                <band splitType="Stretch"/>
     
    105106                                <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"/>
    106107                                <textFieldExpression class="java.lang.String"><![CDATA["Inventory Items: "+$F{inventoryItemCount}+", Locations: "+$F{locations}+"."]]></textFieldExpression>
     108                        </textField>
     109                        <textField>
     110                                <reportElement mode="Opaque" x="400" y="4" width="382" height="46" isPrintWhenDetailOverflows="true" forecolor="#FF0000" backcolor="#FFCCCC">
     111                                        <printWhenExpression><![CDATA[$F{countWarning} != null ? true:false]]></printWhenExpression>
     112                                </reportElement>
     113                                <textElement textAlignment="Center" verticalAlignment="Middle">
     114                                        <font size="12" isBold="true"/>
     115                                </textElement>
     116                                <textFieldExpression class="java.lang.String"><![CDATA[$F{countWarning}]]></textFieldExpression>
    107117                        </textField>
    108118                </band>
Note: See TracChangeset for help on using the changeset viewer.