Pivot Chart using in a ASP.Net Application

[sefer derya]

Hi newsgroup,

i want to create a website with Asp.net. I want present on this site a
dynamical Pivot chart, which get his datas from a MS SQL server. The are
a lot of datas in the database(at least 31.000.000 rows per year). I
could not make smaller the databse because the customer should view the
details (Year/Quarter/Month/Week/Day/Hour/Minute/Second=60*60*24*365=
31.536.000

If a customer uses the Pivot-chart(with drag and drop the fields),all
the asked datas will send from the Server to the Client to create the
new Pivot-Chart-image. But there is a high transfer.

The Question:
Is it possible, that the datas stay on the server and the server
creates the new image ?( send only the image do not send the whole
datas). But it should be a dynamical Pivot-Chart with the possibility to
drag and drop the fields.

regards from Germany
Sefer

 

[Alvin Bruney [MVP - ASP.NET]]

It is possible to create an in-memory pivot table on the server and push the
data out via HTMLData property. But you must be aware that this is not a gif
image. The actually contents are sent to the client and you will suffer the
same high bandwidth. It is not possible to send a gif image like that chart
component for instance.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc