Below is a list of the custom control categories, expand each to see which controls
are available.
Charting & Graphing
[Show Controls (2)]
Detail Form Pie Chart data visualization Control
Highly flexible, attractive control that summarizes child data on a given detailed form; e.g. "Invoice Payment Status" on a Customer's detail page.
Can summarize both "counts" as well as perform standard Min/Max/Avg aggregations.
Supports a great deal of look-and-feel configuration in a similiar format to Dundas Charts or excel based charts; captions, colors, grouping etc.
Usage Graph Custom Page
A custom admin page displaying graphs on SQLDBI usage. Please read the documentation before using.
Child Grids & Multiselects
[Show Controls (1)]
Pivot Table: Value by Lookup
(BETA version) Requires SQLDBI 3.7. This is a configurable control that takes a specified child of the current object, two lookup fields from that child to serve as X and Y axes, and another field from the child to serve as the central value, and uses these to construct a pivot table. The table is editable, quick-editable, and optionally can show a modal detail form for the individual items when in display mode.
Column Replacement-Dates
[Show Controls (1)]
Outlook Calendar Event Importer
This control allows users to add events to a user's Outlook calendar when clicked based on information in the respective application object table. The control can be placed on detail forms and lists and currently supports the Subject, Location, Description, Organizer Email Address and Start/End Dates of the event. If there is a need for additional functionality, this control can easily be updated to include Attendees, All Day Event option, etc.
Column Replacement-Images & Documents
[Show Controls (1)]
Silverlight File Upload
More flexible and attractive alternative to the standard SQLDBI file upload, which can be somewhat tedious for systems that require a great deal of document management.
Column Replacement-Lookups
[Show Controls (1)]
Modal Lookup
Replace a lookup with a modal list selection box.
Make sure to only replace lookup columns with this control.
Column Replacement-Text
[Show Controls (1)]
Rich Text Editor
Provide a rich text editing interface for an App Column.
Mapping & GIS
[Show Controls (2)]
Bing Map Custom Object Menu (Sillverlight)
This control is rendered as a "globe" icon in the object menu. When clicked, it opens a high-quality Bing Map displaying all geo-codable points on the current list. Common uses would allow the visualization of client, project, staff, exercise, or inventory locations.
Silverlight Bing Map Lat/Long "picker"
This Silverlight control allows a user to manually geocode data using the Bing Maps service. Very helpful when identifying project, inventory, scientific data, or personal locations which may not necessarily be tied to a single address.
Object Menu Controls
[Show Controls (2)]
AppObject Importer
This is a BaseListFormNavigationBar control that allows a user to import data from an Excel (2000/2007) or .csv file. This control allows for both inserts and updates.
Full-Text Index Search Control (Google style search)
This is a control that supports full-text searching for character and document columns, both within a given record as well as in any "parent" or "child" data. Searchable documents include standard office documents as well as any text format or PDF's.
This control integrates directly with the underlying SQL Sever Full Text Search service and requires no additional special configuration.
Site Header Controls
[Show Controls (1)]
System wide Site Alert
This control gives allows authorized users to send targeted, broadcast messages to currently logged in users, analagous to an Instant Messaging application. The control also includes logging for each message sent through the site, and includes a easy-to-use log viewer.
UI options, Styles, and Graphics
[Show Controls (5)]
Detail Form Collapser
This control allows the user to nest "formlets" within a traditional SQLDBI detail form. While this provides an alternative to segregating data and UI across the nornal detail form tabs, it also has the advantage of being able to more flexibly hide sensitive data from unauthorized users.
Image Table
Displays images in a table form either from the database or from disk. Handles bulk downloading, uploading, and thumbnail generation.
ListForm Modal/Inline Detail Forms
A configurable custom control used to display detail forms from the object's list view. It may be configured to either open its detail form in a new row directly below the record being viewed, or in a modal popup.
Requires SQLDBI 3.7 (and this must be a recent build).
Tabbed Detail Form Section
This control allows users to add a set of tabbed content to a detail form, enchancing the form designer's ability to control layout and visibility. This is very similiar to a familair WinForms "panel" control.
User Comments
Displays and edits comments from a child table in a modal dialog. Can be used on a detail form, list view, or from inside another custom control.
Workflow
[Show Controls (1)]
Status Lookup Workflow Buttons
Similar to the StatusUpdateButton in that it maps to an object's parent status table. The difference being, instead of a button for each bit field on the current objects, there can be 1+ buttons for each status record in the lookup. Also includes some extra behavioral options.
*Other
[Show Controls (8)]
Coalesce Link
Hyperlink.
Takes in a set of lookup columns.
Returns the first non-null.
Provides navigation to the detail form.
CustomLookup
Displays a dropdownlist when in insert or edit mode that gets populated by a stored procedure. Basically it replaces a the custom lookup functionality on a relation, but there is no relation.
Detail Form Pager
This control can be placed on a detail form and provides buttons for paging to the next and previous records. The buttons are configurable in several ways. The order for paging is determined by the "current list".
Detail Form Wizard
This control allows you to select a set of detail forms to display in an explorer-style format, with navigation down the left-hand side, and content on the right. Next, Previous, and Save buttons are provided in the footer of the wizard. This control is intended to be used as the only control on a single standard detail form.
Generic Deltek Web Service Integration Control
This control directly integrates a SQLDBI site with a Deltek Costpoint system via the WebService integration utility. Handles both displaying Costpoint data with a SQLDBI application (pull) as well as submitting data from SQLDBI to Costpoint (push), Commonly used to extend core Costpoint functionality to more traditional SQLDBI "Line-of-business" applications
Status Update Button
This is basically an enhanced Stored Procedure Button, that includes additional options for controlling when the button should appear enabled/disabled/visible/hidden. It also provides an optional comment capability.
TreeView Display
Displays data in a tree format when placed on a table that has a lookup to itself
User Group Scope Editor
Allows for the configuration of groups within groups, but only to one level for now. This was a requirement for VSE in that there was one "main" level of groups with sub-groups. With this control you can configure the main group, and 1+ sub group for each main group record.