Help, how to set a hyperlink for a specified row member ?

[Thomas]

Hi !

Me again , I want to set a hyperlink for a specified RowMember..
On the RowAxis I use three Dimensions.
Do I need to specify it more exactly ?
I use the following but it doesn't work ?!

PivotControl1.ActiveData.RowAxis.RowMember.ChildRowMembers(3).Hyperlink.Address="http://www.test.com"

Grtz,
Thomas

 

[Alvin Bruney [MVP - ASP.NET]]

Here is some code from the black book, listing 11.33 showing hyperlinking


C# Snippet




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;





happy camping...



--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

 

[Thomas]

Hi Alvin !

Thank you for your answer , but it doesn't really help me.
Setting a hyperlink is no problem , but i want to set the address.
How can I set the Address ?
With my Code listet in the first thread it doesn't work, please help 1

Regards
Thomas

Here is some code from the black book, listing 11.33 showing hyperlinking


C# Snippet




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;





happy camping...



--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Hi !

Me again , I want to set a hyperlink for a specified RowMember..
On the RowAxis I use three Dimensions.
Do I need to specify it more exactly ?
I use the following but it doesn't work ?!

PivotControl1.ActiveData.RowAxis.RowMember.ChildRowMembers(3).Hyperlink.Address="http://www.test.com"

Grtz,
Thomas