Reporting Tool

[Guest]

Hi

My users, use ms access for querying and reporting on a backend database,
however they need to replace ms access with a new reporting tool.

I’m thinking of developing my own reporting engine in C# to replace the
existing ms access model.

Are there any c# reporting application samples that I could look at to get
started?

I had a quick look at Crystal Reports, but feel this is to complex for my
users unless there is a more friendly front-end to it, and it can somehow be
wrapped into a C# application, is this possible?

Basically I’m looking for a simple c# querying and reporting tool that is
self contained and can be shared – any ideas?

Thanks

 

[Guest]

Try
http://www.asp.net/StarterKits/DownloadReports.aspx?tabindex=0&tabid=1


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

 

[Samuel R. Neff]

Why do you have to get rid of Access? One thing we did with an
application when a user required custom reporting is provide an Access
reporting front end to the application that used web services to
download selected data to the local system which they can then run
custom reports and queries on. We even denomalized the data to make
their reporting easier.

The users were very happy with the solution and never bothered us for
new reports.

HTH,

Sam

 

[Guest]

Hi Samuel. Many thanks for the advice.

My problem with Access is that the users can't open and modify the same
query/report at the same time. I've sort of got around this by allowing the
users to have a local access db and using the unsupported functiions
SaveAsText and LoadFromText. If the user creates a new query/report, they can
then share this if required. We are finding this very unstable hence the
reason for looking for a rewrite.

Your solution sound very interesting. Do you have any pointers where I
should start?
We would like to keep the access query/report designer and wizards if we can
as the users are used to these tools. Once they create a new query could this
be saved as xml so other users could view and modify? Not sure if a web
reporting front-end is possible on top of access?