Exporting to Excel from Crystal

Exporting to Excel from Crystal


Exporting to Excel from Crystal


INTRODUCTION

The reports that are generated from Agility can be exported to excel by doing the following steps.


When the report is open look to the far left where the following screen is seen and next to printer on the select this.


The following screen will open.


Under format select the drop down












And choose Microsoft Excel 97-2000 – Data only


This will then ignore the formatting of the report


















Select OK here


Now choose where the file is to be saved



    • Related Articles

    • Exporting Grids

      Exporting Grids in Agility Throughout Agility there are grids which display information which can then be exported into excel. When the Export Grid button is selected  the following message boxes appear: Select YES Select Yes - This gives you the ...
    • Supplier Global Pricing

      There are two different ways to change prices in Agility Pro on mass: 1 - Supplier Global Pricing - By Percentage Allows you to increase or decrease the price by a percentage for all stock assigned to a supplier. The update can do buy and sale price, ...
    • Stock - Stock Requirements

      INTRODUCTION Agility Professional has the feature that begins to calculate stock which is being sold and therefore provides information for ordering stock levels. Best practice is to start with a small supplier as there a number of things that need ...
    • EPOS - Show Receipts

      INTRODUCTION When a customer has given a payment and it has been put the the till then these can be seen afterwards by going to the till and select Receipts - Show Receipts SHOW RECEIPTS This screen is then open with following search criteria: Date ...
    • Festool Export - Manual

      Festool Export - Manual Introduction In this article, I will be demonstrating how to export a PO manually to send to Festool via their Emailing client. This method may be temporary while we push the development for the automated integration ...