The Pro's and Cons of different approaches to connecting source data to a pivot table.

C

Chance1234

Hello,

Been reading through the posts and a few online tutorials and Im
trying to build a picture of what the pro's and cons of each different
approach.

I am designing an application that will be a pivot table on a asp page
with data coming from a SQL Server database.

As far as I can see it, there is

1. Use ADO
2. Use a dataset object and use a Dll and XLST to convert the dataset
to a ado rowset
3. Connect via a OLAP cube and use MDX
4. HTTP request
5. XML web service

I appreciate it is rather vague on what I am trying to do , but would
really like some thoughts and opinions, (of course including any i
have missed out)

With regards

Chance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Different rights to editing and for adding a text for online shared version of MS word 0
Excel 2007 pivot table using analysis services cube as data source 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Adding Heading to Table of Contents after a column break 1
how to databind pivot table 0
Retrieve member values for filters in OWC pivot table 0

Top