Tools for Excel: Views

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: 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.