reporting tool

Question

hi,


the main purpose of the the system is to provide a solution for designing reports, based on input data (blocks). As a final result, the system stores created template for further generation.
1) The INPUT data for the system is a list of pre-configured "blocks" - including SQL statements of each participating tables and columns (Primary Key, JOINS). 
The database of configuration part (template tables, containing these blocks) is on my responsibility - I provide tables structure and testing data for your development 
2) 
The system must present pre-configured blocks in convenient way ( as hierarchical tree, separated by Data Module / Data Category / Data columns  ), with sort and search abilities. 
The system also must support 
- choosing report data presentation styles ( grid, forms, crosstab, chart )
- adding blocks, group levels with Drag & Drop operation
- data retrieval conditions, user-defined parameters, data group & sort order
- column totals and sub-totals
- sub-reports ( drilldown )
- visual style ( width, colors, fonts )
- a report title, defines top and bottom texts
- report access level options (Public/Private, R/O)
- storing and loading historical versions of changes
- Internationalization
3) The OUTPUT of the system are the designed templates, stored as 
     a) set of definitions in template tables, 
     b) XML in JasperReports open source format, using the following features : 
o  Parameters
o  Data Source
o  Fields
o  Expressions
o  Variables
o  Report Sections
o  Frames
o  Groups
o  Fonts and Unicode Support
o  Styles
o  Scriptlets
o  Subreports
o  Internationalization
o  Datasets
o  Charts
o  Crosstabs
the Report Generation part is also on my responsibility, I need only stored templates and XML in JesperReports format
var vglnk = { api_url: '//api.viglink.com/api', key: 'a187ca0f52aa99eb8b5c172d5d93c05b' };