Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision | ||
reports:introduction [2021/04/26 14:34] – Gary Willetts | reports:introduction [2021/07/02 00:40] – [Output to Excel] Mark Glover | ||
---|---|---|---|
Line 53: | Line 53: | ||
=== Preview on screen before printing === | === Preview on screen before printing === | ||
This option turns on print preview. Note that you can also turn on print preview from the print window that is displayed after you click the OK button. | This option turns on print preview. Note that you can also turn on print preview from the print window that is displayed after you click the OK button. | ||
+ | |||
+ | |||
+ | ==== Output to Excel ==== | ||
+ | Most reports can be output to an Excel file. This is particularly helpful if you are wanting to analyse a large amount of data. | ||
+ | |||
+ | As at July 2021, there are three methods of producing Excel reports from mSupply: | ||
+ | * **Quick reports** - Easiest to create, fastest to run, but least flexible in terms of formatting. | ||
+ | * **SRP reports** - More powerful than Quick reports | ||
+ | * **XL Plugin reports** - Most powerful in terms of formatting, but slowest in terms of operation. | ||
+ | |||
+ | <WRAP center round info 60%> | ||
+ | Sometimes new, more powerful versions of existing reports have been created using the XL Plugin specifically for the purpose of analysis using pivot tables and filters. | ||
+ | </ | ||
+ | <WRAP center round tip 60%> | ||
+ | |||
+ | Reports produced for Excel will sometimes not have the data formatted correctly, particularly, | ||
+ | </ | ||
+ | |||
+ | |||