cancel
Showing results for 
Search instead for 
Did you mean: 

How to open URLs from report column in a new window

Pawel_Bajcer
Level 2

Hello,

 

Could someone help me to create drill down on report to be able to open URLs which are result of following SQL code:

 

DECLARE @v1_Package_ID uniqueidentifier
   SET @v1_Package_ID = '%Package_ID%'
SELECT       

p1.URL,
s2.Name
FROM SWDPackageCodebase p1     
left join SWDPackage s2 on p1.PackageId = s2.PackageId     
 WHERE
   (
      (
         (s2.[PackageId] = @v1_Package_ID)
      )
   )
GROUP BY p1.URL, s2.Name

  ]]>

I would like to be able to open each URL using reight-click or double click (is it possible)

and report results are like below:

 

 

URL    Name   
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache  
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache  
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache  
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache  
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache  
file://servername/PkgSvrHostD$/{0C6C4E06-940A-47B9-8187-C9E4A4C05E21}/cache

 

1 REPLY 1

_r___
Level 6
Certified

What Symantec product is this for? I can move it to the correct forum for better visibility.