Ribbon Bar

Trouble viewing images? Click on images to enlarge.

 

The Ribbon Bar provides access to the various menu items within the VDM Platform

Ribbon Display Options

 

Available Options:

• Auto-hide Ribbon: Hides the Ribbon. Click at the top of the application to show.
• Show Tabs: Shows the Ribbon tabs only. Click a tab to show the commands.
• Show Tabs and Commands: Shows Ribbon tabs and commands all the time.

 

Database Ribbon

• New: Launches the Connection Wizard to create a new Connection Profile.
• Load All: Loads all Connection Profiles into Tables and Fields.
• Edit: Launches the Connection Wizard to edit and existing Connection Profile.
• Manage View Connections: Allows views with multiple Connection Profiles to mapped to other Connection Profiles.

 

Home Ribbon

• New: Create a new View.
• Open: Open an existing View.
• Save: Save the View that is currently open.
• Save As: Save the View that is currently opened with a new name.
• Save with Data: Save the View file and embed the View’s data.
• Save Encrypted: Saves the View in an encrypted format so it cannot be accessed by anyone outside your organization and cannot be read/edited within a text editor.
• Recent: Displays recently opened Views.
• Run View: Runs the View that is currently open.
• Dashboards: Launches Dashboards allowing for multiple View’s charting information to be displayed onto single panel.
• Finished Reports: Launches Finished Reports, a professional report writing feature.
• Visualize Designer: Launches Visualize Designer, a profession data visualization feature.
• Auto Scheduler: Launches the Auto Scheduler setup used to schedule Views to run at user defined intervals, dates and times.
• Master Job: Launches the Master Job editor for creating batches of Views to run in queue and on demand.
• Enable Scheduler: Turns on the Auto Scheduler processes and scheduler queue.
• Abort Search: Aborts a View that is currently being executed.
• ProView (Legacy): Launches ProView an SSRS based reporting feature.  This feature has been deprecated and is no longer supported.

 

View Options Ribbon

• Client Side Grouping: Applied at the View Level
  • Enabled: The View’s Grouping and Summaries items are aggregated in-app (on the local PC) and not on the database.
  • Disabled: the View’s Grouping and Summary items will be sent to the database for evaluation and processing.
• Client Side Sorting: Applied at the View Level
  • Enabled: The View’s Sorting items are performed in-app (on the local PC) and not on the database.
  • Disabled: The View’s Sorting items will be sent to the database for evaluation and processing.
• Select Distinct: Applied at the View Level
  • Enabled: VDM will only return unique rows of data and will ignore any duplicates.  For a row of data to be unique EVERY field in a given row would need to be an exact match of another.
  • Disabled: VDM will return all data delivered from the database for the current View.
• Summary Only: Applied at the View Level
  • Enabled: VDM will not deliver the Views detail data and will only return aggregated data to the Summary grid.  Enabling this feature will disable Client Side grouping.
  • Disabled: VDM will deliver the Views detail data as well as any aggregated data that is defined at the Group and Summary levels.
• View SQL Query: Displays the SQL query, based on the View’s configuration, that VDM is sending to the database.
• Select Top Records: Adds Top X syntax to the SQL query, limiting the number of records returned (not supported with all databases).
• Database Functions: Features for specific databases.
  • Native SQL - This makes it so VDM can leverage "native" SQL features that are not accessible in Universe otherwise.
• Use Table Alias: Allows a table alias defined inside the Linking to be used in the query in place of the actual table name.
• Embed Expressions: Applied at the View Level
  • Embedded Expressions allows an Expression, used within a View, to be saved and stored in the VDM View file. This greatly simplifies the sharing of Views, containing expressions, with your colleagues.
• Replace Numeric Nulls: Applied at the View Level
  • Enabled: VDM will replace null values with a numeric data type with 0.
  • Disabled: VDM will return null values for numeric data types.
• Expandable Excel Groups: Applied at the View Level
  • Enabled: VDM will show expandable grouping when a data grid is exported to Excel.
  • Disabled: VDM will not show expandable grouping when a data grid is exported to Excel.
• Default Control: Defines the default control that will receive focus once the View has returned results.
• Skins: Changes the look and feel of VDM.

 

Export/Print Ribbon

• Export To (No Preview): Exports the data directly to the selected output without a preview.
• Export To (Preview): Exports the data to VDM’s export preview feature.
• Standard Export Options: Legacy export features, Export To Preview and No Preview are recommended.
  • All (Multi-Sheet): Exports the Details, Summary, Basic Chart and Totals to a multi-sheet Excel document.
  • Details: Exports the Details to an Excel document.
  • Summary: Exports the Summary to an Excel document.
  • Chart: Exports the Basic Chart to an Image File (jpg).
  • Wip Lists by Desk: Used for Columbia Ultimate TCS and ManageMed platforms running on Universe only.  Creates a WIP list for each desk’s data being displayed in the View.  Please note that the export location defined in the VDM List option, under the Options menu, is used for this feature.

 Community Ribbon

• Forum: Direct link to the BridgeWorks forum. A place for Report Writers and Developers to share their ideas, techniques and ask questions.
• News: Get the latest updates on VDM.

 

Help Ribbon

• About: Shows the current version of VDM.
• Register: Used to register VDM’s installation and license for the workstation.
• Support: Launches the VDM support website.
• Auto Updater: Launches VDM’s automated update/upgrade processes and is used to keep your VDM installation current.