1. 

   dsearle, Member

   I have implemented the autocomplete list using the code below and when using the feature in my report I get 'undefined' appended to each entry. Does anybody know why?

   The code I have is:

   select DISTINCT website
   from server.data
   where website like concat( '%', inTitle, '%');

   inTitle is a parameter for the Stored Procedure.
2. 

   myDBR Team, Key Master

   The format of popup is:

   select code, user_visible_value

   First parameter is the one that is passed as report parameter and the second is the one shown to user in popup.

   If you do not need separate code use:

   select DISTINCT website, website
   
   from server.data
   
   where website like concat( '%', inTitle, '%');

   --
   myDBR Team

Reply

You must log in to post.