Field Name:
Based On Column:
<% if(isSQLBased) { %>
>--- None ---
<% int iCount = 0;
List reportCols = rdef.getAllColumns();
for(Iterator iter=reportCols.iterator(); iter.hasNext(); iCount++) {
DataColumnType dct = (DataColumnType) iter.next(); %>
><%= dct.getDisplayName() %>
<% if(currColId.equals(dct.getColId()))
colDisplayName = dct.getDisplayName();
} // for
%>
<% } // else if(isSQLBased)
if(colDisplayName!=null) { %>
<% } // if
%>
<% if(isSQLBased) {
String colType = AppConstants.CT_CHAR;
if(colTableName!=null&&colColumnName!=null)
try {
colType = nvl(DataCache.getReportTableDbColumnType(colTableName, colColumnName,((String) session.getAttribute("remoteDB"))), AppConstants.CT_CHAR);
} catch(Exception e) {}
String[] fmt;
if(colType.equals(AppConstants.CT_DATE))
fmt = dateFormats;
else
fmt = charFormats; %>
Display Format:
<% for(int i=0; i
"<%= (nvl(colDisplayFormat).toUpperCase().equals(fmt[i].toUpperCase()))?" selected":"" %>><%= fmt[i] %>
<% } %>
<% } // if
%>
Visible?
>Yes
>No
<% if(Globals.getAllowSQLBasedReports() || AppUtils.isAdminUser(request)) { %>
Is used in Group By Clause?
<% } %>
Field Type:
<% String curValue = nvl((currField!=null)?currField.getFieldType():"", FormField.FFT_TEXT_W_POPUP); %>
<%-->Text Box with Popup --%>
>Text Box
<%-- >Text Area--%>
<%-- >Drop-Down List--%>
>List Box
<%-- >Radio Buttons
>Check Boxes --%>
>Multi-select List Box
>Hidden
Visible Size:
>1
>2
>3
>4
>5
>6
>7
>8
>9
>10
Custom
<% if(currField!=null && isNumber(nvl(currField.getMultiSelectListSize())) && new Integer(nvl(currField.getMultiSelectListSize(), "0")).intValue() <= 20) {
%>
<%=nvl(currField.getMultiSelectListSize())%>
<%
}
%>
<%if(! isSQLBased) { %>
Default Value:
<% } else { %>
<% if(Globals.getAllowSQLBasedReports() || AppUtils.isAdminUser(request)) { %>
Is Default Value should be SQL
Default SQL:
<% if(Globals.getAllowSQLBasedReports() || AppUtils.isAdminUser(request)) { %>
<% } %>
<% } // if admin user %>
Default Value:
<% if(Globals.getAllowSQLBasedReports() || AppUtils.isAdminUser(request)) { %>
<% } %>
<% } //else %>
Verify Field Value As:
<% curValue = nvl((currField!=null)?currField.getValidationType():"", FormField.VT_NONE); %>
>--- Do Not Perform Validation ---
>Date
>TimeStamp (Hour)
>TimeStamp (Hour, Min)
>TimeStamp (Hour, Min, Sec)
>Integer
>Positive Integer
>Positive Integer, Cannot Be Zero
>Any Number
>Positive Number
>Positive Number, Cannot Be Zero
<%}else{%>style="display:none"<%}%>>
<% curValue = nvl((currField!=null)?currField.getMandatory():"", "N"); %>
User must provide value for this field
Field Help Text:
<% if(Globals.getAllowSQLBasedReports()||AppUtils.isAdminUser(request)) { %>
SQL Generating Custom List of Values:
<% curValue = nvl((currField!=null)?currField.getDependsOn():"", "N"); %>
Depends on another Form Field.
<% } else { %>
Provide Predefined List of Values:
<% if(predefinedValues==null||predefinedValues.size()==0) { %>
Do not use Predefined list - Generate list from database
<% } else {
String value = (String) predefinedValues.get(0); %>
<%= value %>
<% if(predefinedValues!=null&&predefinedValues.size()>1)
for(int i=1; i
<%= value %>
<% } // for
%>
 %>shareicon.gif){kind=small}
<% } else { %>
<% } // else if(isSQLBased)
if(colDisplayName!=null) { %>
<% } // if
%>
 %>calender_icon.gif){kind=icon}