I need a simple, custom, extensible reporting module, plus approximately 12 predefined reports for a [url removed, login to view] application.
Report output will be in the form of an .html file.
Data source will be single database table from SQL server as follows:
Report definitions will be inside an .xml file
I need to be able to add new reports myself at a later date, by editing .xml file
Report definitions will include:
- name of report
- data fields to display plus friendly header names for data fields
- sql query
- any other info you need to get the report going
see attached for a mockup of how I see the report form looking.
On form load i need the .xml file to be read and the listbox to be populated with the report names.
On listbox click I need "summarize by" replaced by "sort by" depending on whether we are doing detail or summary report.
On button click I need the resultant report generated in the users default temp directory where it is then displayed in a browser or somethnig similar, maybe a [url removed, login to view] browser if this is possible
Inside the code of the form I need to be able to define the stylesheet for the resultant .html output, or alternatively you can include a separate .css file for use with the report.
All "filtering" combo boxes in "set other parameters" section should be dynamically populated from distinct values in corresponding database column and used to generate appropriate where clauses.
the "limit" combo box is used for a "top" clause in the sql statement
I'll give you a backup of the database I am using and if you can build this as a standalone [url removed, login to view] project, with one form, I will take the code and stick it into my application afterwards, please be mindful of this when you are building the form. I just want 1 form with all the code inside the form, no modules or anything with everything commented and laid out cleanly :)
please see attached for example of a couple of reports.
any questions please ask!
14 freelancers are bidding on average $144 for this job
Hi, it will be done by 7 working days. We belive in quality work with given period..!! We have 5+ years exp developers.!! Lets talk about it in detail.!!