Project Summary
To Develop a Designer for Generating Reports from A Data Base Server With or Without Parameters.
Key Words
Report Designer, Reports, HTML Reports, Entity Relationship Diagram, Enterprise Resource Planning, Low Code, Code Automator, SDLC, Software Development Life Cycle
Introduction
Data Reporting Happens to be an Important Part of any Application. Although These Days most Applications Aim at Descision Support Systems at Various Levels Still Reporting Happens to be a Mandatory Especially at Government Departments. Hence Report Designer is a Tool that Helps a Developer to Quickly Configure the Reports.
Origin Of Proposal
These days an kind of a minimum accepted requirements of Application Software Demands that it should be Online that is it must be Web Based. Often we find delays in Choosing the Right Reporting Tool as Usually It is not a Common Addendum with a Standard IDE.
Problem Definition
Not Many Ready Tools are Available on a Database Server that Will Allow an User To Integrate them Seamlessly with the Front End. We are Planning to Have an Integrated and Amalgmated Solution to Solve the Problem from the Database to the Front End on the Web without an Extra Liscence as far as possible.
Work plan
The Idea is to allow the Developer to Access the Table or a Stored Procedure with or without Parameters that will give A Direct or a Derived or a Calculated Data Field as Output That Needs to be Interpreted without Repetitions in Different Sections of a Report.
Project Information
Review and Status of Research and Development in the Subject
Project Features / Product Catalog
Point the Data Source
- It is Important to First Point Out the Data Source.
Choose Data Access Type
- Specify weather you will be Gathering the Data From a Table or a Stored Procedure Or Some Other Source that Can Be Read.
Choose Page
- Next Step is to Choose a Standard Page Size and Layout of the Page On the Printer.
Configure
- From this point Onwards we are Planning to Automate the Process of Defining the Parameters Along With the Data Types that Need to be Assigned to the Data Fields that the Database Server Returns after Executing the Query Till they are Configured with Respective Headers and Fields That Need to be Printed in the Report.
Near Future Mandatory Necessary Enhancements Planned
1. Connectivity to a preferred DB Server.
2. A Diagramming Support with preferred pointers to the Underlying Columns Returned.
3. A report Previewer.
Sample Entity Relationship Diagram
Sample Entity Relationship Diagram
Time Schedule of Work Plan
| Sl No | Broad Work Element | Time Estimates In Months |
| 1 | A way to get Data Access Objects that need to be Assigned to the Column Names Returned by the Query from Database. | 2 |
| 2 | A Simple Visualiser to Get All the Data Fields, Names and their Data Types. | 3 |
| 3 | A Drag and Drop Attachment to Place the Fields on the Report Designer. | 2 |
| 4 | A Previewer to See Some Sample Data on the Report Preferably. | 3 |
| 5 | Processed information can then be Acutually Printed on Different Printers. | 2 |
Minimum Group Organisation
| Sl No | Group Code | Position Description | No Of Posts |
| 1 | 1 | Testing Administrator | 1 |
| 2 | 2 | Assistant DB Architect | 4 |
| 3 | 3 | Internal User Interface Administrator | 1 |
| 4 | 4 | Data Mapper Administrator | 2 |
| 5 | 5 | Process Experts | 2 |
| 6 | 6 | Programmers | 10 |
| 7 | 7 | Accountants | 1 |
| 8 | 8 | Process Designers | 2 |
| 9 | 9 | Internal Marketing Administrator | 1 |
| 10 | 10 | Internal Project Manager | 1 |
Suggested plan of action for utilization of Research Outcome Expected from the project
We are planning to Tie Up with Ramakrishna Mission Vivekananda Educational and Research Institute http://rkmvu.ac.in/ so that they can maintain the Entire Design, Source Code and Related Documentation necessary for it to Survive and Grow or Tie up with Microsoft Corporation / Microsoft Foundation so that A Team can be formed to Ensure that these Services and Upgrades are available to All Organisations in India freely to Develop and Enhance but not to Voilate the Set Statuatory and Predefined Standards.
Budget Estimates: Summary
| Item | BUDGET | (in Rupees) | |||
| 1st Year | 2nd Year | 3rd Year | Total | ||
| A. | Recurring | ||||
| Salary Expenses | 67500000 | 74250000 | 81675000 | 223425000 | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 | |
| Travelling Expenses | 2400000 | 2640000 | 2904000 | 7944000 | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 | |
| B. | Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
| Grand Total (A+B) | 72600000 | 79860000 | 87846000 | 240306000 |
Budget for Salaries/Wages
| Position Description | No Of Posts | Monthly Emoluments | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |||
| Testing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Assistant DB Architect | 4 | 250000 | 12000000 | 13200000 | 14520000 | 39720000 |
| Internal User Interface Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Data Mapper Administrator | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Process Experts | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Programmers | 10 | 200000 | 24000000 | 26400000 | 29040000 | 79440000 |
| Accountants | 1 | 125000 | 1500000 | 1650000 | 1815000 | 4965000 |
| Process Designers | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Internal Marketing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Internal Project Manager | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Totals | 67500000 | 74250000 | 81675000 | 223425000 |
Budget for Consumable Materials
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 |
Budget for Travelling Expences
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Travelling Expenses | 2400000 | 2640000 | 3630000 | 8670000 |
Budget for Other Expenditures
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 |
Budget for Equipment If Applicable
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
Infrastructural Facilities
| SrNo | Infrastructural Facility | Status |
| 1 | Workshop Facility | Yes – Sharing basis |
| 2 | Water & Electricity | Yes - Sharing basis |
| 3 | Laboratory Space/ Furniture | Yes - Sharing basis |
| 4 | Power Generator | No |
| 5 | AC Room or AC | No |
| 6 | Air Cooler If Tempratures are too High | Yes |
| 7 | Telecommunication including e-mail & fax | Yes |
| 8 | Transportation | Yes |
| 9 | Administrative/ Secretarial support | Yes – Sharing Basis |
| 10 | Information facilities like Internet/ Library | Yes – Sharing Basis |
| 11 | Computational facilities | Yes – Sharing Basis |
| 12 | Animal/ Glass House | No |
| 13 | Any other special facility being provided | Not Required |
Equipment available with the Institute/ Group/ Department/ Other Institutes for the project
| Sl No | Equipment Available | Generic Name Of Equipment | Qty Available | Model Make And Year Of Purchase | Remarks Including Accessories Available And Current Usage Of Equipment |
| 1 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 2 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 3 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
