reports:introduction

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
reports:introduction [2021/07/02 00:22] – [Output to Excel] Mark Gloverreports: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 appears in the right hand //Heading// field and is automatically set according to the report you are printing: you can edit this as required and what is entered in this field is what will be printed as the report title. By default, the date will print on the left and the page number on the top right of each page.
  
 If you have filled in a default header and footer in the Preferences, these will be displayed at the top left (for the header) and the bottom centre (for the footer) If you have filled in a default header and footer in the Preferences, these will be displayed at the top left (for the header) and the bottom centre (for the footer)
Line 63: Line 63:
   * **XL Plugin reports** - Most powerful in terms of formatting, but slowest in terms of operation.   * **XL Plugin reports** - Most powerful in terms of formatting, but slowest in terms of operation.
  
-<WRAP center round tip 60%>+<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.  We have not wanted to delete the older reports, so we have kept them, and named the new report with **[Excel]** in the title. 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.  We have not wanted to delete the older reports, so we have kept them, and named the new report with **[Excel]** in the title.
 </WRAP> </WRAP>
 +<WRAP center round tip 60%>
 +
 +Reports produced for Excel will sometimes not have the data formatted correctly, particularly, dates - refer to [[https://superuser.com/questions/817110/unable-to-get-excel-to-recognise-date-in-column|this]].
 +</WRAP>
 +
 +
  
  
Line 71: Line 77:
 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' records are to be included in the report. 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' records are to be included in the report.
  
-See the [[other_stuff:misc_topics#supervisor_mode_-_all_stores|25.01. Miscellaneous topics]] page for details.+See the [[other_stuff:misc_topics#supervisor_mode_-_all_stores|25.01. Miscellaneous topics: Supervisor mode - all stores]] page for details.
  
  
  • Last modified: 2021/07/02 00:22
  • by Mark Glover