Problem on reports

Hi, I have an asp application running on a dozen of winXP machines
configured as kiosks. This application stores its data on a MS access db. I
have the need to make some reports extracting data from the db, displaying
them on screen and exporting to rtf.
I've tried several commercial products, like Crystal Reports, Active Reports
and others, but one is difficult to integrate in asp, another requires an
expensive license for each machine (not acceptable for me), considering each
machine as a website/domain.
Some requires additional tools, like Visual Basic, but this could be
acceptable.
I have also found some tools that allow to easily display datagrids from the
db, but they are too simple, for example I could easily build a page that
showed the result of a simple select, but I couldn't find a way to aggregate
data in a more complex way (I need to make reports where some data for the
header come from 1 or more tables, and data for the core of the report come
from multiple tables with the ability to have subreports).
Anybody knows a tool to solve this problem in an efficient way?
Thank you a lot

Il Khan

Re: Problem on reports

"Il Khan" wrote in message
..news:427721c9$0$20690$5fc30a8@news.tiscali.it...
> Hi, I have an asp application running on a dozen of winXP machines
> configured as kiosks. This application stores its data on a MS access db.
> I
> have the need to make some reports extracting data from the db, displaying
> them on screen and exporting to rtf.
> I've tried several commercial products, like Crystal Reports, Active
> Reports
> and others, but one is difficult to integrate in asp, another requires an
> expensive license for each machine (not acceptable for me), considering
> each
> machine as a website/domain.
> Some requires additional tools, like Visual Basic, but this could be
> acceptable.
> I have also found some tools that allow to easily display datagrids from
> the
> db, but they are too simple, for example I could easily build a page that
> showed the result of a simple select, but I couldn't find a way to
> aggregate
> data in a more complex way (I need to make reports where some data for the
> header come from 1 or more tables, and data for the core of the report
> come
> from multiple tables with the ability to have subreports).
> Anybody knows a tool to solve this problem in an efficient way?
> Thank you a lot
>
> Il Khan
>


Yes. Devise your queries in asp and write the results out using hand-crafted
html. You can even do horizontal bar graphs using simple tags

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook

Re: Problem on reports

Il Khan wrote on 03 mei 2005 in microsoft.public.inetserver.asp.db:
> Hi, I have an asp application running on a dozen of winXP machines
> configured as kiosks.
> ...

Already answered elswere.

Do not multipost !!!!!

Learn Netiquette and then SQL.

--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)