416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Hover Over a Data Grid Grouped or Subtotal Row

Hide navigation
RSS
Modified on Thu, 06 Sep 2012 11:45 AM Categorized as Data Grid, Script Library
Dundas Dashboard Script LibraryPrevious


Overview

This script shows how to detect when a user hovers over a grouped or subtotal row in a data grid. A subtotal row is basically a grouped row that shows subtotal values.

Script

Enter the the following script in a data grid Hover interaction. When a user hovers over a grouped or subtotal row, the script displays a message box which shows the name of the group and the value of the first field of the first data point under that group.

if ( e.VisualElementArgs != null && e.VisualElementArgs.DataSource != null ) { if ( e.VisualElementArgs.DataSource.ToString().Contains("CollectionViewGroup") ) { string groupName = e.VisualElementArgs.DataSource.Name; string columnValue = e.VisualElementArgs.DataSource.Items0.FieldValues0;

services.ShowMessage("group: " + groupName + ", column0: " + columnValue); } }


In the above code:

  • row.DataSource.Name returns the name of the group.
  • row.DataSource.Items returns the child groups or the child data points depending on the grouping level.

Hover over a subtotal row.

Hover over a subtotal row.


Related topics


About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.