Blog

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Wednesday, May 1, 2013PrintSubscribe
Tools for Excel: Data Fields

This is a typical view of data fields in a project.

Typical view of data fields in the project.

Consult the following table when entering property values:

Property Description
Aggregate

Specify an Aggregate that will be displayed at the bottom of grid views.

Alias The Alias is the field value that will be displayed to the user. The header text will be inherited from the alias field label.
Auto Complete Prefix Length Specify an Auto Complete Minimum Prefix Length greater than 1 to enable auto-complete on the data field.
Category The category that this data field belongs to.
Chart If the view is a chart, specify a Chart property that the data field will function as.
Code Filter Specify an operator for the Code Filter to determine how records will be restricted from being displayed.
Controller The controller that this data field belongs to.
Columns Columns determines the width of the data field. If the field is a radio button list or check box list, this will determine the number of columns.
Data Format String Specify a Data Format String to format the field value before it is presented to the user.
Field Name The name of the field that is instantiated.
Footer Text Displayed under the field in the form.
Filter Expression Write a Filter Expression in the programming language of your project. Code Filter must be specified.
Format On Client If Format On Client is disabled, the server will format the field using the specified data format string.
Header Text Replaces the name of the field in the form.
Hidden Enable to hide the field from the user interface.
Hyperlink Format String The Hyperlink Format String allows formatting the field as a link. Specify an absolute or relative (starting with ~) URL that may include field names enclosed in curly brackets. You can place _blank or any other standard window name followed by colon symbol in front of the URL.
Read Only If Read Only is enabled, the data field will not be editable in the user interface.
Read Only When Read-Only When is a JavaScript expression that will enable editing on the data field when it evaluates to true.
Rows Rows determines the height of the data field or list box.
Search Mode The Search Mode property will control the behavior of the data field in the advanced search bar.
Search Options Search Options represent the options available for searching the field in the advanced search bar. You can limit or reorder the search options. Search options must be compatible with the data type of the field. Separate options with "," or list one option per line. Examples: $contains, =, $between, >, $future.
Tag Use the Tag property to define enhanced business purpose of the data field.
Text Mode

Text Mode will determine how the text box is rendered. Password will render the field value as asterisks. Rich Text will enable rich text editing on the field value. Note allows easy editing of long field values. Static will display the field as read-only, but still send the field value to the server.

Tool Tip Tool Tip is displayed when user mouses over the input box or text.
View The view that this data field belongs to.
Visible When Visible When is a JavaScript expression that will display the data field when it evaluates to true.
Wednesday, May 1, 2013PrintSubscribe
Tools for Excel: Categories

This is a typical view of categories in a project.

Typical view of categories in a project.

Consult the following table when entering property values:

Property Description
Collapsed Will render the category as collapsed by default if set to Yes.
Controller The controller that the categories’ view belongs to.
Description The text displayed under the header.
Floating You can force the category data fields to float from left to right by setting Floating to Yes.
Header Text The text displayed at the top of the category.
ID The unique identifier of the category.
New Column If attribute New Column is set to Yes then the category is rendered in the new column.
Tab Specifying the tab will display a bar of tabs above the view and will make the category visible only when the tab is selected.
View The view that the category belongs to.
Visibility Enter a JavaScript expression in Visibility field to allow conditional display of the category. The expression must evaluate as true if the category is visible. Use square brackets to reference the data field values in the expression.
Wednesday, May 1, 2013PrintSubscribe
Tools for Excel: Views

This is a typical screen displaying views in a project.

Typical screen displaying views in a project.

Consult the following table when entering property values:

Property Description
Base View Id Specify a Base View Id to inherit its data fields, categories, description, and label.
Command Specifies the command that will be used to select data.
Controller Specifies the controller that the view belongs to.
Filter Expression Filter Expression must be compatible with the back-end database server syntax. Data field names used in filter are automatically expanded into appropriate SQL expressions as defined in command.
Group Enter any non-blank value in Group property to make sure that filters selected in a view are transferred to the other views in the same group when a user selects them in view selector.
Header Text Specifies the text displayed above the view in the user interface.
ID Specifies the unique identifier of the view.
Label Specifies the text displayed in the view selector dropdown.
Report Font

Property Report Font will determine the size of text for the data and labels in the report. The default value is Medium.

Report Label

Specify a Report Label that must print when a view report is produced in PDF, Excel, TIFF, or Word format. If the property left blank then the view label will be printed.

Report Orientation Set Report Orientation to "Portrait" or "Landscape" or let the application to decide what is best.
Report Template Indicate if a custom report template file must be created for this view. The report in RDLC format can be customized in Visual Studio or Visual Web Developer. The file name will be formatted as [Controller]_[ViewId].rdlc.
Override When Override When is an expression that evaluates to true or false. It is written in the programming language of your project.
Show in Selector If disabled, the view will not be displayed in the view selector dropdown.
Sort Expression Sort Expression is a list of data field names of this view, each followed by optional asc or desc suffix.
Type Type determines the presentation style. Available types include form, grid, chart, or data sheet.
Virtual View ID The specifiedVirtual View ID will replace the current view when the condition in Override When is met.