Trouble viewing images? Click on images to enlarge.
An Un-joined Dataset will return one Datatable for each Detail and/or Summary result from the selected Views. Datasets are useful when you need to combine disparate views into a single data source for Finished Reports or Visualize. Users often build a Dataset when they want to combine multiple Views into a single Excel workbook where each View is a separate spreadsheet.
To create a VoV DataSet click on the VoV Builder tab on the navigation bar.
1. VoV Build DataSet
First, select BuildDataSet from from the VoVOption property.
2. Add Views
Next, click on Add View to browse and select your View. Repeat the Add View process for each View.
3. Save and run VoV
Click Save on the Ribbon Bar to save your VoV Dataset.
To run the VoV, click on View from the Navigation Bar. Click Open, select the VoV and then click Run View to execute.
View1.vdm has the following report fields:
View4.vdm has the following report fields:
When VoV_Dataset.vdmv is executed, View1.vdm and View2.vdm are run against the defined connection, and the details from each View is added to their own datatable in the dataset.