1. 

   ahouston, Member

   Trying to add a link in my report to be able to click and go directly to the record, which can be found at myurl/id so I need to be able to pass the id number into the link. Is this possible?

   select
   act.name as 'Name',
   act.id as Id,
   'dbr.purehtml : < a href="http://myurl/ NEED Id # HERE"> click here' as link
2. 

   myDBR Team, Key Master

   Sure,
   just use SQL's CONCAT-function:

   select
   
       act.name as 'Name',
   
       act.id as Id,
   
       concat('dbr.purehtml : < a href="http://myurl/', act.id,'"> click here'' as link')
   
   from yourtable;
   
   

   --
   myDBR Team

Reply

You must log in to post.