Hyperlink in pivot table

[Animator]

you guys have any example where in i could set a pivot table item with
hyper links? im using owc pivot table that is embeded in an aspx file.

 

[Brian Hman]

Are you looking to put the hyperlink into the pivot table? If so I just
figured out you can do that (someone correct me if I'm wrong) and that's why
I'm trying to use the spreadsheet component instead.

Brian Hman

 

[Alvin Bruney [Microsoft MVP]]

The Black Book has an example of this on p. 422. Basically, you would use
the pivothyperlink object to insert a hyperlink into the row axis.

roughly:

ptable.rowaxis.insertfieldset("home",null,false)
pview.fieldset("homelink").fields("home").ishyperlink = true

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc