Hyperlinks to scan docs - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Hyperlinks to scan docs

Author

Topic

muzzettemm
Posting Yak Master

212 Posts

Posted - 2008-10-27 : 12:17:06

Hi all I am trying to implement hyperlinks into report services. We have an ADP access on the front end and SQL Server 2005 as the engine. After we are done scanning documents we hyperlink them to the database, each record has its own documents. How do I implement taht into report services, I have tried and its just not working. Any idea??

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-27 : 12:47:53

you can add hyperlink by using jump to url option available in navigation tab of table/matrix cell properties.

muzzettemm
Posting Yak Master

212 Posts

Posted - 2008-10-27 : 13:35:22

I have tried that, but when I click on it I get an error message saying it can not compile it
heres an example this one of the links
\\gcsql\DataBase\Surveillance\Scanned Patron 86'ed\2005\Joshua Hayes 4-12-05.pdf
but it will not go to that scanned file.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-27 : 13:41:38

nope you cant just give a path like that. you need to give a javascript function to open the link in new window like window.open

muzzettemm
Posting Yak Master

212 Posts

Posted - 2008-10-27 : 13:44:35

Ok, how would I do that can you please explain? would I put window.open some where in the address or in Jump UrL how would I implement that???

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-27 : 13:46:11

is your attempt to export report data to pdf file?

muzzettemm
Posting Yak Master

212 Posts

Posted - 2008-10-27 : 13:52:31

No I just want to open up the scanned pdf file through report services just like we do in the database. We only want ot open it.

muzzettemm
Posting Yak Master

212 Posts

Posted - 2008-10-27 : 14:04:49

I looked in BOL and I looked at the code of the report servics. The fields is called PicturesLink

<Textbox Name="PicturesLink">
                      <rd:DefaultName>PicturesLink</rd:DefaultName>
                      <Action>
                        <Hyperlink>=<script language="JScript">
function myOpen() {
    open('about:blank');}
</script>
<body onclick="myOpen();">
Click this page and window.open() is called.
</body></Hyperlink>
                      </Action>

Am I suppose to alter that or something??

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-27 : 14:10:53

quote:

Originally posted by muzzettemm

I looked in BOL and I looked at the code of the report servics. The fields is called PicturesLink

<Textbox Name="PicturesLink">
                      <rd:DefaultName>PicturesLink</rd:DefaultName>
                      <Action>
                        <Hyperlink>=<script language="JScript">
function myOpen() {
    open('about:blank');}
</script>
<body onclick="myOpen();">
Click this page and window.open() is called.
</body></Hyperlink>
                      </Action>

Am I suppose to alter that or something??

alter that to give your pdf file path instead of aboutblank

muzzettemm
Posting Yak Master

212 Posts

Posted - 2008-10-27 : 14:59:51

so where it says about blank I should put in?

\\gcsql\DataBase\Surveillance\Scanned Patron 86'ed\2005\Joshua Hayes 4-12-05.pdf

muzzettemm
Posting Yak Master

212 Posts

Posted - 2008-10-27 : 15:01:14

here is the error message it gives me

Deserialization failed: The element 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Hyperlink' cannot contain child element 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:script' because the parent element's content model is text only. Line 251, position 37.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources