actually i have allready tried to bind pivot chart with the sql.......and it
is suucessful as long as i use "select * from tablename" but whenever i use
the where clause......it returns nothing....secondly i want to make my pivot
chart operations fast ......so inorder to do so...... i have to use tp use
the stored procedure which i am unable to use bcaz i dun't know how to use
it.........so plz help me in this regard...........
BR
Omar_aa

"Ed Ferrero" wrote:

Hi Omar_aa,

i am writing a program in vb.net that uses pivotchart with backend sql
server........i.e.the data is fed into the pivot chart through a query
from
the sql server........now i want to use my stored porcedure to populate
my
pivot chart........is there anyways that i will be able to use stored
procedure to populate that pivot chart...........is there anyone who can
guide me in this regard..
Best Regards
Omar_aa

I don't know how to update an Excel Pivot Chart using a stored procedure. I
doubt that there is a SQL command to get Excel to update a Pivot Chart .

Of course you can use vb.net to open the Excel workbook and update the pivot
chart. Just use the RefreshTable of the PivotTable object in Excel.

However, what I normally do is set the Pivot Chart options in Excel to
update data on file open. Then you just need to open the workbook and the
data will update automatically.

Ed Ferrero
www.edferrero.com