Hyperlink in pivot table

[Jean]

Hello,

I have a object to create a pivot table in a html page to display data in a
pivot format. My code is:

<OBJECT CLASSID=clsid:0002E552-0000-0000-C000-000000000046 id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress = "top", I got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object should be for
Hyperlink.Subaddress?


Thanks a lot!

 

[Alvin Bruney [MVP]]

the fields object collection does not contain a hyperlink address property
which is why you are getting an exception. You will need to use an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the pivot table list
object hierarchy.

 

[Jean]

Thanks for your reply. Now I knew that the fields object doesn't have
hyperlink address property. So I got this object hierarchy by checking the
document from MS.

Pivot.ActiveData.RowAxis.RowMember.ChildRowMembers(0).Hyperlink.Address="http://www.yahoo.com"

However I still got error. I could not find any help or example from
microsoft site. If you can list the object for Hyperlink.Address, that will
be a big help.

In fact I want to assign one data field as a hyperlink in a pivot table and
the link will open a new IE window to display a web site. It looks like it
only can open a new window in win 2000 computers, but it could not open a new
window in XP computers. So I want to use .Hyperlink.Subaddress = "blank" to
open a new window.

Thanks for you help!

the fields object collection does not contain a hyperlink address property
which is why you are getting an exception. You will need to use an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the pivot table list
object hierarchy.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hello,

I have a object to create a pivot table in a html page to display data in
a
pivot format. My code is:

<OBJECT CLAS xSID=clsid:0002E552-0000-0000-C000-000000000046 id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress = "top", I
got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object should be for
Hyperlink.Subaddress?


Thanks a lot!

 

[Alvin Bruney [MVP]]

I'm having the same error as you. I do not know what is going. Maybe someone
with more knowledge can figure this out. Sorry

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Thanks for your reply. Now I knew that the fields object doesn't have
hyperlink address property. So I got this object hierarchy by checking the
document from MS.

Pivot.ActiveData.RowAxis.RowMember.ChildRowMembers(0).Hyperlink.Address="http://www.yahoo.com"

However I still got error. I could not find any help or example from
microsoft site. If you can list the object for Hyperlink.Address, that
will
be a big help.

In fact I want to assign one data field as a hyperlink in a pivot table
and
the link will open a new IE window to display a web site. It looks like
it
only can open a new window in win 2000 computers, but it could not open a
new
window in XP computers. So I want to use .Hyperlink.Subaddress = "blank"
to
open a new window.

Thanks for you help!

the fields object collection does not contain a hyperlink address
property
which is why you are getting an exception. You will need to use an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the pivot table
list
object hierarchy.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hello,

I have a object to create a pivot table in a html page to display data
in
a
pivot format. My code is:

<OBJECT CLAS xSID=clsid:0002E552-0000-0000-C000-000000000046 id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress = "top",
I
got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object should be
for
Hyperlink.Subaddress?


Thanks a lot!

 

[Alvin Bruney [MVP]]

Jean

FYI:

I didn't exactly give up on this.

I'm beginning to think it is broken functionality. Unless someone from MS
takes this up, I'll continue to dig around and then open a trouble ticket to
get to the bottom of this.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

I'm having the same error as you. I do not know what is going. Maybe
someone with more knowledge can figure this out. Sorry

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Thanks for your reply. Now I knew that the fields object doesn't have
hyperlink address property. So I got this object hierarchy by checking
the
document from MS.

Pivot.ActiveData.RowAxis.RowMember.ChildRowMembers(0).Hyperlink.Address="http://www.yahoo.com"

However I still got error. I could not find any help or example from
microsoft site. If you can list the object for Hyperlink.Address, that
will
be a big help.

In fact I want to assign one data field as a hyperlink in a pivot table
and
the link will open a new IE window to display a web site. It looks like
it
only can open a new window in win 2000 computers, but it could not open a
new
window in XP computers. So I want to use .Hyperlink.Subaddress = "blank"
to
open a new window.

Thanks for you help!

the fields object collection does not contain a hyperlink address
property
which is why you are getting an exception. You will need to use an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the pivot table
list
object hierarchy.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Hello,

I have a object to create a pivot table in a html page to display data
in
a
pivot format. My code is:

<OBJECT CLAS xSID=clsid:0002E552-0000-0000-C000-000000000046
id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress = "top",
I
got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object should be
for
Hyperlink.Subaddress?


Thanks a lot!

 

[Guest]

it's ok, Microsoft is busy working on Office 12 instead of fixing known bugs
that are driving developers crazy

don't worry-- everything will still be broken then tho

Jean

FYI:

I didn't exactly give up on this.

I'm beginning to think it is broken functionality. Unless someone from MS
takes this up, I'll continue to dig around and then open a trouble ticket to
get to the bottom of this.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

I'm having the same error as you. I do not know what is going. Maybe
someone with more knowledge can figure this out. Sorry

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Thanks for your reply. Now I knew that the fields object doesn't have
hyperlink address property. So I got this object hierarchy by checking
the
document from MS.

Pivot.ActiveData.RowAxis.RowMember.ChildRowMembers(0).Hyperlink.Address="htt
p://www.yahoo.com"

However I still got error. I could not find any help or example from
microsoft site. If you can list the object for Hyperlink.Address, that
will
be a big help.

In fact I want to assign one data field as a hyperlink in a pivot table
and
the link will open a new IE window to display a web site. It looks like
it
only can open a new window in win 2000 computers, but it could not open a
new
window in XP computers. So I want to use .Hyperlink.Subaddress = "blank"
to
open a new window.

Thanks for you help!

:

the fields object collection does not contain a hyperlink address
property
which is why you are getting an exception. You will need to use an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the pivot table
list
object hierarchy.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Hello,

I have a object to create a pivot table in a html page to display data
in
a
pivot format. My code is:

<OBJECT CLAS xSID=clsid:0002E552-0000-0000-C000-000000000046
id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress = "top",
I
got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object should be
for
Hyperlink.Subaddress?


Thanks a lot!

 

[Alvin Bruney [MVP]]

I've submitted a trouble ticket for this. I'll let you know what i find out.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

it's ok, Microsoft is busy working on Office 12 instead of fixing known
bugs
that are driving developers crazy

don't worry-- everything will still be broken then tho

Jean

FYI:

I didn't exactly give up on this.

I'm beginning to think it is broken functionality. Unless someone from MS
takes this up, I'll continue to dig around and then open a trouble ticket to
get to the bottom of this.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

I'm having the same error as you. I do not know what is going. Maybe
someone with more knowledge can figure this out. Sorry

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Thanks for your reply. Now I knew that the fields object doesn't have
hyperlink address property. So I got this object hierarchy by checking
the
document from MS.

Pivot.ActiveData.RowAxis.RowMember.ChildRowMembers(0).Hyperlink.Address="htt
p://www.yahoo.com"

However I still got error. I could not find any help or example from
microsoft site. If you can list the object for Hyperlink.Address, that
will
be a big help.

In fact I want to assign one data field as a hyperlink in a pivot
table
and
the link will open a new IE window to display a web site. It looks like
it
only can open a new window in win 2000 computers, but it could not
open a
new
window in XP computers. So I want to use .Hyperlink.Subaddress = "blank"
to
open a new window.

Thanks for you help!

:

the fields object collection does not contain a hyperlink address
property
which is why you are getting an exception. You will need to use an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the pivot
table
list
object hierarchy.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Hello,

I have a object to create a pivot table in a html page to display data
in
a
pivot format. My code is:

<OBJECT CLAS xSID=clsid:0002E552-0000-0000-C000-000000000046
id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress = "top",
I
got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object should
be
for
Hyperlink.Subaddress?


Thanks a lot!

 

[Guest]

what woudl be really nice to get Actions working with Office Web Components.

no coding, just actions.

I've submitted a trouble ticket for this. I'll let you know what i find out.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

it's ok, Microsoft is busy working on Office 12 instead of fixing known
bugs
that are driving developers crazy

don't worry-- everything will still be broken then tho

Jean

FYI:

I didn't exactly give up on this.

I'm beginning to think it is broken functionality. Unless someone from MS
takes this up, I'll continue to dig around and then open a trouble

ticket
to

get to the bottom of this.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
I'm having the same error as you. I do not know what is going. Maybe
someone with more knowledge can figure this out. Sorry

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Thanks for your reply. Now I knew that the fields object doesn't have
hyperlink address property. So I got this object hierarchy by checking
the
document from MS.

Pivot.ActiveData.RowAxis.RowMember.ChildRowMembers(0).Hyperlink.Address="htt
p://www.yahoo.com"

However I still got error. I could not find any help or example from
microsoft site. If you can list the object for Hyperlink.Address, that
will
be a big help.

In fact I want to assign one data field as a hyperlink in a pivot
table
and
the link will open a new IE window to display a web site. It looks like
it
only can open a new window in win 2000 computers, but it could not
open a
new
window in XP computers. So I want to use .Hyperlink.Subaddress = "blank"
to
open a new window.

Thanks for you help!

:

the fields object collection does not contain a hyperlink address
property
which is why you are getting an exception. You will need to use an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the pivot
table
list
object hierarchy.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Hello,

I have a object to create a pivot table in a html page to display data
in
a
pivot format. My code is:

<OBJECT CLAS xSID=clsid:0002E552-0000-0000-C000-000000000046
id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress = "top",
I
got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object should
be
for
Hyperlink.Subaddress?


Thanks a lot!

 

[Alvin Bruney [MVP]]

i do have the pivot table code for hyperlinks if you still need it from
Microsoft Product Group
Sorry, i completely forgot about this email.

--
Regards,
Alvin Bruney

what woudl be really nice to get Actions working with Office Web
Components.

no coding, just actions.

I've submitted a trouble ticket for this. I'll let you know what i find out.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

it's ok, Microsoft is busy working on Office 12 instead of fixing known
bugs
that are driving developers crazy

don't worry-- everything will still be broken then tho



"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
Jean

FYI:

I didn't exactly give up on this.

I'm beginning to think it is broken functionality. Unless someone from MS
takes this up, I'll continue to dig around and then open a trouble ticket
to
get to the bottom of this.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
I'm having the same error as you. I do not know what is going. Maybe
someone with more knowledge can figure this out. Sorry

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Thanks for your reply. Now I knew that the fields object doesn't have
hyperlink address property. So I got this object hierarchy by checking
the
document from MS.


Pivot.ActiveData.RowAxis.RowMember.ChildRowMembers(0).Hyperlink.Address="htt
p://www.yahoo.com"

However I still got error. I could not find any help or example
from
microsoft site. If you can list the object for Hyperlink.Address, that
will
be a big help.

In fact I want to assign one data field as a hyperlink in a pivot
table
and
the link will open a new IE window to display a web site. It looks
like
it
only can open a new window in win 2000 computers, but it could not
open
a
new
window in XP computers. So I want to use .Hyperlink.Subaddress =
"blank"
to
open a new window.

Thanks for you help!

:

the fields object collection does not contain a hyperlink address
property
which is why you are getting an exception. You will need to use an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the pivot
table
list
object hierarchy.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Hello,

I have a object to create a pivot table in a html page to
display
data
in
a
pivot format. My code is:

<OBJECT CLAS xSID=clsid:0002E552-0000-0000-C000-000000000046
id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress =
"top",
I
got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object
should
be
for
Hyperlink.Subaddress?


Thanks a lot!

 

[Rolf N]

Hi Alvin.

I'm interested in the pivot table code for hyperlinks. Is it possible for
you to present it here?

Regards/Rolf

i do have the pivot table code for hyperlinks if you still need it from
Microsoft Product Group
Sorry, i completely forgot about this email.

--
Regards,
Alvin Bruney

what woudl be really nice to get Actions working with Office Web
Components.

no coding, just actions.

I've submitted a trouble ticket for this. I'll let you know what i find out.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
it's ok, Microsoft is busy working on Office 12 instead of fixing known
bugs
that are driving developers crazy

don't worry-- everything will still be broken then tho



"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
Jean

FYI:

I didn't exactly give up on this.

I'm beginning to think it is broken functionality. Unless someone from MS
takes this up, I'll continue to dig around and then open a trouble ticket
to
get to the bottom of this.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
I'm having the same error as you. I do not know what is going. Maybe
someone with more knowledge can figure this out. Sorry

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Thanks for your reply. Now I knew that the fields object doesn't have
hyperlink address property. So I got this object hierarchy by checking
the
document from MS.


Pivot.ActiveData.RowAxis.RowMember.ChildRowMembers(0).Hyperlink.Address="htt
p://www.yahoo.com"

However I still got error. I could not find any help or example
from
microsoft site. If you can list the object for Hyperlink.Address, that
will
be a big help.

In fact I want to assign one data field as a hyperlink in a pivot
table
and
the link will open a new IE window to display a web site. It looks
like
it
only can open a new window in win 2000 computers, but it could not
open
a
new
window in XP computers. So I want to use .Hyperlink.Subaddress =
"blank"
to
open a new window.

Thanks for you help!

:

the fields object collection does not contain a hyperlink address
property
which is why you are getting an exception. You will need to use an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the pivot
table
list
object hierarchy.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Hello,

I have a object to create a pivot table in a html page to
display
data
in
a
pivot format. My code is:

<OBJECT CLAS xSID=clsid:0002E552-0000-0000-C000-000000000046
id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress =
"top",
I
got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object
should
be
for
Hyperlink.Subaddress?


Thanks a lot!

 

[Alvin Bruney [MVP]]

here you go


string strCN;

string strdirname;

OWC11.PivotView objPivotView;




strdirname = "c:\\Suppliers.xml";

strCN = "provider=mspersist";

axPivotTable1.XMLData=strdirname;




axPivotTable1.ConnectionString = strCN;

axPivotTable1.CommandText = strdirname;

objPivotView = axPivotTable1.ActiveView;




objPivotView.RowAxis.InsertFieldSet(objPivotView.FieldSets["homepage"],Type.Missing,false);

objPivotView.FieldSets["homepage"].Fields["homepage"].IsHyperlink =true;





--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://tinyurl.com/27cok
----------------------------------------------------------

Hi Alvin.

I'm interested in the pivot table code for hyperlinks. Is it possible for
you to present it here?

Regards/Rolf

i do have the pivot table code for hyperlinks if you still need it from
Microsoft Product Group
Sorry, i completely forgot about this email.

--
Regards,
Alvin Bruney

what woudl be really nice to get Actions working with Office Web
Components.

no coding, just actions.


"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
I've submitted a trouble ticket for this. I'll let you know what i
find
out.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
it's ok, Microsoft is busy working on Office 12 instead of fixing
known
bugs
that are driving developers crazy

don't worry-- everything will still be broken then tho



"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in
message
Jean

FYI:

I didn't exactly give up on this.

I'm beginning to think it is broken functionality. Unless someone
from
MS
takes this up, I'll continue to dig around and then open a trouble
ticket
to
get to the bottom of this.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in
message
I'm having the same error as you. I do not know what is going.
Maybe
someone with more knowledge can figure this out. Sorry

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Thanks for your reply. Now I knew that the fields object doesn't
have
hyperlink address property. So I got this object hierarchy by
checking
the
document from MS.



Pivot.ActiveData.RowAxis.RowMember.ChildRowMembers(0).Hyperlink.Address="htt
p://www.yahoo.com"

However I still got error. I could not find any help or example
from
microsoft site. If you can list the object for
Hyperlink.Address,
that
will
be a big help.

In fact I want to assign one data field as a hyperlink in a
pivot
table
and
the link will open a new IE window to display a web site. It
looks
like
it
only can open a new window in win 2000 computers, but it could
not
open
a
new
window in XP computers. So I want to use .Hyperlink.Subaddress =
"blank"
to
open a new window.

Thanks for you help!

:

the fields object collection does not contain a hyperlink
address
property
which is why you are getting an exception. You will need to use
an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the
pivot
table
list
object hierarchy.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Hello,

I have a object to create a pivot table in a html page to
display
data
in
a
pivot format. My code is:

<OBJECT CLAS xSID=clsid:0002E552-0000-0000-C000-000000000046
id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress
=
"top",
I
got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object
should
be
for
Hyperlink.Subaddress?


Thanks a lot!

 

[Neil Meyer]

Alvin:

Regarding Hyperlinks in pivottables displayed in IE....

1) we know we can create a OLAP pivot table in Excel and save it as a web
page (publish it)
2) we can then look at that pivot table and use it in IE
3) we can use (right-click on the pivot table in IE) Commands and Options to
change the format of a field and tell it to display as hyperlink
4) if our data value for the field supplied by OLAP is something like: Go
Here#http://domain/action.cfm?dosomething=yes
AND we change it to a hyperlinke, then it will display as Go Here and will
work beautifully as a link.

My problem is that, by default, the pivot table will always come up with the
data value displayed as the ugly, full text string:
Go Here#http://domain/action.cfm?dosomething=yes until I go through step 3
and change it to hyperlink again.

Is there any way to have the value come up in the pivot table as hyperlinks,
by default, without each time having to go through step 3 all over again?

If I'm not making sense, let me know and I'll more carefully lay out the
problem....

Thanks.

Neil

here you go


string strCN;

string strdirname;

OWC11.PivotView objPivotView;




strdirname = "c:\\Suppliers.xml";

strCN = "provider=mspersist";

axPivotTable1.XMLData=strdirname;




axPivotTable1.ConnectionString = strCN;

axPivotTable1.CommandText = strdirname;

objPivotView = axPivotTable1.ActiveView;




objPivotView.RowAxis.InsertFieldSet(objPivotView.FieldSets["homepage"],Type.Missing,false);

objPivotView.FieldSets["homepage"].Fields["homepage"].IsHyperlink =true;





--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://tinyurl.com/27cok
----------------------------------------------------------

Hi Alvin.

I'm interested in the pivot table code for hyperlinks. Is it possible for
you to present it here?

Regards/Rolf

i do have the pivot table code for hyperlinks if you still need it from
Microsoft Product Group
Sorry, i completely forgot about this email.

--
Regards,
Alvin Bruney
what woudl be really nice to get Actions working with Office Web
Components.

no coding, just actions.


"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
I've submitted a trouble ticket for this. I'll let you know what i
find
out.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
it's ok, Microsoft is busy working on Office 12 instead of fixing
known
bugs
that are driving developers crazy

don't worry-- everything will still be broken then tho



"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in
message
Jean

FYI:

I didn't exactly give up on this.

I'm beginning to think it is broken functionality. Unless someone
from
MS
takes this up, I'll continue to dig around and then open a trouble
ticket
to
get to the bottom of this.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in
message
I'm having the same error as you. I do not know what is going.
Maybe
someone with more knowledge can figure this out. Sorry

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Thanks for your reply. Now I knew that the fields object
doesn't
have
hyperlink address property. So I got this object hierarchy by
checking
the
document from MS.



Pivot.ActiveData.RowAxis.RowMember.ChildRowMembers(0).Hyperlink.Address="htt
p://www.yahoo.com"

However I still got error. I could not find any help or example
from
microsoft site. If you can list the object for
Hyperlink.Address,
that
will
be a big help.

In fact I want to assign one data field as a hyperlink in a
pivot
table
and
the link will open a new IE window to display a web site. It
looks
like
it
only can open a new window in win 2000 computers, but it could
not
open
a
new
window in XP computers. So I want to use .Hyperlink.Subaddress
=
"blank"
to
open a new window.

Thanks for you help!

:

the fields object collection does not contain a hyperlink
address
property
which is why you are getting an exception. You will need to
use an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the
pivot
table
list
object hierarchy.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Hello,

I have a object to create a pivot table in a html page to
display
data
in
a
pivot format. My code is:

<OBJECT CLAS xSID=clsid:0002E552-0000-0000-C000-000000000046
id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress
=
"top",
I
got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object
should
be
for
Hyperlink.Subaddress?


Thanks a lot!

 

[Alvin Bruney [MVP]]

I don't think this functionality is supported. Not 100% sure so I may be
wrong.

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc
----------------------------------------------------------

Alvin:

Regarding Hyperlinks in pivottables displayed in IE....

1) we know we can create a OLAP pivot table in Excel and save it as a web
page (publish it)
2) we can then look at that pivot table and use it in IE
3) we can use (right-click on the pivot table in IE) Commands and Options
to change the format of a field and tell it to display as hyperlink
4) if our data value for the field supplied by OLAP is something like: Go
Here#http://domain/action.cfm?dosomething=yes
AND we change it to a hyperlinke, then it will display as Go Here and will
work beautifully as a link.

My problem is that, by default, the pivot table will always come up with
the data value displayed as the ugly, full text string:
Go Here#http://domain/action.cfm?dosomething=yes until I go through step 3
and change it to hyperlink again.

Is there any way to have the value come up in the pivot table as
hyperlinks, by default, without each time having to go through step 3 all
over again?

If I'm not making sense, let me know and I'll more carefully lay out the
problem....

Thanks.

Neil

here you go


string strCN;

string strdirname;

OWC11.PivotView objPivotView;




strdirname = "c:\\Suppliers.xml";

strCN = "provider=mspersist";

axPivotTable1.XMLData=strdirname;




axPivotTable1.ConnectionString = strCN;

axPivotTable1.CommandText = strdirname;

objPivotView = axPivotTable1.ActiveView;




objPivotView.RowAxis.InsertFieldSet(objPivotView.FieldSets["homepage"],Type.Missing,false);

objPivotView.FieldSets["homepage"].Fields["homepage"].IsHyperlink =true;





--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://tinyurl.com/27cok
----------------------------------------------------------

Hi Alvin.

I'm interested in the pivot table code for hyperlinks. Is it possible
for
you to present it here?

Regards/Rolf

:

i do have the pivot table code for hyperlinks if you still need it from
Microsoft Product Group
Sorry, i completely forgot about this email.

--
Regards,
Alvin Bruney
what woudl be really nice to get Actions working with Office Web
Components.

no coding, just actions.


"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
I've submitted a trouble ticket for this. I'll let you know what i
find
out.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
it's ok, Microsoft is busy working on Office 12 instead of fixing
known
bugs
that are driving developers crazy

don't worry-- everything will still be broken then tho



"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in
message
Jean

FYI:

I didn't exactly give up on this.

I'm beginning to think it is broken functionality. Unless someone
from
MS
takes this up, I'll continue to dig around and then open a
trouble
ticket
to
get to the bottom of this.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in
message
I'm having the same error as you. I do not know what is going.
Maybe
someone with more knowledge can figure this out. Sorry

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Thanks for your reply. Now I knew that the fields object
doesn't
have
hyperlink address property. So I got this object hierarchy by
checking
the
document from MS.



Pivot.ActiveData.RowAxis.RowMember.ChildRowMembers(0).Hyperlink.Address="htt
p://www.yahoo.com"

However I still got error. I could not find any help or
example
from
microsoft site. If you can list the object for
Hyperlink.Address,
that
will
be a big help.

In fact I want to assign one data field as a hyperlink in a
pivot
table
and
the link will open a new IE window to display a web site. It
looks
like
it
only can open a new window in win 2000 computers, but it could
not
open
a
new
window in XP computers. So I want to use .Hyperlink.Subaddress
=
"blank"
to
open a new window.

Thanks for you help!

:

the fields object collection does not contain a hyperlink
address
property
which is why you are getting an exception. You will need to
use an
appropriate parent object
that exposes the pivothyperlink object. Have a look at the
pivot
table
list
object hierarchy.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Hello,

I have a object to create a pivot table in a html page to
display
data
in
a
pivot format. My code is:

<OBJECT CLAS
xSID=clsid:0002E552-0000-0000-C000-000000000046
id="Pivot"
VIEWASTEXT></OBJECT>

oView.FieldSets("ProductName").Fields(0).IsHyperlink = True

When I use
oView.FieldSets("ProductName").Fields(0).Hyperlink.SubAddress
=
"top",
I
got
"Object doesn't support this property" error.

How can I set a value to Hyperlink.SubAddress? What object
should
be
for
Hyperlink.Subaddress?


Thanks a lot!

 

[Alvin Bruney [MVP]]

Neil,
if you don't get an answer here, please open a support incident with the
product support group. You have 3 free incidents if you have an installed
microsoft product on your system. Here is a link:
use this link http://support.microsoft.com/select/?target=assistance

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc

 

[Neil Meyer]

Thanks Alvin. So far, no additional info. I can't get free support because
I work for a County Office of Education and we use MS OFFICE with FrontPage
on a bulk/Educational contract.

Neil

Neil,
if you don't get an answer here, please open a support incident with the
product support group. You have 3 free incidents if you have an installed
microsoft product on your system. Here is a link:
use this link http://support.microsoft.com/select/?target=assistance

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc
----------------------------------------------------------

Alvin, Thanks for the reply.

Anyone: Is there any other way to do what I'm trying to do in a pivot
table
that displays on a web page?

See attached picture.

 

[Alvin Bruney [Microsoft MVP]]

i have a supprt incident open, i'll look into it.

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

Thanks Alvin. So far, no additional info. I can't get free support
because I work for a County Office of Education and we use MS OFFICE with
FrontPage on a bulk/Educational contract.

Neil

Neil,
if you don't get an answer here, please open a support incident with the
product support group. You have 3 free incidents if you have an installed
microsoft product on your system. Here is a link:
use this link http://support.microsoft.com/select/?target=assistance

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc
----------------------------------------------------------

Alvin, Thanks for the reply.

Anyone: Is there any other way to do what I'm trying to do in a pivot
table
that displays on a web page?

See attached picture.

 

[Alvin Bruney [Microsoft MVP]]

FYI: I have not received any word from Microsoft product support yet!

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

i have a supprt incident open, i'll look into it.

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

Thanks Alvin. So far, no additional info. I can't get free support
because I work for a County Office of Education and we use MS OFFICE with
FrontPage on a bulk/Educational contract.

Neil

Neil,
if you don't get an answer here, please open a support incident with the
product support group. You have 3 free incidents if you have an
installed microsoft product on your system. Here is a link:
use this link http://support.microsoft.com/select/?target=assistance

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc
----------------------------------------------------------


Alvin, Thanks for the reply.

Anyone: Is there any other way to do what I'm trying to do in a pivot
table
that displays on a web page?

See attached picture.

 

[Neil Meyer]

Alvin, Thank you, and I'll keep checking back in.

Neil

FYI: I have not received any word from Microsoft product support yet!

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

i have a supprt incident open, i'll look into it.

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

Thanks Alvin. So far, no additional info. I can't get free support
because I work for a County Office of Education and we use MS OFFICE
with FrontPage on a bulk/Educational contract.

Neil

"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
Neil,
if you don't get an answer here, please open a support incident with
the product support group. You have 3 free incidents if you have an
installed microsoft product on your system. Here is a link:
use this link http://support.microsoft.com/select/?target=assistance

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc
----------------------------------------------------------


Alvin, Thanks for the reply.

Anyone: Is there any other way to do what I'm trying to do in a pivot
table
that displays on a web page?

See attached picture.

 

[Alvin Bruney [Microsoft MVP]]

Finally got someone from MS to respond. Sometime next week, it should be
resolved - at least that is what they are saying

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

Alvin, Thank you, and I'll keep checking back in.

Neil

FYI: I have not received any word from Microsoft product support yet!

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

i have a supprt incident open, i'll look into it.

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


Thanks Alvin. So far, no additional info. I can't get free support
because I work for a County Office of Education and we use MS OFFICE
with FrontPage on a bulk/Educational contract.

Neil

"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
Neil,
if you don't get an answer here, please open a support incident with
the product support group. You have 3 free incidents if you have an
installed microsoft product on your system. Here is a link:
use this link http://support.microsoft.com/select/?target=assistance

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc
----------------------------------------------------------


Alvin, Thanks for the reply.

Anyone: Is there any other way to do what I'm trying to do in a pivot
table
that displays on a web page?

See attached picture.

 

[Neil Meyer]

Thanks Alvin! I'll stay tuned.

Neil

Finally got someone from MS to respond. Sometime next week, it should be
resolved - at least that is what they are saying

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

Alvin, Thank you, and I'll keep checking back in.

Neil

FYI: I have not received any word from Microsoft product support yet!

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


"Alvin Bruney [Microsoft MVP]" <www.lulu.com/owc> wrote in message
i have a supprt incident open, i'll look into it.

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


Thanks Alvin. So far, no additional info. I can't get free support
because I work for a County Office of Education and we use MS OFFICE
with FrontPage on a bulk/Educational contract.

Neil

"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
Neil,
if you don't get an answer here, please open a support incident with
the product support group. You have 3 free incidents if you have an
installed microsoft product on your system. Here is a link:
use this link http://support.microsoft.com/select/?target=assistance

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc
----------------------------------------------------------


Alvin, Thanks for the reply.

Anyone: Is there any other way to do what I'm trying to do in a
pivot table
that displays on a web page?

See attached picture.