Exporting data from Export/Spreadsheets (non query)
v7,v6
Create Export Template
- Go to Reports -> Export Spreadsheets
- Click Add New and then Yes to design new Report
- Fill in Report Properties
- Name: As required. E.g. Sales Export
- Category: Billing
- Printer: Reports1
- Tablelink: Set table link as required
- Use Following Tables: Tick as required
- One Entry Per: Set as required
- Shared: Set to Yes
- Leave other setting as defaults
- Save and Exit.
Running the Export
- Go to Reports -> Export Spreadsheets
- Select Category you have saved export under
- Double click Export Name. E.g. Sales Export
- The filters page will open. Select filters as required, eg. Bill Date Range
- Click Next and Details for Export File will open
- Fill in Export Settings. Depending on preference on combo can be used but standard setting are;
- Fieldnames in File: Tick
- Surrounds fields with: Double Quote
- Separate Fields with: Comma
- Click Export and choose location and filename. Usually best to save to the desktop.
- If using Vetlink on cloud you can then copy csv file to your local computer to open file in excel.
- The export contains all columns so just delete what you don't need.
- Remember to save as a xlsx file if you do any formatting or formula's.