Adding Hyperlink to PivotField

[RAGHAVAN JAYARAMAN]

Hi Alvin,

I need to add an Hyperlink to pivot Field . I can enable the hyperlink by
setting the IsHyperlink = True. But i cannot set or find the address or
subaddress property.Also i tried adding a Calculated Fieldset as suggested by
Microsoft sample. But for some reason it's show as "Error" with Hyperlink
enabled. I believe the syntax to add on the calculated Expression is ( for
ex)
string szTemp = "[" + DetailSet.Fields[0].Name + "]" +
"#http://www.msn.com" ;
I'm adding this to the AddCalculatedField Expression. It is giving me error.
but i can use this string ( szTemp = "[" + DetailSet.Fields[0].Name + "]" ;
). Is there anything wrong on the c# syntax ( i think its
label#address#subaddress). Please let me know what is the right way to add
hyperlink to PivotField. How to use the PivotHyperlink object for
PivotDetailRange or PivotRowmembers.
Appreciate your response.
Thanks!

 

[Alvin Bruney - MVP ASP.NET]

The black book contains an example at this link
http://www.amazon.com/gp/reader/141...oTMQAyIW5JvEJFnPX4FVDRuyoWda4iUg=#reader-page

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET

 

[RAGHAVAN JAYARAMAN]

Thanks Alvin. But is there any way i can specify custom URL along with
existing Field
on the PivotDetailRange section. In your example , you have specified it's
part of the
Fieldset that is either stored on the XML file or Cube Fieldset. I need
something like
displaying the actual field and clicking on the totals would launch URL.
Probably if possible even with Calculated Field with expressions. say.
Trade Cnt contains 30. Clciking with cnt 30 would launch custom
page.Something like this Microsoft sample
http://support.microsoft.com/?id=317630 . How to build a Desired display
text with address for the calculated
field.( displaytext#addresss#subaddress#screentip . C# syntax ).
OWC version 10
Thanks!

The black book contains an example at this link
http://www.amazon.com/gp/reader/141...oTMQAyIW5JvEJFnPX4FVDRuyoWda4iUg=#reader-page

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

Hi Alvin,

I need to add an Hyperlink to pivot Field . I can enable the hyperlink
by
setting the IsHyperlink = True. But i cannot set or find the address or
subaddress property.Also i tried adding a Calculated Fieldset as suggested
by
Microsoft sample. But for some reason it's show as "Error" with Hyperlink
enabled. I believe the syntax to add on the calculated Expression is ( for
ex)
string szTemp = "[" + DetailSet.Fields[0].Name + "]" +
"#http://www.msn.com" ;
I'm adding this to the AddCalculatedField Expression. It is giving me
error.
but i can use this string ( szTemp = "[" + DetailSet.Fields[0].Name + "]"
;
). Is there anything wrong on the c# syntax ( i think its
label#address#subaddress). Please let me know what is the right way to add
hyperlink to PivotField. How to use the PivotHyperlink object for
PivotDetailRange or PivotRowmembers.
Appreciate your response.
Thanks!