Difference between revisions of "What is global reporting?"
(Bulk update) |
Katy Kitchen (talk | contribs) |
||
| Line 1: | Line 1: | ||
== Summary == | == Summary == | ||
| − | Global Reports allow access to | + | Global Reports allow access to module Report Generators from various locations within Platinum. Information such as Customer, Supplier and Stock Codes can be picked up by a Global Report to give information about the current item being viewed. |
| − | + | Environment Variables within a page allow the system to detect specific pieces of information and pass them on to the report you are running e.g. within a Unit Record you could produce a customised profit report without having to type in the unit number. | |
== More Information == | == More Information == | ||
Revision as of 07:45, 27 October 2023
Contents
Summary
Global Reports allow access to module Report Generators from various locations within Platinum. Information such as Customer, Supplier and Stock Codes can be picked up by a Global Report to give information about the current item being viewed.
Environment Variables within a page allow the system to detect specific pieces of information and pass them on to the report you are running e.g. within a Unit Record you could produce a customised profit report without having to type in the unit number.
More Information
Configuration
Report Filter
- Go into the " Report Generator" and create a new report, setting the Sort Order and Column Details as usual.
- In the "Report Filters" press <Shift+F6> on the first line to turn it into a formula line.
- Use the '$ENV' function to access global variable.
- E.g.
S01 = $ENV{"S01ST"}would set the report to only give stock details for the stock code in the "Global Variable"'S01ST'.
- E.g.
- Enter any other filters on the remaining lines.
- Save the report.
Report Assignment
- Go to the accept which you want to link the report to.
- Click on " Reports Global Reporting."
- Click [Add].
- Select the relevant module.
- Press <Enter> to list the reports.
- Highlight the report and click [Choose].
- Click [Close].
Copying to another Location
 | Each global report is tied to a particular location in Platinum. When you click on the "Global Reports" option in the "Reports" menu it will say "Current Location:" and displays the location at the top of the box. If you move to another field and look again you will this will change. |
To add a report to another location, move onto the relevant accept the go into the Global reports option. Find the report in the list then press [Copy]. It will then be linked to that location too.
Run the Report
To run the report, click on "Reports" on the menu bar. If there is only one report linked to this field it will be shown at the top of the list. If there are other reports you may need to click on "Global Reporting" to find your report then press [Start].
 | Pressing <Alt+B> will run the first global report assigned to this accept. |
Available Variables
These Global Variables allow your Global Report to drill down to the information that is currently being display. In the "Sales Ordering" where you enter both customer and stock codes, 'S01ST' would be available for the stock code and 'A02RP' would be available for the customer code.
Go to the field where you want to be able to access a report.
- Click on " Reports Available Variables."
- The variables available to you will be listed along with there description and current value to help you identify which variable to use in your report filter.
Further Details
These variables can used anywhere a report generator function can be used. E.g. Report Columns.
- Use the
$ENV{}function to access the value of the Global Variable in your report (see above).
See also
