Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
reports:introduction [2020/04/24 12:23] – lou | reports:introduction [2023/04/04 14:03] (current) – [Header and footer] Gary Willetts | ||
---|---|---|---|
Line 47: | Line 47: | ||
=== Header and footer === | === Header and footer === | ||
- | You can choose what information will be displayed at the top and bottom of each page. The default report heading is set according to the report you are printing. By default, the date will print on the left and the page number on the top right of each page. | + | You can choose what information will be displayed at the top and bottom of each page. The default report heading |
If you have filled in a default header and footer in the Preferences, | If you have filled in a default header and footer in the Preferences, | ||
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, | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | ==== Supervisor mode (reporting over mutiple stores) ==== | ||
+ | If you wish to report over mutiple stores at once, you can be given permission to use Supervisor mode. When you are in this mode, report filter windows will have an additional store list added ot the window so that you can choose which stores' | ||
+ | |||
+ | See the [[other_stuff: | ||
+ | |||
\\ | \\ | ||
Line 59: | Line 85: | ||
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||