Hi there!
I need a simple, custom, extensible reporting module, plus approximately 12 predefined reports for a VB.net application.
Report output will be in the form of an .html file.
Data source will be single database table from SQL server as follows:
[VisitorId]
[VisitorName]
[VisitorOrganisation]
[VisitorEmail]
[Visiting]
[VisitingEmail]
[VisitorType]
[ReasonForVisit]
[TimestampIn]
[TimestampOut]
[TimestampPreReg]
[PreRegVisitDate]
[PreRegID]
[Region]
[Site]
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 vb.net 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 VB.net 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!
I am a professional Software Engineer having 6 years experience for a company in .net. I have understood the requirements clearly also we can set css separately thus it will be good for maintenance.
This work is easy but as I have to do it carefully I need some time to finish (1 or 2 days is impossible to do this :-) ), if you like my bid please let me know, have a good day
Hi,
We are having more than 10 years of experience on Microsoft technology. We completely understand your requirement and will deliver assignment within given time frame. We are ready to start immediatly. Looking for positive response from your side.
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.!!