1. 

   gschmidt, Member

   I keep getting a Multiselect query should be a procedure with one string parameter. Is there a good example where I can see the source code of using a multi select parameter on a report?
2. 

   myDBR Team, Key Master

   Hi,
   see the demo for Multiselect

   The parameter query takes the user input as parameter and shows the matching choises. When the selection is done, a comma separated list of ID's is passed into the report. The third colum ("Continent" in the example) is optional and when present, is used as option grouping.

   CREATE PROCEDURE sp_ADBR_countriesms(in_search text)
   
   BEGIN
   
   select Code, Name, Continent
   
   from demo_country
   
   where name like concat('%', in_search, '%');
   
   END

   --
   myDBR Team
3. 

   gschmidt, Member

   Thank You! Worked Perfectly

Reply

You must log in to post.