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' };