1. 

   bushraj, Member

   Hi,

   Can i use hyperlinks of any website in columns of table and then exactly export it in excel like for example :

   ID Links

   1 http://www.abc.php?id=1
   2 http://www.abc.php?id=2

   Do reply .

   Thanks
2. 

   myDBR Team, Key Master

   Yes,
   you can use the dbr.url-command to make the hyperlink:

   declare v_base varchar(50);
   
   set v_base = 'http://www.abc.php?id=';
   
   select 'dbr.url', v_base, '', '[Links]','=1';
   
   select ID, concat(v_base, id ) as 'Links'
   
   from mydata;
   
   

   --
   myDBR Team
3. 

   bushraj, Member

   Thanks for replying. I used this method but the URL generation is with additonal ampersand sign(&). It is generating the link as :

   http://tracker/notes.php?PME_sys_rec=&3793

   i want to generate it like :

   http://tracker/notes.php?PME_sys_rec=3793 (with out & sign)

   My code is :

   DROP PROCEDURE IF EXISTS sp_DBR_Test
   $$
   CREATE PROCEDURE sp_DBR_Test( Product varchar(300) ,Organization VARCHAR(300) , SeverityLevel VARCHAR(100) , Category VARCHAR(300) , StartDate date , EndDate date , CurrentProgress VARCHAR(300) , Team VARCHAR(300) )
   BEGIN
   declare v_base varchar(50);
   set v_base = 'View Details';
   select 'dbr.url', 'http://tracker/notes.php?PME_sys_rec=', ' ', '[Link To Efforts On Live]', '=2' ;

   select concat(V_base) as 'Link To Efforts On Live',
   s.APP_NUMBER as 'Case Number' ,
   s.txtCallID as 'Call ID',
   s.textCallSummary as 'Call Summary',
   s.cmbIssueCategory as 'Issue Category',
   s.cmbSeverityLevel as 'Severity Level',
   s.cmbProduct as 'Product',
   s.txtClientOrganization as 'Organization',
   s.LastModificationDateTime as 'Last Modification Date',
   s.cmbCurrentProgress as 'Status'

   from rpworkflow.supportmasterrecords s, wf_workflow.tps_lut_teams t
   where s.cmbproduct = product && s.txtClientOrganization = Organization && s.cmbSeverityLevel = SeverityLevel && s.cmbIssueCategory = Category &&
   s.dtReportedOn between StartDate and EndDate && s.cmbCurrentProgress = CurrentProgress && t.Team_name = Team;

   END
   $$

   What I m doing wrong here?

   Thanks again..
4. 

   bushraj, Member

   Plus when i Import it in excel 'View details' in not coming as a link..
5. 

   myDBR Team, Key Master

   Use format:

   declare v_base varchar(50);
   
   set v_base = 'http://www.abc.php';
   
   select 'dbr.url', v_base, '', '[Links]','id=1';
   
   select ID, concat(v_base, '?id=', id ) as 'Links'
   
   from mydata;

   --
   myDBR Team
6. 

   bushraj, Member

   Now it is generating a link but in column showing complete link,

   1. I want to show the link as 'View Details' string and then by clicking on it link opens. 2. Also in excel export it is showing the whole link without a hyper link like a text . I want to show it in blue color with underlined text like the format of hyper link for e.g. : [url=http://test.com][/url]

   my code is:

   declare v_base varchar(50);
   set v_base = 'http://tracker/notes.php';
   select 'dbr.url', v_base, 'Link', '[Links]','PME_sys_rec=1';

   select APP_NUMBER ,concat(v_base, '?PME_sys_rec=', APP_NUMBER ) as 'Links',
   s.txtCallID as 'Call ID',
   s.textCallSummary as 'Call Summary',
   s.cmbIssueCategory as 'Issue Category',
   s.cmbSeverityLevel as 'Severity Level',
   s.cmbProduct as 'Product',
   s.txtClientOrganization as 'Organization',
   s.LastModificationDateTime as 'Last Modification Date',
   s.cmbCurrentProgress as 'Status'

   from rpworkflow.supportmasterrecords s
   where s.dtReportedOn between StartDate and EndDate ;
   END
   $$

   Do suggest.

   Thanks.
7. 

   myDBR Team, Key Master

   Excel export does not contain all functionality of Excel. We can take a look if this can be added in future releases.

   --
   myDBR Team
8. 

   bushraj, Member

   And what about point 1?

   1.I want to show the link as 'View Details' string in report and then by clicking on it link opens.
9. 

   myDBR Team, Key Master

   Could you elaborate what do you mean by "show the link as 'View Details'"?

   --
   myDBR Team
10. 

    bushraj, Member

    like 'Click here to open' text not the whole URL is shown in column
11. 

    myDBR Team, Key Master

    If you want the report to show "Click here to open" instead the the link, you will put the "Click here to open"-text in the column. The dbr.url created link is the attached to the "Click here to open"-text. Please note that when doing that the the Excel export does contain the text, not the URL.

    --
    myDBR Team

Reply

You must log in to post.