Reporting Tool

[test]

Dear Members

Our company has developed a software for edutcational institution. we have used vb and MSAccess as front and backend for our software. We have active Report for our reporting. We would like to develop a reporting tool which can be implemented in our product. The reporting tool should be such that the end user must able to create new report and modify, delete existing report. Please advice me in this regard.

Thanks in advance
Regards
Devdas

 

[MichaelRed]

test,

I am not clear on the environment you are describing. Is vb the front end, w/ Ms. Access the back end? If so, I am not aware of any 'easy' way to implement user reports, for generation or modification.

My VB app has a really crude report generator, which allows user generation and modification of 'reports'. It requires several forms and over fifty procedures. Even with this ammount of support, users are restricted to pre-definde relationships between tables, which are hard-coded into the app. It also uses a large table which is specific to the apps tables, to "map" the user selected fields to the tables and fileds off the datasets. I did not write the thing, and am not at liberty to provide it even as a sample, however I am charged with the maintenance and can assure you that this is not a trivial undertaking. The original 'author' assured me that 'he' (translate to he - AND his team of 5) took over a month to develop this monster.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[subhavs]

Have you tried Crystal Reports ? It is very easy for users to learn and use this tool.

- Subha

 

[swilliams]

I worked on a tool called View2000 (supplied by DataTrue -

http://www.DataTrue.com)

which was basically a report generator. In simple terms, it put a nice UI to Access queries.

As MichaelRed said, there were limitations (such as the maximum number of fields on a report), and it took a long time to build (by a very qualified guru of a developer).
But the app was developed in such a way that it was completely configurable as to what data could be reported on.

I also am not at liberty to divulge how it worked, but it did use crystal reports.

subhavs,

I disagree with your comment about Crystal Reports being very easy to learn and use. It is very easy to fudge your way through to get to a point where you have a report produced, but to learn and use competently takes quite a while.

Simon

 

[EscapeUK]

I use crystal a lot and its not bad