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' };
Loading
megha bhagatPosted Oct 3, 2013, 4:56 AM
Here is the main concept of the project:
It is a reporting software tool for corporate users. The software is installed as an addition tool,
and connects to existing corporate databases (RDBMS).
The application allows to end-users to create easily their own reports from simple pre-configured blocks
( Like kids building their own constructions from "Lego" blocks ).
1st version is planned to work on Windows platform (PC and tablets) as GUI application.
Web application is also can be considered, depending on complexity of work
The application itself also has it's own database storage for configuration and logging.
See attached file with main flow of the application.
( little bit more details about steps in the app )
==========================================
1) CONFIGURATION. Pre-configuration is a role of application administrator. He learns corporate database structure and configure tables, columns and relations between them as "Lego" blocks ). He actually assigns plain names and icons to physical tables and columns.
2) TEMPLATE EDITOR. When end-users (accountants, managers, supervisors, etc) wants to create a report, they can see a list of these available blocks. They choose needed blocks and put them together in a report template. The blocks can be placed in appropriate order, style, size etc. The template also has parameters for retrieving data (period, list of entities etc.), and some other options for report generation.
3) REPORT GENERATOR. After design of template is ready, it stored in local database 1) in dedicated tables, 2) as open-source JasperReports format.
Each template can be launched manually, or scheduled on specific hour,
to generate the report and display results it on a screen, or stored as file (HTML, PDF, XLS), or send by email.
megha bhagatPosted Oct 3, 2013, 4:53 AM
The purpose of the project is to create a reporting tool, which is friendly and effective for corporate users.
need to developed this application as early as possible . please guide me
Posted Oct 3, 2013, 4:34 AM
Can you please explain more? Do you want develop an app for the above mentioned ?