Report column values which should open more than one pop up

Question

Post reply

Report column values which should open more than one pop up

v-swgar

SSC Enthusiast

Points: 121
More actions
January 7, 2013 at 2:24 pm

#266742

Hi All,
I am creating a report which would have two columns Measure Name & Measure Description as below
MeasureMeasure Description
Measure1This is the Description for this Measure as of today
Measure2This is the Description for this Measure as of today
Individual texts in the column will have hyperlink text which should open a pop up which has the description of the text. One column can have more than one text with hyperlink.
I checked tool tip and Actions tab in the text box properties.. But i did not find anything which can be of help to me. C
Can anyone here please help me on how to implement this.
Thanks in Advance
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

go to the Action section again and select "Go to URL"

Enter an expression for the url to get an alert window:

= "alert(""" & Field!Description.Value & """);"

Of course, you should URL encode your strings first (search for URL endcode function for SSRS)

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

v-swgar SSC Enthusiast Points: 121 More actions · Answer 2

Thanks so much for the reply mister.

but this does not seem to work with part of text in the column which would be the hyperlink text?

Can you please give me any referring links if you have any?

uma.thangaraj Old Hand Points: 375 More actions · Answer 3

First you may have to modify your query so that the MeasureDescription field is in HTML format.

Something like:

SELECT 'M1' as Measure,

'Description: <a href="http://www.google.com">Description for M1</a>' as MeasureDescription

Then in the table where you want to display MeasureDescription, you can create a PlaceHolder.

In the Placeholder Properties window, choose 'MeasureDescription' as value and select the Markup type as 'HTML - Interpret HTML tags as styles'.

Hopefully, this should solve your problem.

Regards,

Uma

mister.magoo SSC-Forever Points: 47174 More actions · Answer 4

v-swgar (1/7/2013)
Thanks so much for the reply mister.
but this does not seem to work with part of text in the column which would be the hyperlink text?
Can you please give me any referring links if you have any?

Sorry, I misunderstood your question...try the answer given by Uma.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);