Run Query Wizard - Select Excel Parameters

Top  Previous  Next  

 

The Run Query - Select Excel Parameters screen let you choose how your data will be placed into an Excel Spreadsheet.

 

clip0096

 

Workbook: If you have more than one Workbook open in Excel you can use this drop down combo box to select which workbook you wish your data to be placed into.

 

Include Field Names: Checking this box lets you choose whether to use the field names, you have given your fields in DataPA, as column headers in your spreadsheet.

 

Sub Totals Required: If you check this box you are given the option to select Sort Fields, and against each one choose a field to total by that Sort Field.  To do this, click on a Sort Field to highlight it and then using the 'Total By' combo box, select the field you wish to be totalled.

 

Start At Cell: This text box lets you decide the location of the first cell that you wish to populate in the worksheet.  The default is A1.

 

 


Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0