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

sending reports to excel

Bookkeeping and Management Accounting help does not have to be specific to the use of Sage 50
Post Reply
emmac
User
User
Posts: 11
Joined: 27 Aug 2013, 07:26
Sage Version: v2012 18 UK/Europe/Africa

sending reports to excel

Post by emmac » 23 Sep 2013, 14:13

How do I send my reports to excel please. The option is 'greyed out' at the top :(

thank you

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: sending reports to excel

Post by brucedenney » 23 Sep 2013, 15:39

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.
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.

Post Reply

Who is online

Users browsing this forum: No registered users and 9 guests