Extracts generated from Reports: Difference between revisions
Jump to navigation
Jump to search
(Created page with '== The idea == * we should reduce the number of ways of calculating data in OpenPetra. ** creating reports and creating extracts is quite similar. Find screens might also fall in…') |
No edit summary |
||
| Line 9: | Line 9: | ||
* We could have the option to create a report/extract not from xml file, but from a C# function | * We could have the option to create a report/extract not from xml file, but from a C# function | ||
** perhaps loading a file from csharp\ICT\Petra\Server\sql | ** perhaps loading a file from csharp\ICT\Petra\Server\sql | ||
== Implementation == | |||
=== client side === | |||
* a normal yaml file for a report, with parameter tabs etc | |||
** perhaps a special button: generate extract, to avoid a report result screen to be displayed. | |||
** referencing either an .xml file for creating the report in xmlfiles, or the name of a dll and the static function to be called for calculating the data. Or using glue code? | |||
=== server side === | |||
* new way of calculating a report: a C# function that does all the collecting of data | |||
** complex sql statements can be stored in an external SQL file to increase readability (see csharp\ICT\Petra\Server\sql) | |||
** returns a TResultList similar to what the calculation of xml files did return | |||
Revision as of 07:17, 19 December 2011
The idea
- we should reduce the number of ways of calculating data in OpenPetra.
- creating reports and creating extracts is quite similar. Find screens might also fall into this category.
- the reports system needs a refactoring
- some functions used in report module are needed by other modules as well
- We could have extracts as an output method from reports (use the column with the partner keys to create an extract)
- We could have the option to create a report/extract not from xml file, but from a C# function
- perhaps loading a file from csharp\ICT\Petra\Server\sql
Implementation
client side
- a normal yaml file for a report, with parameter tabs etc
- perhaps a special button: generate extract, to avoid a report result screen to be displayed.
- referencing either an .xml file for creating the report in xmlfiles, or the name of a dll and the static function to be called for calculating the data. Or using glue code?
server side
- new way of calculating a report: a C# function that does all the collecting of data
- complex sql statements can be stored in an external SQL file to increase readability (see csharp\ICT\Petra\Server\sql)
- returns a TResultList similar to what the calculation of xml files did return