How to make elements of a field into hyperlinks

Hi,
I've been looking high and low for a way to turn the elements of a
field into hyperlinks and so far I've found nothing. One of the fields
in my report holds all the document hyperlinks pertaining to that
particular record. For example, if the record is about employee A, I
have a field that holds all the document links to employee A like his
security clearance form, annual review documents, etc. All of these
forms were scanned and saved to the HR server. I could extract the
document path "http://companyServer/hr/employeeA/annual review1.pdf;
http://companyServer/hr/employeeA/security clearance form.pdf" and
display them to a field on the report but Reporting Services does not
recognize it as a hyperlink. Is there a way to make each one into a
hyperlink so that the user can click on it and it would open the
respective document in pdf? Please help.
Thank you all,
JonHi Jon,
Have you tried different Naviagton option of Text box property.
You can r you can "jump to a UR"L or jump to a report .
you can use a formula to jump to the pdf file which will be downloaded to
the IE and the user can see it.
Cheers
Bava
"Newbie" wrote:
> Hi,
> I've been looking high and low for a way to turn the elements of a
> field into hyperlinks and so far I've found nothing. One of the fields
> in my report holds all the document hyperlinks pertaining to that
> particular record. For example, if the record is about employee A, I
> have a field that holds all the document links to employee A like his
> security clearance form, annual review documents, etc. All of these
> forms were scanned and saved to the HR server. I could extract the
> document path "http://companyServer/hr/employeeA/annual review1.pdf;
> http://companyServer/hr/employeeA/security clearance form.pdf" and
> display them to a field on the report but Reporting Services does not
> recognize it as a hyperlink. Is there a way to make each one into a
> hyperlink so that the user can click on it and it would open the
> respective document in pdf? Please help.
>
> Thank you all,
> Jon
>|||Correct. He needs to use Jump To Url action on a field. I make the field
underline and blue so users know to click on it. The URL is based on an
expression and hence is very flexible in how you assemble the URL. Plus, you
can cause it to open in another window or in the same window.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
I am using parameters but you could use the value of the field as well. I do
that quite often.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bava Mani" <BavaMani@.discussions.microsoft.com> wrote in message
news:F6268370-6FB3-468B-9AD8-6B41CA33EFEE@.microsoft.com...
> Hi Jon,
> Have you tried different Naviagton option of Text box property.
> You can r you can "jump to a UR"L or jump to a report .
> you can use a formula to jump to the pdf file which will be downloaded to
> the IE and the user can see it.
> Cheers
> Bava
> "Newbie" wrote:
>> Hi,
>> I've been looking high and low for a way to turn the elements of a
>> field into hyperlinks and so far I've found nothing. One of the fields
>> in my report holds all the document hyperlinks pertaining to that
>> particular record. For example, if the record is about employee A, I
>> have a field that holds all the document links to employee A like his
>> security clearance form, annual review documents, etc. All of these
>> forms were scanned and saved to the HR server. I could extract the
>> document path "http://companyServer/hr/employeeA/annual review1.pdf;
>> http://companyServer/hr/employeeA/security clearance form.pdf" and
>> display them to a field on the report but Reporting Services does not
>> recognize it as a hyperlink. Is there a way to make each one into a
>> hyperlink so that the user can click on it and it would open the
>> respective document in pdf? Please help.
>>
>> Thank you all,
>> Jon
>>|||Hi Bruce,
I have a related question on this.
you have explained how to proivde hyperlinks in the reports, but can we
provide
a hyperlink in the parameter section of the report page to provide a simple
link that when the user click the hyperlink it will open a window where they
will be prompted
to enter value for the parameter or enter multi select parameter.
I know microsoft providing Multiselect option in 2005 but still there are
not providing option for boolean type parameter where the user can enter
complex search condition with boolan condition in the parameter value. Is
there a way to provide a hyper link for parameter selection so that data for
the parameter is populated from another page. Please let me know if you know
any knowledge on this. Is there any 3rd party product do this customization.
Thanks in advance
Bava
"Bruce L-C [MVP]" wrote:
> Correct. He needs to use Jump To Url action on a field. I make the field
> underline and blue so users know to click on it. The URL is based on an
> expression and hence is very flexible in how you assemble the URL. Plus, you
> can cause it to open in another window or in the same window.
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
>
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
> I am using parameters but you could use the value of the field as well. I do
> that quite often.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Bava Mani" <BavaMani@.discussions.microsoft.com> wrote in message
> news:F6268370-6FB3-468B-9AD8-6B41CA33EFEE@.microsoft.com...
> > Hi Jon,
> > Have you tried different Naviagton option of Text box property.
> > You can r you can "jump to a UR"L or jump to a report .
> > you can use a formula to jump to the pdf file which will be downloaded to
> > the IE and the user can see it.
> >
> > Cheers
> > Bava
> >
> > "Newbie" wrote:
> >
> >> Hi,
> >>
> >> I've been looking high and low for a way to turn the elements of a
> >> field into hyperlinks and so far I've found nothing. One of the fields
> >>
> >> in my report holds all the document hyperlinks pertaining to that
> >> particular record. For example, if the record is about employee A, I
> >> have a field that holds all the document links to employee A like his
> >> security clearance form, annual review documents, etc. All of these
> >> forms were scanned and saved to the HR server. I could extract the
> >> document path "http://companyServer/hr/employeeA/annual review1.pdf;
> >> http://companyServer/hr/employeeA/security clearance form.pdf" and
> >> display them to a field on the report but Reporting Services does not
> >> recognize it as a hyperlink. Is there a way to make each one into a
> >> hyperlink so that the user can click on it and it would open the
> >> respective document in pdf? Please help.
> >>
> >>
> >> Thank you all,
> >> Jon
> >>
> >>
>
>|||Hi gracious helpers,
I've been busy with other aspects of my project and I totally forgot
about following up on my question. I'll give your suggestion a try.
I've also posted another question on whether or not the "Show Details"
button can be disabled or hidden. Can that be done? Thank you so much
for your generosity.
--Jon
Bruce L-C [MVP] wrote:
> Correct. He needs to use Jump To Url action on a field. I make the field
> underline and blue so users know to click on it. The URL is based on an
> expression and hence is very flexible in how you assemble the URL. Plus, you
> can cause it to open in another window or in the same window.
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
>
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
> I am using parameters but you could use the value of the field as well. I do
> that quite often.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Bava Mani" <BavaMani@.discussions.microsoft.com> wrote in message
> news:F6268370-6FB3-468B-9AD8-6B41CA33EFEE@.microsoft.com...
> > Hi Jon,
> > Have you tried different Naviagton option of Text box property.
> > You can r you can "jump to a UR"L or jump to a report .
> > you can use a formula to jump to the pdf file which will be downloaded to
> > the IE and the user can see it.
> >
> > Cheers
> > Bava
> >
> > "Newbie" wrote:
> >
> >> Hi,
> >>
> >> I've been looking high and low for a way to turn the elements of a
> >> field into hyperlinks and so far I've found nothing. One of the fields
> >>
> >> in my report holds all the document hyperlinks pertaining to that
> >> particular record. For example, if the record is about employee A, I
> >> have a field that holds all the document links to employee A like his
> >> security clearance form, annual review documents, etc. All of these
> >> forms were scanned and saved to the HR server. I could extract the
> >> document path "http://companyServer/hr/employeeA/annual review1.pdf;
> >> http://companyServer/hr/employeeA/security clearance form.pdf" and
> >> display them to a field on the report but Reporting Services does not
> >> recognize it as a hyperlink. Is there a way to make each one into a
> >> hyperlink so that the user can click on it and it would open the
> >> respective document in pdf? Please help.
> >>
> >>
> >> Thank you all,
> >> Jon
> >>
> >>|||Hi Bruce,
Thank you so very much for your help. I've been busy on other aspects
of my project and totally forgot about this until today when I
revisited it. I'll give you suggestion a try. Please help me again
should I stumble. I've also posted another question on how to hide or
disable the "Show Detail" button. Can that be done?
Thanks a million,
Jon
Bruce L-C [MVP] wrote:
> Correct. He needs to use Jump To Url action on a field. I make the field
> underline and blue so users know to click on it. The URL is based on an
> expression and hence is very flexible in how you assemble the URL. Plus, you
> can cause it to open in another window or in the same window.
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
>
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
> I am using parameters but you could use the value of the field as well. I do
> that quite often.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Bava Mani" <BavaMani@.discussions.microsoft.com> wrote in message
> news:F6268370-6FB3-468B-9AD8-6B41CA33EFEE@.microsoft.com...
> > Hi Jon,
> > Have you tried different Naviagton option of Text box property.
> > You can r you can "jump to a UR"L or jump to a report .
> > you can use a formula to jump to the pdf file which will be downloaded to
> > the IE and the user can see it.
> >
> > Cheers
> > Bava
> >
> > "Newbie" wrote:
> >
> >> Hi,
> >>
> >> I've been looking high and low for a way to turn the elements of a
> >> field into hyperlinks and so far I've found nothing. One of the fields
> >>
> >> in my report holds all the document hyperlinks pertaining to that
> >> particular record. For example, if the record is about employee A, I
> >> have a field that holds all the document links to employee A like his
> >> security clearance form, annual review documents, etc. All of these
> >> forms were scanned and saved to the HR server. I could extract the
> >> document path "http://companyServer/hr/employeeA/annual review1.pdf;
> >> http://companyServer/hr/employeeA/security clearance form.pdf" and
> >> display them to a field on the report but Reporting Services does not
> >> recognize it as a hyperlink. Is there a way to make each one into a
> >> hyperlink so that the user can click on it and it would open the
> >> respective document in pdf? Please help.
> >>
> >>
> >> Thank you all,
> >> Jon
> >>
> >>sql