Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Gitteng Data from SQL server (SP) Pivot query and Display it oN Excel sheet Using Pivot table and pivot chart

Posted on 2005-04-27
Medium Priority
Last Modified: 2008-02-26
Hi , I want to bring a data from SQl server stored procedure , the data should be presented as (Cross tab) report on the excel sheet ,the rows and the columns for this report is dynamic , Is this Coding possible ? How I pass the parameters to the (SP) and bring it to the excel sheet?

I need C# that do this function?
Question by:mubama0n
  • 2
LVL 18

Accepted Solution

testn earned 1000 total points
ID: 13874910

Author Comment

ID: 13892397
Ok , I have the stored procedure query (cross tab) but What about the code that send this data into excel sheet , I mean If you open an excel sheet then choose from the menu (Data --> choosing pivot table and pivot chart report) then going through the wizard , how I do by code sending the data from the (SP) to excel sheet?

Author Comment

ID: 13942846
The Solution Is not completed enough , I'll give you the mark for bringing a crosstab data , but bring it to the excel sheet you didn't provide any thing about it.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question