September 16, 2015 at 2:04 pm
I have a SSRS 2012 report that I have built using the SQL Server data tools, inside one of the datasets fields are text and URL's. The URL should be a hyperlink when the report is viewed via a web browser, how can I accomplish this?
September 16, 2015 at 8:32 pm
Is the hyperlink nested inside of a text column?
I created a dummy report with a text string that I wanted to use as a hyperlink, and it worked.
In Placeholder properties, select Go To URL and specify the field containing the hyperlink to go to.
September 16, 2015 at 8:35 pm
Is the hyperlink nested inside of a text column?
I created a dummy report with a text string that I wanted to use as a hyperlink, and it worked.
In Placeholder properties, select Go To URL and specify the field containing the hyperlink to go to.
September 17, 2015 at 5:13 am
Thanks for the reply. I just tried that and it does not work, i'm working with tweets from twitter a lot of the urls are shortened using twitter shorten url. So the url's look like http://t.co/randomtxt
Any other idea's ?
September 17, 2015 at 11:51 am
Sure it does. I just did it. It was even easier than I thought.
This is what I did...
(My dataset is embedded, otherwise it wouldn't work for you... it's a dummy union query, but that should not be relevant.)
For the sake of simplicity, I have two fields in my dataset, "Tweet" and "Subject". I dropped a tablix onto the design surface, and added the Subject field to it. Go to Textbox properties. Action: Go to URL: [Tweet].
I did it 3 times to see if i could get it to fail. Worked fine even if I just dropped in the Twitter URL.
What version of SSRS are you using? (Just trying to figure out what could be going wrong).
September 17, 2015 at 12:36 pm
I'm using SSRS 2012. I downloaded your rdl file and matched everything one for one, I didn't use the query because that shouldn't have anything to do with this. It still doesn't work, what else can I try?
September 17, 2015 at 12:48 pm
Can you post your report with some dummy data? either embed the data like I did or post CREATE TABLE/INSERT scripts to populate it.
The data can be completely fake... (better that way...)
Just enough to reproduce the problem. What part "doesn't work"? What happens when you click on the Tweet link?
September 17, 2015 at 12:59 pm
I just took a look at the report page, one of the tweets which looked like text text (text) (#hashtag) http://t.co/shortlink #hashtag #hashtag #hashtag #hashtag
Only a few of the results are like the above, all the others still do nothing.
When I hovered on that tweet, the whole tweet was a URL. Of course the URL goes no where because it's invalid. Is there any way to only have the shorten link go where it's suppose to?
September 17, 2015 at 1:02 pm
sure i add some dummy data and post mine so you can take a look
September 17, 2015 at 1:05 pm
Did you attach it? I don't see it.
September 17, 2015 at 1:26 pm
It wasn't attached on my last post, I have attached on this post
September 17, 2015 at 1:37 pm
I don't have any data... Should I just make some up?
September 17, 2015 at 1:43 pm
Sure.
September 17, 2015 at 2:02 pm
Okay, taking it from the top, because I have no clue why mine works and yours doesn't.
Create a dummy table:
CREATE TABLE TweetsList(
TweetDate DATE NOT NULL,
TweetURL VARCHAR(50) NOT NULL
);
GO
Populate:
INSERT INTO TweetsList VALUES ('9/17/2015 11:30','http://t.co/5Dr6XMSclB'),
('9/17/2015 11:35','http://t.co/8Oo27mHCWv'),
('9/17/2015 11:36', 'http://t.co/UxDRMeEp9K');
Create stored procedure to return the data...
CREATE PROC GetTweets
AS
SELECT TweetDate
, TweetURL
FROM TweetsList;
Create report:
select GetTweets as dataset source.
Drop a tablix into your report, add the two fields.
Right-click the TweetURL field in your tablix and select ACTION. Then Select Go to URL
Select [TweetURL] as the URL to go to.
Click OK.
Done!
September 17, 2015 at 2:27 pm
I'll reproduce what you did and see if the results are same as yours.
Viewing 15 posts - 1 through 15 (of 40 total)
You must be logged in to reply to this topic. Login to reply