How do I send my reports to excel please. The option is 'greyed out' at the top
thank you
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
sending reports to excel
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: sending reports to excel
There are two format you can use to export reports to be suitable for use in Excel.
The first is to export to excel format, this sounds great, but it is not that useful as it makes an excel worksheet that "looks" like the report, so it has headers, footer and the data is not that easy to use, because there are page breaks and gaps.
The second is to export to csv format, this doesn't look like the report, but it is the raw data from the report (you may also get some rolling sums that you don't see in the report) which is generally more useful for manipulation.
--------------
But better than sending data form a report into excel is to pull data from the sage database table directly into excel because you can hit refresh and get the latest data in seconds instead of mucking about running reports, exporting to excel, cutting and pasting and having to re-do the same thing each time.
The first is to export to excel format, this sounds great, but it is not that useful as it makes an excel worksheet that "looks" like the report, so it has headers, footer and the data is not that easy to use, because there are page breaks and gaps.
The second is to export to csv format, this doesn't look like the report, but it is the raw data from the report (you may also get some rolling sums that you don't see in the report) which is generally more useful for manipulation.
--------------
But better than sending data form a report into excel is to pull data from the sage database table directly into excel because you can hit refresh and get the latest data in seconds instead of mucking about running reports, exporting to excel, cutting and pasting and having to re-do the same thing each time.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 2 guests