VoV Single Summary

Tony Coffman -

Trouble viewing images? Click on images to enlarge.

 

VoV - Single Summary

A Single Summary VoV will return one record for each grouped item in your Views.  For example if you have two Views and each are grouped by a date, the VoV Single Summary will return one line from each View for every unique date, as well as the summary items. 

Building a Single Summary View requires that your Views have the same number of groupings, data types and order.  It is also required that the number of grouping levels be the same for each View. 

Please note that VoV Single Summary does not work with Advanced Queries.

To create a VoV Single Summary View click on the VoV Builder tab in the navigation bar:

mceclip1.png

 

Select the “SingleSummary” from the VoV Property Grid. 

mceclip2.png


Next, click on Add View to browse and select your View.  Repeat the Add View process for each View that shares a similar grouping information.

mceclip3.png


Click Save on the Ribbon Bar to save your VoV Single Summary.

To run the VoV, click on View from the Navigation Bar.  Click Open, select the VoV and then click Run View to execute.

 

Example:

View1.vdm has a single level of grouping on a date field with a count and summary.

mceclip1.png

 

View4.vdm also has a single level of grouping on a date field with a count and sum. 

mceclip0.png

 

When VoV1.vdmv is executed, View1.vdm and View4.vdm are run against the defined connection, and the summary from each View is combined on the grouped item. 

In the example below we can see View1 and View4's summary data is combined into a single row where they share the same grouped date.

mceclip4.png

Have more questions? Submit a request

Comments