• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3087
  • Last Modified:

How to build a Pivot Table in Visual Studio 2005

Hello,

I am using Visual Studio 2005 and I would like to build a Pivot Table on a web form.  I have a existing excel spreadsheet with drop down boxes that is setup similar to a pivot table.

Question: Is there a way to create a Pivot table form using visual studio or do I have to use Access 2007 and or Sharepoint Designer?

Thank you in advance,
0
cesemj
Asked:
cesemj
  • 3
  • 2
  • 2
1 Solution
 
PeterMillsUKCommented:
Do you have the Office Web Component available?
0
 
kdwoodCommented:
This is a very good article that gives use step by step directions and the download link for Office Web Components.

http://www.codeproject.com/aspnet/owc11article.asp
0
 
PeterMillsUKCommented:
Thank you - however we are trying to open an xls file which already exists - is this possible?
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
kdwoodCommented:
Peter,

I'm not sure I am understanding what you are trying to do with the existing xls file.

1.  Are you wishing to use that as your datasource?
2.  Or, are you wishing to embed a spreadsheet type viewer into your web page that will open the actual xls file?

Regards,

Keith  
0
 
cesemjAuthor Commented:
Thank you,

Sorry, I did not respond earlier, but I was at Barns & Noble reading books on asp.net 2.0 and Visual studio 2005 hoping that I can find information about a building pivot tables in VS 2005.  My quest did not turn out that well, but I will not give up.

I have OWC and have developed pivot tables using access 2003 for use over the web, but I was curious if I can do the same with Visual Studio 2005.  I am trying not to use OWC, because when I deploy the owc pivot table over the web, I have to make sure that each client has owc running on their host in order to view the page and also make sure that each client web settings are configured properly.  

Moreover, I notice that Visual Studio 2005 has a datagrid control that is similar to an excel spread sheet, but I am not sure if the row headings can be converted to drop down boxes that will let you filter/sort.  If you know a way please let me know.

Thank you,
0
 
kdwoodCommented:

You could probably use a datagrid but there would be a ton of customization in order to get it to behave like a true pivot table.   I'm not sure if you have a little money to spend, but this third party control looks really good and not very expensive.

http://www.devexpress.com/Products/NET/WebForms/ASPxPivotGrid/

There are also other ASP.NET Pivot Table Controls that you can google.  Most of them are much more money than the one above.

Regards,

Keith
0
 
cesemjAuthor Commented:
Thank you all,
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now