Form widget with 1 header Row and multiple columns below the header row

[su2 <sh...@pexsupply.com>]

Hello Friends,

I need to design a Form widget where there is a 1 Header column(Order State)
and 6 columns below the header column.

For Example.

*********************************************

Order State = NY
--------------------------------------------
OrderNo | OrderAmount | OrderDate | and more

*********************************************

I made a Form with "type = list" and created columns(OrderNo, OrderAmount
etc). Columns are filled with query result. Now the Order State(the header)
should also be filled based on the query result.

I have made query with "group by" so I am getting all NY results together,
CA results together and so forth. But I am not sure how to split them and
have a header -NY for all NY orders and CA for all CA orders (Number of
states depends on the date range selected for the report. Always it is not
all states.)

Following is my form i created with columns
 

***************************************************************
<form name="ListReport" type="list" 
        title="Reprots"  target="" list-name="ordersListIt">
       
        <field name="OTCMOrderNo" title="${uiLabelMap.CrmOrderNameID}"
widget-style="linktext"
            use-when="(isLookup==void) || (isLookup==null) ||
!(isLookup.equals(&quot;true&quot;))">            
            <hyperlink also-hidden="false" target-type="plain"
description="(${OTCMOrderNo})"
target="https://www.pexsupply.com/crmsfa/control/orderview?orderId=${OTCMOrderNo}"/>
        </field>
        
        <field name="OTCMOrderSubTotal"
title="${uiLabelMap.FinancialsSalesAmount}">               
          <display
description="${bsh:com.opensourcestrategies.financials.reports.ReportHelper.getOrderSubTotal(delegator,
OTCMOrderNo)}"/> 
        </field>
        <field name="OTCDate" title="${uiLabelMap.FinancialsDate}">
            <display/>
        </field>
    </form>
***************************************************************

I really appreciate the help.

Thanks in advance.

Su-




-- 
View this message in context: http://www.nabble.com/Form-widget-with-1-header-Row-and-multiple-columns-below-the-header-row-tp25703584p25703584.html
Sent from the OFBiz - User mailing list archive at Nabble.com.