Hi
I just upsized a database from Access to SQL everything seems to be working
fine except I had a Hyperlink field in Access which is not working with the
SQL tables and I see no data type in SQL for hyperlinks. Is there a way
around this?
Any help with the will be greatly appreciated
ChuckHyperlinks are only text, so a simple varchar datatype does it. SQL Server d
oesn't come with a
front-end development tool, which is where the interpretation of this text (
that it is an URL and
should be treated as such) takes place. I suggest you post this in a newsgro
up for the front-end dev
tool you are using.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chuck216" <cigar216@.hotmail.com> wrote in message
news:ED93A6D4-11DB-43C0-ADEE-847722151619@.microsoft.com...
> Hi
> I just upsized a database from Access to SQL everything seems to be worki
ng
> fine except I had a Hyperlink field in Access which is not working with th
e
> SQL tables and I see no data type in SQL for hyperlinks. Is there a way
> around this?
>
> Any help with the will be greatly appreciated
> Chuck
>
Showing posts with label hyperlink. Show all posts
Showing posts with label hyperlink. Show all posts
Friday, February 24, 2012
hyperlinks
Hi
I just upsized a database from Access to SQL everything seems to be working
fine except I had a Hyperlink field in Access which is not working with the
SQL tables and I see no data type in SQL for hyperlinks. Is there a way
around this?
Any help with the will be greatly appreciated
ChuckHyperlinks are only text, so a simple varchar datatype does it. SQL Server doesn't come with a
front-end development tool, which is where the interpretation of this text (that it is an URL and
should be treated as such) takes place. I suggest you post this in a newsgroup for the front-end dev
tool you are using.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chuck216" <cigar216@.hotmail.com> wrote in message
news:ED93A6D4-11DB-43C0-ADEE-847722151619@.microsoft.com...
> Hi
> I just upsized a database from Access to SQL everything seems to be working
> fine except I had a Hyperlink field in Access which is not working with the
> SQL tables and I see no data type in SQL for hyperlinks. Is there a way
> around this?
>
> Any help with the will be greatly appreciated
> Chuck
>
I just upsized a database from Access to SQL everything seems to be working
fine except I had a Hyperlink field in Access which is not working with the
SQL tables and I see no data type in SQL for hyperlinks. Is there a way
around this?
Any help with the will be greatly appreciated
ChuckHyperlinks are only text, so a simple varchar datatype does it. SQL Server doesn't come with a
front-end development tool, which is where the interpretation of this text (that it is an URL and
should be treated as such) takes place. I suggest you post this in a newsgroup for the front-end dev
tool you are using.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chuck216" <cigar216@.hotmail.com> wrote in message
news:ED93A6D4-11DB-43C0-ADEE-847722151619@.microsoft.com...
> Hi
> I just upsized a database from Access to SQL everything seems to be working
> fine except I had a Hyperlink field in Access which is not working with the
> SQL tables and I see no data type in SQL for hyperlinks. Is there a way
> around this?
>
> Any help with the will be greatly appreciated
> Chuck
>
Hyperlinking to another report
Im trying to create a link to another report from one of my fields (Budget_Reporting_Group_Description) but i only want the hyperlink to be visible and clickable for one value (Actual), how would i write out the code and where would i put it in the properties box for navigation. The report i want to link to is called Details.
|||thanks alot, i figure out what it was. I put the code in the jump to report, and changed the field from ID to Description, i made the mistake i putting ID , when i needed Description. Thanks for the help!
I have this so far:
=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)
whats wrong?
Maybe you're not putting it in the correct place. The expression has to be placed in the expression for "Jump to report" under textbox properties -> Navigation tab.
-Aayush
|||Hello,
Put this in the expression for your field, and in the "Jump To Report" of the navigation properties.
=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)
Now, if the Id is "Actual", then you will see "Details" in the textbox and it will be clickable, which will take you to your Details report. If it's not "Actual", then the textbox will be blank, with no hyperlink.
Hope this helps.
Jarret
|||I have it in the jump to report Expression box. But its not showing a hyperlink when i roll the mouse of the field. Is there another expression, or something to link it to another report. I just want the report to show a hyperlink if the value in the field is "Forecast" if not, it should not have a link to the other report.|||thanks alot, i figure out what it was. I put the code in the jump to report, and changed the field from ID to Description, i made the mistake i putting ID , when i needed Description. Thanks for the help!
Hyperlinking to another report
Im trying to create a link to another report from one of my fields (Budget_Reporting_Group_Description) but i only want the hyperlink to be visible and clickable for one value (Actual), how would i write out the code and where would i put it in the properties box for navigation. The report i want to link to is called Details.
|||thanks alot, i figure out what it was. I put the code in the jump to report, and changed the field from ID to Description, i made the mistake i putting ID , when i needed Description. Thanks for the help!
I have this so far:
=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)
whats wrong?
Maybe you're not putting it in the correct place. The expression has to be placed in the expression for "Jump to report" under textbox properties -> Navigation tab.
-Aayush
|||Hello,
Put this in the expression for your field, and in the "Jump To Report" of the navigation properties.
=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)
Now, if the Id is "Actual", then you will see "Details" in the textbox and it will be clickable, which will take you to your Details report. If it's not "Actual", then the textbox will be blank, with no hyperlink.
Hope this helps.
Jarret
|||I have it in the jump to report Expression box. But its not showing a hyperlink when i roll the mouse of the field. Is there another expression, or something to link it to another report. I just want the report to show a hyperlink if the value in the field is "Forecast" if not, it should not have a link to the other report.|||thanks alot, i figure out what it was. I put the code in the jump to report, and changed the field from ID to Description, i made the mistake i putting ID , when i needed Description. Thanks for the help!
Hyperlinking to another report
Im trying to create a link to another report from one of my fields (Budget_Reporting_Group_Description) but i only want the hyperlink to be visible and clickable for one value (Actual), how would i write out the code and where would i put it in the properties box for navigation. The report i want to link to is called Details.
|||thanks alot, i figure out what it was. I put the code in the jump to report, and changed the field from ID to Description, i made the mistake i putting ID , when i needed Description. Thanks for the help!
I have this so far:
=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)
whats wrong?
Maybe you're not putting it in the correct place. The expression has to be placed in the expression for "Jump to report" under textbox properties -> Navigation tab.
-Aayush
|||Hello,
Put this in the expression for your field, and in the "Jump To Report" of the navigation properties.
=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)
Now, if the Id is "Actual", then you will see "Details" in the textbox and it will be clickable, which will take you to your Details report. If it's not "Actual", then the textbox will be blank, with no hyperlink.
Hope this helps.
Jarret
|||I have it in the jump to report Expression box. But its not showing a hyperlink when i roll the mouse of the field. Is there another expression, or something to link it to another report. I just want the report to show a hyperlink if the value in the field is "Forecast" if not, it should not have a link to the other report.|||thanks alot, i figure out what it was. I put the code in the jump to report, and changed the field from ID to Description, i made the mistake i putting ID , when i needed Description. Thanks for the help!
Hyperlink to send an Email
Hello,
I am looking for a way for users to click on a textbox and send an Email. I
got that to work if I set up 'On action' URL to
'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
If a user clicks next to A then Email should go to A@.myemail.com and if they
click next to B email should go to B@.myemail.com so on and so forth. I have A
and B here is value in my field MYFIELD. I tried using
mailto:Fields!MYFIELD.value that won't work.
Any ideas will be appreciated.
Thanks.Hi,
You can use the following expresion in the 'Jump to URL':
="mailto:" & Fields!MYFIELD.value
Use this with the equal sign and spaces. You can add
& "@.mycompany.com" if your field doesn't have the domain included
Jan Pieter Posthuma
"amitj" wrote:
> Hello,
> I am looking for a way for users to click on a textbox and send an Email. I
> got that to work if I set up 'On action' URL to
> 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> If a user clicks next to A then Email should go to A@.myemail.com and if they
> click next to B email should go to B@.myemail.com so on and so forth. I have A
> and B here is value in my field MYFIELD. I tried using
> mailto:Fields!MYFIELD.value that won't work.
> Any ideas will be appreciated.
> Thanks.|||Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
didn't add the field name.
"Jan Pieter Posthuma" wrote:
> Hi,
> You can use the following expresion in the 'Jump to URL':
> ="mailto:" & Fields!MYFIELD.value
> Use this with the equal sign and spaces. You can add
> & "@.mycompany.com" if your field doesn't have the domain included
> Jan Pieter Posthuma
>
> "amitj" wrote:
> > Hello,
> >
> > I am looking for a way for users to click on a textbox and send an Email. I
> > got that to work if I set up 'On action' URL to
> > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > and B here is value in my field MYFIELD. I tried using
> > mailto:Fields!MYFIELD.value that won't work.
> >
> > Any ideas will be appreciated.
> >
> > Thanks.|||Hi,
You have to add also the qoutes (") and & symbols. You have to use the equal
(=) to let RS to calculate the field. The next part is a string "mailto:"
including the quotes. Then you concatenate by using the &-sign to the value
part: Fields!MYFIELD.value.
Totally will be: <code>="mailto:" & Fields!MYFIELD.value</code>
That will work.
Jan Pieter Posthuma
"amitj" wrote:
> Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
> mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
> didn't add the field name.
> "Jan Pieter Posthuma" wrote:
> > Hi,
> >
> > You can use the following expresion in the 'Jump to URL':
> > ="mailto:" & Fields!MYFIELD.value
> >
> > Use this with the equal sign and spaces. You can add
> > & "@.mycompany.com" if your field doesn't have the domain included
> >
> > Jan Pieter Posthuma
> >
> >
> > "amitj" wrote:
> >
> > > Hello,
> > >
> > > I am looking for a way for users to click on a textbox and send an Email. I
> > > got that to work if I set up 'On action' URL to
> > > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > > and B here is value in my field MYFIELD. I tried using
> > > mailto:Fields!MYFIELD.value that won't work.
> > >
> > > Any ideas will be appreciated.
> > >
> > > Thanks.
I am looking for a way for users to click on a textbox and send an Email. I
got that to work if I set up 'On action' URL to
'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
If a user clicks next to A then Email should go to A@.myemail.com and if they
click next to B email should go to B@.myemail.com so on and so forth. I have A
and B here is value in my field MYFIELD. I tried using
mailto:Fields!MYFIELD.value that won't work.
Any ideas will be appreciated.
Thanks.Hi,
You can use the following expresion in the 'Jump to URL':
="mailto:" & Fields!MYFIELD.value
Use this with the equal sign and spaces. You can add
& "@.mycompany.com" if your field doesn't have the domain included
Jan Pieter Posthuma
"amitj" wrote:
> Hello,
> I am looking for a way for users to click on a textbox and send an Email. I
> got that to work if I set up 'On action' URL to
> 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> If a user clicks next to A then Email should go to A@.myemail.com and if they
> click next to B email should go to B@.myemail.com so on and so forth. I have A
> and B here is value in my field MYFIELD. I tried using
> mailto:Fields!MYFIELD.value that won't work.
> Any ideas will be appreciated.
> Thanks.|||Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
didn't add the field name.
"Jan Pieter Posthuma" wrote:
> Hi,
> You can use the following expresion in the 'Jump to URL':
> ="mailto:" & Fields!MYFIELD.value
> Use this with the equal sign and spaces. You can add
> & "@.mycompany.com" if your field doesn't have the domain included
> Jan Pieter Posthuma
>
> "amitj" wrote:
> > Hello,
> >
> > I am looking for a way for users to click on a textbox and send an Email. I
> > got that to work if I set up 'On action' URL to
> > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > and B here is value in my field MYFIELD. I tried using
> > mailto:Fields!MYFIELD.value that won't work.
> >
> > Any ideas will be appreciated.
> >
> > Thanks.|||Hi,
You have to add also the qoutes (") and & symbols. You have to use the equal
(=) to let RS to calculate the field. The next part is a string "mailto:"
including the quotes. Then you concatenate by using the &-sign to the value
part: Fields!MYFIELD.value.
Totally will be: <code>="mailto:" & Fields!MYFIELD.value</code>
That will work.
Jan Pieter Posthuma
"amitj" wrote:
> Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
> mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
> didn't add the field name.
> "Jan Pieter Posthuma" wrote:
> > Hi,
> >
> > You can use the following expresion in the 'Jump to URL':
> > ="mailto:" & Fields!MYFIELD.value
> >
> > Use this with the equal sign and spaces. You can add
> > & "@.mycompany.com" if your field doesn't have the domain included
> >
> > Jan Pieter Posthuma
> >
> >
> > "amitj" wrote:
> >
> > > Hello,
> > >
> > > I am looking for a way for users to click on a textbox and send an Email. I
> > > got that to work if I set up 'On action' URL to
> > > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > > and B here is value in my field MYFIELD. I tried using
> > > mailto:Fields!MYFIELD.value that won't work.
> > >
> > > Any ideas will be appreciated.
> > >
> > > Thanks.
Hyperlink to open in a new blank window.
A field in one of my reports has the navigation property jump to a url, which is a Word document on our server. The problem is the Word file opens up in the existing frame of our website, instead of opening a new frame. In the past I have used _blank. Where do I place this in Visual Studio 2003 to perform this action with Reporting Services?
Thanks for your help.
it seems that you are trying to open Document in new window so here is the line to be used in Jump to Url Textbox
="javascript:void(window.open('http://www.google.com','_blank'))" this will popup google.com in new page.
if you are picking the url from database you can use this
="javascript:void(window.open('" & Fields!URL.Value &"','_blank'))"
is this you are trying to do?
Thanks
Rohit|||
Yes, that is what I'm trying to accomplish, except it doesn't work. I copy and paste the following into Reporting Services:
Advanced TextBox Properties>Navigation>Hyperlink Action:>Jump to URL:
="javascript:void(window.open('" & Fields!MyLink.Value &"','_blank'))"
I get-->
javascript:void(window.open('" & Fields!MyLink.Value &"','_blank'))" in the URL
I'm using Windows 2000 Server, SQLServer2000, and IE 6.0.29 with all service packs installed.
That means you need to Install Hotfix for SQL Server 2000 Reporting Services SP2 and make sure you already have installed Reporting Services SP2, The hot fix setup will not run on computer unless you have SP2 Installed on your computer.
Here is the Link for both
http://www.microsoft.com/downloads/details.aspx?FamilyID=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en
Thanks
Rohit
|||
I pulled one Report (RDl) on IE
For Example:-
I am havingtestreport.rdl file
I am giving another reporti.e testreport2.rdl in JUMP to URL box intestreport.rdl file
I opened the below linkwith testreport.rdl
http://localhost/reportserver/testreport
I Clicked oneone item ontestreport.rdl
I got Result on samewindow(OPENED IE) , But I want result on New Window(I have to open New Window for Sub report )
I got solution with Reporting Services SP2 package with SQL2000.RS-KB901383-v8.00.1042.00-ENGHotFix using this statement injumptoURL(
="javascript:void(window.open('http://localhost/reportserver/testreport2,'_blank'))"
But I want onlywith SQLserver2000 Reporting services only with out SP2 Package
Can u please helpme
With
Regards
Battula
Hi
I'm not sure if we can use javascript to open new window without installing HotFix
but after the installation we can open report in new window with parameters thru Jump To URL like this
="javascript:void(window.open('http://localhost/reportserver?/testReport/ReportName&rs:Command=Render&Parameter1=" & Fields!Parameter1.Value & "','_blank'))"
Thanx
|||
Iam able to open new window but not able to see any text to identify that the link is present. Any idea on this.
i have to very hardly hover in the reprot to find where the link is located.
|||You would not put the link in the expression for the pop up. The expression for the field should be normal I.E. =Fields!some_value.Value or some hard coded value, the text should appear and when using the jump to URL should pop open your window. If you are still not seeing anything check your formatting, perhaps its the same color as the background, sillier things are known to happen in developing!Hyperlink to file on shared drive
1. No, hosting the file on a web/ftp server is not possible.
2. Yes I know about the Jump-to-URL section.
3. Only http. https, ftp, mailto and news work. file does not.
4. Embedding Javascript (window.open('file://foo/bar.txt')) works, but
only if hardcoded, which is useless.
Is there a particular reason for this? Is this going to be fixed? My
client has thousands of files that lie on shared drive. I need to
create links to these in a manner such as:
<a href="http://links.10026.com/?link=file://s:\directory\file.txt">link</a>
I don't understand why you would limit the anchor tag? According to
RFC http://www.ietf.org/rfc/rfc1738.txt (This document specifies a
Uniform Resource Locator (URL), the syntax and semantics of formalized
information for location and access of resources via the Internet.)
You can state the following:
...
ftp File Transfer protocol
http Hypertext Transfer Protocol
mailto Electronic mail address
news USENET news
file Host-specific file names
...
Yes, I know that:
"The file URL scheme is used to designate files accessible on a
particular host computer. This scheme, unlike most other URL schemes,
does not designate a resource that is universally accessible over the
Internet"
But the thing is, MS Reports are for private networks, as well as
public ones. Why were the specs not followed?
Regards,
Roy AssalyAnyone? Bueller? Bueller? So I take it's impossible. Nobody in
Microsoft land knows if this will be fixed?
Roy Assaly wrote:
> 1. No, hosting the file on a web/ftp server is not possible.
> 2. Yes I know about the Jump-to-URL section.
> 3. Only http. https, ftp, mailto and news work. file does not.
> 4. Embedding Javascript (window.open('file://foo/bar.txt')) works, but
> only if hardcoded, which is useless.
> Is there a particular reason for this? Is this going to be fixed? My
> client has thousands of files that lie on shared drive. I need to
> create links to these in a manner such as:
> <a href="http://links.10026.com/?link=file://s:\directory\file.txt">link</a>
> I don't understand why you would limit the anchor tag? According to
> RFC http://www.ietf.org/rfc/rfc1738.txt (This document specifies a
> Uniform Resource Locator (URL), the syntax and semantics of formalized
> information for location and access of resources via the Internet.)
> You can state the following:
> ...
> ftp File Transfer protocol
> http Hypertext Transfer Protocol
> mailto Electronic mail address
> news USENET news
> file Host-specific file names
> ...
> Yes, I know that:
> "The file URL scheme is used to designate files accessible on a
> particular host computer. This scheme, unlike most other URL schemes,
> does not designate a resource that is universally accessible over the
> Internet"
> But the thing is, MS Reports are for private networks, as well as
> public ones. Why were the specs not followed?
> Regards,
> Roy Assaly
2. Yes I know about the Jump-to-URL section.
3. Only http. https, ftp, mailto and news work. file does not.
4. Embedding Javascript (window.open('file://foo/bar.txt')) works, but
only if hardcoded, which is useless.
Is there a particular reason for this? Is this going to be fixed? My
client has thousands of files that lie on shared drive. I need to
create links to these in a manner such as:
<a href="http://links.10026.com/?link=file://s:\directory\file.txt">link</a>
I don't understand why you would limit the anchor tag? According to
RFC http://www.ietf.org/rfc/rfc1738.txt (This document specifies a
Uniform Resource Locator (URL), the syntax and semantics of formalized
information for location and access of resources via the Internet.)
You can state the following:
...
ftp File Transfer protocol
http Hypertext Transfer Protocol
mailto Electronic mail address
news USENET news
file Host-specific file names
...
Yes, I know that:
"The file URL scheme is used to designate files accessible on a
particular host computer. This scheme, unlike most other URL schemes,
does not designate a resource that is universally accessible over the
Internet"
But the thing is, MS Reports are for private networks, as well as
public ones. Why were the specs not followed?
Regards,
Roy AssalyAnyone? Bueller? Bueller? So I take it's impossible. Nobody in
Microsoft land knows if this will be fixed?
Roy Assaly wrote:
> 1. No, hosting the file on a web/ftp server is not possible.
> 2. Yes I know about the Jump-to-URL section.
> 3. Only http. https, ftp, mailto and news work. file does not.
> 4. Embedding Javascript (window.open('file://foo/bar.txt')) works, but
> only if hardcoded, which is useless.
> Is there a particular reason for this? Is this going to be fixed? My
> client has thousands of files that lie on shared drive. I need to
> create links to these in a manner such as:
> <a href="http://links.10026.com/?link=file://s:\directory\file.txt">link</a>
> I don't understand why you would limit the anchor tag? According to
> RFC http://www.ietf.org/rfc/rfc1738.txt (This document specifies a
> Uniform Resource Locator (URL), the syntax and semantics of formalized
> information for location and access of resources via the Internet.)
> You can state the following:
> ...
> ftp File Transfer protocol
> http Hypertext Transfer Protocol
> mailto Electronic mail address
> news USENET news
> file Host-specific file names
> ...
> Yes, I know that:
> "The file URL scheme is used to designate files accessible on a
> particular host computer. This scheme, unlike most other URL schemes,
> does not designate a resource that is universally accessible over the
> Internet"
> But the thing is, MS Reports are for private networks, as well as
> public ones. Why were the specs not followed?
> Regards,
> Roy Assaly
Hyperlink to a new window
I have two hyperlink-related questions:
1. How can I generate a URL from within a query or stored procedure such that it appears as a hyperlink within the report? On my first attempt, the text of the link shows but it does not appear as a "live" link within the generated report.
2. Once I've achieved #1, how can I get that link appear in a new browser window rather than the one in which the report is currently displayed?
Thanks in advance for the advice.#1:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
#2: Take a look at _LinkTarget device info setting:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> I have two hyperlink-related questions:
> 1. How can I generate a URL from within a query or stored procedure such
that it appears as a hyperlink within the report? On my first attempt, the
text of the link shows but it does not appear as a "live" link within the
generated report.
> 2. Once I've achieved #1, how can I get that link appear in a new browser
window rather than the one in which the report is currently displayed?
> Thanks in advance for the advice.
>|||Your links proved unhelpful for the following reasons:
#1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
#2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
Example:
If my report gets information from the following query...
select url from urlsource
and urlsource contains
* http://www.site1.com/
* http://www.site2.com/
How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
"Ravi Mumulla (Microsoft)" wrote:
> #1:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> #2: Take a look at _LinkTarget device info setting:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > I have two hyperlink-related questions:
> >
> > 1. How can I generate a URL from within a query or stored procedure such
> that it appears as a hyperlink within the report? On my first attempt, the
> text of the link shows but it does not appear as a "live" link within the
> generated report.
> >
> > 2. Once I've achieved #1, how can I get that link appear in a new browser
> window rather than the one in which the report is currently displayed?
> >
> > Thanks in advance for the advice.
> >
>
>|||On the question of treating your field data as a URL, there is the URLEncode command.
=Web.HttpUtility.UrlEncode(Fields!Serial.Value)
(http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=
)
There is another thread that can answer some potential issues you may have with implementing this.
(http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=)
On your second question, about being able to open a link in a new window...if you are using Report Manager for your distribution platform, then there is NOT a current way to do so. Even if you are using the HTML Viewer and sending in rc: comands, it is an all or nothing deal - either all your links open in a new window or none of them do. I have sugested a few features that I hope MS will implement into one of their future SPs, but until that time, your options are few.
"virtualfergy" wrote:
> Your links proved unhelpful for the following reasons:
> #1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
> #2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
> Example:
> If my report gets information from the following query...
> select url from urlsource
> and urlsource contains
> * http://www.site1.com/
> * http://www.site2.com/
> How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
> "Ravi Mumulla (Microsoft)" wrote:
> > #1:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> > #2: Take a look at _LinkTarget device info setting:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> > "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> > news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > > I have two hyperlink-related questions:
> > >
> > > 1. How can I generate a URL from within a query or stored procedure such
> > that it appears as a hyperlink within the report? On my first attempt, the
> > text of the link shows but it does not appear as a "live" link within the
> > generated report.
> > >
> > > 2. Once I've achieved #1, how can I get that link appear in a new browser
> > window rather than the one in which the report is currently displayed?
> > >
> > > Thanks in advance for the advice.
> > >
> >
> >
> >|||Look at my post from 8/26:
I think I have a solution. If you want a particular link to be opened in a
new window, enter this into the "Jump to URL" field:
javascript:if(window.open(yourPage.aspx','RsWindow','width=400,height=500,location=0,menubar=0,status=0,toolbar=0,scrollbars=1',true)){}
"Rob 'Spike' Stevens" wrote:
> On the question of treating your field data as a URL, there is the URLEncode command.
> =Web.HttpUtility.UrlEncode(Fields!Serial.Value)
> (http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=
> )
> There is another thread that can answer some potential issues you may have with implementing this.
> (http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=)
> On your second question, about being able to open a link in a new window...if you are using Report Manager for your distribution platform, then there is NOT a current way to do so. Even if you are using the HTML Viewer and sending in rc: comands, it is an all or nothing deal - either all your links open in a new window or none of them do. I have sugested a few features that I hope MS will implement into one of their future SPs, but until that time, your options are few.
> "virtualfergy" wrote:
> > Your links proved unhelpful for the following reasons:
> >
> > #1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
> >
> > #2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
> >
> > Example:
> >
> > If my report gets information from the following query...
> >
> > select url from urlsource
> >
> > and urlsource contains
> >
> > * http://www.site1.com/
> > * http://www.site2.com/
> >
> > How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > #1:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> > > #2: Take a look at _LinkTarget device info setting:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> > > news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > > > I have two hyperlink-related questions:
> > > >
> > > > 1. How can I generate a URL from within a query or stored procedure such
> > > that it appears as a hyperlink within the report? On my first attempt, the
> > > text of the link shows but it does not appear as a "live" link within the
> > > generated report.
> > > >
> > > > 2. Once I've achieved #1, how can I get that link appear in a new browser
> > > window rather than the one in which the report is currently displayed?
> > > >
> > > > Thanks in advance for the advice.
> > > >
> > >
> > >
> > >
1. How can I generate a URL from within a query or stored procedure such that it appears as a hyperlink within the report? On my first attempt, the text of the link shows but it does not appear as a "live" link within the generated report.
2. Once I've achieved #1, how can I get that link appear in a new browser window rather than the one in which the report is currently displayed?
Thanks in advance for the advice.#1:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
#2: Take a look at _LinkTarget device info setting:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> I have two hyperlink-related questions:
> 1. How can I generate a URL from within a query or stored procedure such
that it appears as a hyperlink within the report? On my first attempt, the
text of the link shows but it does not appear as a "live" link within the
generated report.
> 2. Once I've achieved #1, how can I get that link appear in a new browser
window rather than the one in which the report is currently displayed?
> Thanks in advance for the advice.
>|||Your links proved unhelpful for the following reasons:
#1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
#2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
Example:
If my report gets information from the following query...
select url from urlsource
and urlsource contains
* http://www.site1.com/
* http://www.site2.com/
How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
"Ravi Mumulla (Microsoft)" wrote:
> #1:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> #2: Take a look at _LinkTarget device info setting:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > I have two hyperlink-related questions:
> >
> > 1. How can I generate a URL from within a query or stored procedure such
> that it appears as a hyperlink within the report? On my first attempt, the
> text of the link shows but it does not appear as a "live" link within the
> generated report.
> >
> > 2. Once I've achieved #1, how can I get that link appear in a new browser
> window rather than the one in which the report is currently displayed?
> >
> > Thanks in advance for the advice.
> >
>
>|||On the question of treating your field data as a URL, there is the URLEncode command.
=Web.HttpUtility.UrlEncode(Fields!Serial.Value)
(http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=
)
There is another thread that can answer some potential issues you may have with implementing this.
(http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=)
On your second question, about being able to open a link in a new window...if you are using Report Manager for your distribution platform, then there is NOT a current way to do so. Even if you are using the HTML Viewer and sending in rc: comands, it is an all or nothing deal - either all your links open in a new window or none of them do. I have sugested a few features that I hope MS will implement into one of their future SPs, but until that time, your options are few.
"virtualfergy" wrote:
> Your links proved unhelpful for the following reasons:
> #1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
> #2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
> Example:
> If my report gets information from the following query...
> select url from urlsource
> and urlsource contains
> * http://www.site1.com/
> * http://www.site2.com/
> How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
> "Ravi Mumulla (Microsoft)" wrote:
> > #1:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> > #2: Take a look at _LinkTarget device info setting:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> > "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> > news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > > I have two hyperlink-related questions:
> > >
> > > 1. How can I generate a URL from within a query or stored procedure such
> > that it appears as a hyperlink within the report? On my first attempt, the
> > text of the link shows but it does not appear as a "live" link within the
> > generated report.
> > >
> > > 2. Once I've achieved #1, how can I get that link appear in a new browser
> > window rather than the one in which the report is currently displayed?
> > >
> > > Thanks in advance for the advice.
> > >
> >
> >
> >|||Look at my post from 8/26:
I think I have a solution. If you want a particular link to be opened in a
new window, enter this into the "Jump to URL" field:
javascript:if(window.open(yourPage.aspx','RsWindow','width=400,height=500,location=0,menubar=0,status=0,toolbar=0,scrollbars=1',true)){}
"Rob 'Spike' Stevens" wrote:
> On the question of treating your field data as a URL, there is the URLEncode command.
> =Web.HttpUtility.UrlEncode(Fields!Serial.Value)
> (http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=
> )
> There is another thread that can answer some potential issues you may have with implementing this.
> (http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=)
> On your second question, about being able to open a link in a new window...if you are using Report Manager for your distribution platform, then there is NOT a current way to do so. Even if you are using the HTML Viewer and sending in rc: comands, it is an all or nothing deal - either all your links open in a new window or none of them do. I have sugested a few features that I hope MS will implement into one of their future SPs, but until that time, your options are few.
> "virtualfergy" wrote:
> > Your links proved unhelpful for the following reasons:
> >
> > #1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
> >
> > #2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
> >
> > Example:
> >
> > If my report gets information from the following query...
> >
> > select url from urlsource
> >
> > and urlsource contains
> >
> > * http://www.site1.com/
> > * http://www.site2.com/
> >
> > How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > #1:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> > > #2: Take a look at _LinkTarget device info setting:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> > > news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > > > I have two hyperlink-related questions:
> > > >
> > > > 1. How can I generate a URL from within a query or stored procedure such
> > > that it appears as a hyperlink within the report? On my first attempt, the
> > > text of the link shows but it does not appear as a "live" link within the
> > > generated report.
> > > >
> > > > 2. Once I've achieved #1, how can I get that link appear in a new browser
> > > window rather than the one in which the report is currently displayed?
> > > >
> > > > Thanks in advance for the advice.
> > > >
> > >
> > >
> > >
hyperlink to a blob field
I want to populate a field (A BLOB maybe?) with a html page that I have generated. I would like to be able to set a hyperlink to this field so users can see it by clicking on the link. Is it possible?
-RichYes you can by using XML.
-RichYes you can by using XML.
Hyperlink Target property in SharePoint 2007 Report Viewer Web Part
SharePoint 2007. I have the SSRS Web Part embedded in a page as part
of the dashboard. The SSRS Report displayed in the SSRS Web Part
contains a link (aka Jump To Report) to a second report. I want the
second report to open in the parent SharePoint page, not in the Web
Part.
The Web Part contains a property called "Hyperlink Target", which
should specify where hyperlinks are opened. Even if I set this
property to be "_blank", the second report opens inside of the web
part.
Had anyone been able to use the "Hyperlink Target" of the Sharepoint
2007 SSRS Web Part?Anyone?
of the dashboard. The SSRS Report displayed in the SSRS Web Part
contains a link (aka Jump To Report) to a second report. I want the
second report to open in the parent SharePoint page, not in the Web
Part.
The Web Part contains a property called "Hyperlink Target", which
should specify where hyperlinks are opened. Even if I set this
property to be "_blank", the second report opens inside of the web
part.
Had anyone been able to use the "Hyperlink Target" of the Sharepoint
2007 SSRS Web Part?Anyone?
Hyperlink Target in SharePoint Report Viewer Web Part
Has anyone been successful in configuring the Hyperlink Target property in the SSRS Sharepoint Web Part? I've tried every setting, including _blank, yet the behavior does not change.
Am I doing something incorrectly or is this not implemented correctly?
I couldnt got it properly, are you trying to deploy a report in sharepoint (2007 or 2003?).
Can you please rephrase you q. ?
Priyank
|||SharePoint 2007. I have the SSRS Web Part embedded in a page as part of the dashboard. The SSRS Report displayed in the SSRS Web Part contains a link (aka Jump To Report) to a second report. I want the second report to open in the parent SharePoint page, not in the Web Part.The Web Part contains a property called "Hyperlink Target", which should specify where hyperlinks are opened. Even if I set this property to be "_blank", the second report opens inside of the web part.
Had anyone been able to use the "Hyperlink Target" of the Sharepoint 2007 SSRS Web Part?
Hyperlink Target in Same Frame
I'm having trouble creating a hyperlink that opens the page in the same frame (_self). I have a report being displayed in a frame, and want a hyperlink to stay in the same frame. I've read all about opening a new window, etc., etc., but the techniques I've read about don't work for the "_self" target.
I've tried appending the "&rc:LinkTarget=_self" to the URL, but that doesn't work. I've also tried the javascrippt options but they don't work either. They work fine for opening a new window, but not for staying in the same frame.
When I look at the source code generated for a hyperlink in a report page, it specifically spells-out "target=_top" in the resultant code, even though I'm not specifying that anywhere. If I could only suppress that, then it might work and stay in the same frame.
Can anyone help here? Thanks.
Did you happen to solve this issue? I was just trying to do the same thing and I'm not getting anywhere.
Thanks,
Derek
|||Derek,
I had to add the target parameter in the report control on the web page:
<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" PromptAreaCollapsed="True" Width="100%" Height="98%" HyperlinkTarget="_self">
Now, I'm not sure if it's still needed, but I also have this in the hyperlink in the report XML:
<Action>
<Hyperlink>="http://www.somewhere.com/Page.aspx?ID=" & trim(Fields!ID.Value) & "&rc:LinkTarget=_self"</Hyperlink>
</Action>
This worked and now the hyperlinks in the reports stay in the same frame. Hope this helps!
Dan
Hyperlink Target in Same Frame
I'm having trouble creating a hyperlink that opens the page in the same frame (_self). I have a report being displayed in a frame, and want a hyperlink to stay in the same frame. I've read all about opening a new window, etc., etc., but the techniques I've read about don't work for the "_self" target.
I've tried appending the "&rc:LinkTarget=_self" to the URL, but that doesn't work. I've also tried the javascrippt options but they don't work either. They work fine for opening a new window, but not for staying in the same frame.
When I look at the source code generated for a hyperlink in a report page, it specifically spells-out "target=_top" in the resultant code, even though I'm not specifying that anywhere. If I could only suppress that, then it might work and stay in the same frame.
Can anyone help here? Thanks.
Did you happen to solve this issue? I was just trying to do the same thing and I'm not getting anywhere.
Thanks,
Derek
|||Derek,
I had to add the target parameter in the report control on the web page:
<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" PromptAreaCollapsed="True" Width="100%" Height="98%" HyperlinkTarget="_self">
Now, I'm not sure if it's still needed, but I also have this in the hyperlink in the report XML:
<Action>
<Hyperlink>="http://www.somewhere.com/Page.aspx?ID=" & trim(Fields!ID.Value) & "&rc:LinkTarget=_self"</Hyperlink>
</Action>
This worked and now the hyperlinks in the reports stay in the same frame. Hope this helps!
Dan
Hyperlink section of TextBox?
Is it possible to hyperlink one word in the middle of a TextBox?
I could put an action on the TextBox, but don't want the hyperlink to cover
the entire paragraph. The output is in PDF, so I can't use an jscript
tricks.
Thanks,
GlenNo, this is not possible. Rich text, including formatting and links within
text, is on the list for a post SQL 2005 release.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Glen" <glittle@.sunwaptasolutions.RemoveThis.com> wrote in message
news:%23b1MQZRSFHA.3144@.tk2msftngp13.phx.gbl...
> Is it possible to hyperlink one word in the middle of a TextBox?
> I could put an action on the TextBox, but don't want the hyperlink to
> cover the entire paragraph. The output is in PDF, so I can't use an
> jscript tricks.
> Thanks,
> Glen
>
I could put an action on the TextBox, but don't want the hyperlink to cover
the entire paragraph. The output is in PDF, so I can't use an jscript
tricks.
Thanks,
GlenNo, this is not possible. Rich text, including formatting and links within
text, is on the list for a post SQL 2005 release.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Glen" <glittle@.sunwaptasolutions.RemoveThis.com> wrote in message
news:%23b1MQZRSFHA.3144@.tk2msftngp13.phx.gbl...
> Is it possible to hyperlink one word in the middle of a TextBox?
> I could put an action on the TextBox, but don't want the hyperlink to
> cover the entire paragraph. The output is in PDF, so I can't use an
> jscript tricks.
> Thanks,
> Glen
>
Hyperlink report in new page..Urgent
I am working with two reports. The first reprot has a hyperlink to a textbox which opens a second report. This all works fine, but the when the hyperlink is clicked the second report open on top of the first report. I want the second report to open in a another seperate window, so that i can view two reports at the same time.
Can you please help me .. it's urgent.
Hi
try this I found it on Google
=void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"
it worked for me.
(you have to deploy it to test it)
|||forgot.
use ="java_script: (before void, remove the _ )
="java_script:void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"
|||I use
="java_script:void(window.open('" & "http://server06/ReportServer$Server062005" & "/Pages/ReportViewer.aspx?%2fAccount+Receivable%2fFinishGoodAtyAndNetModelType&Customer="& Fields!Customer.Value & "&Period=" & Fields!Period.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"
but when clicking the link:
http://server06/ReportServer$Server062005?%2fAccount+Receivable%2fFinishGoodAtyAndNetModelType&Customer=HUONG+THUY&Period=200602&rs%3aFormat=HTML4.0%27%2c%27_blank%27%2c%27resizable%3dyes%27))
and web page display the error mesaage:
Reporting Services Error
An attempt has been made to use a rendering extension that is not registered for this report server. (rsRenderingExtensionNotFound) Get Online Help|||i tried ="java_script:void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"
with removing the "_" from java_script...
but stil it does not work..
i have the sp1 & sp2 intalled with hot fix..
please help
HyperLink problem
Hi Experts,
I am new to SQL Reporting.
In my report, i have lots of links from the data, which when the user
clicks, redirects to another report. But now the report comes in the same
page. I want the second report to be popped in a different page. Is there
any provision for setting the target of the hyperlink in the report'
Thanking you in advance
GaneshI just answered a very similar question here:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/d2622b6f6d6060c5/7cf0dbb2dbca05d3#7cf0dbb2dbca05d3
Correct me if I misunderstood.
Regards,
Dan|||Dan,
My problem is a bit different. I want to jump to another report rather than
another page. So I have specified a report name in the Jump to Report
property of the report.
Regards
Ganesh
"Dan" <daniel.lenz@.qg.com> wrote in message
news:1142347674.682489.51780@.i39g2000cwa.googlegroups.com...
>I just answered a very similar question here:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/d2622b6f6d6060c5/7cf0dbb2dbca05d3#7cf0dbb2dbca05d3
>
> Correct me if I misunderstood.
> Regards,
> Dan
>|||Specifically try this post:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/b7ae5adaf7bc1e6e
I am new to SQL Reporting.
In my report, i have lots of links from the data, which when the user
clicks, redirects to another report. But now the report comes in the same
page. I want the second report to be popped in a different page. Is there
any provision for setting the target of the hyperlink in the report'
Thanking you in advance
GaneshI just answered a very similar question here:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/d2622b6f6d6060c5/7cf0dbb2dbca05d3#7cf0dbb2dbca05d3
Correct me if I misunderstood.
Regards,
Dan|||Dan,
My problem is a bit different. I want to jump to another report rather than
another page. So I have specified a report name in the Jump to Report
property of the report.
Regards
Ganesh
"Dan" <daniel.lenz@.qg.com> wrote in message
news:1142347674.682489.51780@.i39g2000cwa.googlegroups.com...
>I just answered a very similar question here:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/d2622b6f6d6060c5/7cf0dbb2dbca05d3#7cf0dbb2dbca05d3
>
> Correct me if I misunderstood.
> Regards,
> Dan
>|||Specifically try this post:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/b7ae5adaf7bc1e6e
hyperlink open new window
I have a link on my report which open new window. The code i have in advance properties of that field is :
="javascriptt:void(window.open('http://www.msn.com','_blank'))" (note: the extra "t" is intentionally added in the code, coz website block the keyword "java.....t")
It works great on testing server but it doesn't work on production server. Both testing and production servers run windows 2003 server and service pack 2 for reporting services.
Reports accessing form production server, when i click on report it opens up new window with address in address bar :
javascript:void(window.open('http://www.msn.com','_blank')) with "The page cannot be displayed" message. But if i open a new internet explorer window and copy past the same address in address bar then its open up www.msn.com. To test the production server behavior I created a test web page test.htm and added the java script to open new window, it works fine.
Any help would be much appreciated.
Ive had problems with this too!I found it only works when you access the report via a URL such as
http://reportserver/reportserver?report
Rather than through the Report Manager:
http://reportserver/reports
Through the Report Manager I saw the same behaiviour "The page cannot be displayed" message but copying and pasting worked :S
Although Im not surew this is your problem as it works on your tst server, but not prod
Hope this helps
Al
Hyperlink on a report to download a file
I have an XML field (of type XML) in my report's underlying table. I want to
display a hyperlink in my report. When the user clicks on this hyperlink, I
want them to be able to save the xml value as an XML file on disk (i.e.
"Save File As" in MSIE). Has anyone tried this?
Thank you,
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.comYou might be able to use javascript to make it open the file in a new
window.|||Any luck on getting this to work? I'm trying to do the same thing but can't
find any way to do it.|||Nope. I even reposted with the subject "XML field content to be downloaded
as a file" in case my first post wasn't clear enough. But no luck.
I'll keep watching and/or post the answer if I ever figure out a way of
doing it.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Elliott" <Elliott@.discussions.microsoft.com> wrote in message
news:A0650A48-7DAB-42AE-A300-8A9DA17E5401@.microsoft.com...
> Any luck on getting this to work? I'm trying to do the same thing but
> can't
> find any way to do it.
>|||This is the closest possible solution I've found so far and it's from a
Microsoft employee:
http://tinyurl.com/2gs6sp
Basically you'd just have to create a separate web page/site that serves up
the file/xml from a hyperlink in the report. Not quite as easy has getting
it right out of the report directly, but it's definitely doable for my
project.
I'd be happy enough if the report would let me just display the xml with an
associated xsl file.|||Displaying the XML content on your report is pretty easy. Just put the
field's value in a gird like you would any other field type (char, int,
float, etc.). It's just that the cell containing the XML gets pretty big.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Elliott" <Elliott@.discussions.microsoft.com> wrote in message
news:3EE4182B-7C2C-4A37-A71F-F007DE1D6A5C@.microsoft.com...
> This is the closest possible solution I've found so far and it's from a
> Microsoft employee:
> http://tinyurl.com/2gs6sp
> Basically you'd just have to create a separate web page/site that serves
> up
> the file/xml from a hyperlink in the report. Not quite as easy has
> getting
> it right out of the report directly, but it's definitely doable for my
> project.
> I'd be happy enough if the report would let me just display the xml with
> an
> associated xsl file.|||Yeah, I realized I could do that. However I need mine formatted for the
users; I didn't want them to see the raw xml. If they could download it
directly from the report and open it in IE (which is default), then they'd
see it formatted like a webpage since the xml references an xsl file. That
would have been my preference.
Anyway, I took Chris Hays' advice and implemented a small ASP.NET site that
serves up the xml file with the xsl. It was pretty painless and took about
an hour.
display a hyperlink in my report. When the user clicks on this hyperlink, I
want them to be able to save the xml value as an XML file on disk (i.e.
"Save File As" in MSIE). Has anyone tried this?
Thank you,
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.comYou might be able to use javascript to make it open the file in a new
window.|||Any luck on getting this to work? I'm trying to do the same thing but can't
find any way to do it.|||Nope. I even reposted with the subject "XML field content to be downloaded
as a file" in case my first post wasn't clear enough. But no luck.
I'll keep watching and/or post the answer if I ever figure out a way of
doing it.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Elliott" <Elliott@.discussions.microsoft.com> wrote in message
news:A0650A48-7DAB-42AE-A300-8A9DA17E5401@.microsoft.com...
> Any luck on getting this to work? I'm trying to do the same thing but
> can't
> find any way to do it.
>|||This is the closest possible solution I've found so far and it's from a
Microsoft employee:
http://tinyurl.com/2gs6sp
Basically you'd just have to create a separate web page/site that serves up
the file/xml from a hyperlink in the report. Not quite as easy has getting
it right out of the report directly, but it's definitely doable for my
project.
I'd be happy enough if the report would let me just display the xml with an
associated xsl file.|||Displaying the XML content on your report is pretty easy. Just put the
field's value in a gird like you would any other field type (char, int,
float, etc.). It's just that the cell containing the XML gets pretty big.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Elliott" <Elliott@.discussions.microsoft.com> wrote in message
news:3EE4182B-7C2C-4A37-A71F-F007DE1D6A5C@.microsoft.com...
> This is the closest possible solution I've found so far and it's from a
> Microsoft employee:
> http://tinyurl.com/2gs6sp
> Basically you'd just have to create a separate web page/site that serves
> up
> the file/xml from a hyperlink in the report. Not quite as easy has
> getting
> it right out of the report directly, but it's definitely doable for my
> project.
> I'd be happy enough if the report would let me just display the xml with
> an
> associated xsl file.|||Yeah, I realized I could do that. However I need mine formatted for the
users; I didn't want them to see the raw xml. If they could download it
directly from the report and open it in IE (which is default), then they'd
see it formatted like a webpage since the xml references an xsl file. That
would have been my preference.
Anyway, I took Chris Hays' advice and implemented a small ASP.NET site that
serves up the xml file with the xsl. It was pretty painless and took about
an hour.
Hyperlink not working when rendered in PDF
Hi,
I have a popup window that opens a server report in PDF format using URL
access and within this report there are hyperlinks to webpages.On clicking
the hyperlinks from within the report we get the following error :
"Internet explorer cannot download.Unspecified error".
we have used javascript in the jump to URL expression:
="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid=" +
Trim(Cstr(Fields!ProjectUID.Value)) + "','_blank','location=no,toolbar=no'))"
Kindly advice.On Dec 14, 1:28 pm, Prabhakar <Prabha...@.discussions.microsoft.com>
wrote:
> Hi,
> I have a popup window that opens a server report in PDF format using URL
> access and within this report there are hyperlinks to webpages.On clicking
> the hyperlinks from within the report we get the following error :
> "Internet explorer cannot download.Unspecified error".
> we have used javascript in the jump to URL expression:
> ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid=" +
> Trim(Cstr(Fields!ProjectUID.Value)) + "','_blank','location=no,toolbar=no'))"
> Kindly advice.
It sounds like there is either an ActiveX control or an image/etc that
is blocked in Internet Explorer (I'm assuming your default browser)
that exists on the project.aspx page. You might want to allow ActiveX
in the Internet Explorer settings (note that this could be a security
risk outside your process). Also, there might be an error in the
project.aspx page itself. I would guess that this would not throw an
error in Firefox. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
I have a popup window that opens a server report in PDF format using URL
access and within this report there are hyperlinks to webpages.On clicking
the hyperlinks from within the report we get the following error :
"Internet explorer cannot download.Unspecified error".
we have used javascript in the jump to URL expression:
="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid=" +
Trim(Cstr(Fields!ProjectUID.Value)) + "','_blank','location=no,toolbar=no'))"
Kindly advice.On Dec 14, 1:28 pm, Prabhakar <Prabha...@.discussions.microsoft.com>
wrote:
> Hi,
> I have a popup window that opens a server report in PDF format using URL
> access and within this report there are hyperlinks to webpages.On clicking
> the hyperlinks from within the report we get the following error :
> "Internet explorer cannot download.Unspecified error".
> we have used javascript in the jump to URL expression:
> ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid=" +
> Trim(Cstr(Fields!ProjectUID.Value)) + "','_blank','location=no,toolbar=no'))"
> Kindly advice.
It sounds like there is either an ActiveX control or an image/etc that
is blocked in Internet Explorer (I'm assuming your default browser)
that exists on the project.aspx page. You might want to allow ActiveX
in the Internet Explorer settings (note that this could be a security
risk outside your process). Also, there might be an error in the
project.aspx page itself. I would guess that this would not throw an
error in Firefox. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Subscribe to:
Posts (Atom)