Re: Reporting Tool

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?



"Samuel R. Neff" wrote:

>
> 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
>
>
> On Wed, 11 May 2005 08:01:06 -0700, jez123456
> <jez123456@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >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
>
>
.

Relevant Pages