8 Replies Latest reply: Jul 12, 2013 10:51 AM by ReemaPuri RSS

    Is there any limitation for selection list to display number of rows in report in apex ?

    ReemaPuri

      In my report i am calling run on demand process its not displaying 34 rows in data but displaying only 3 rows that too with hardcode rownum<=20

       

      the query run perfect in backend

       

      FOR rec IN ( select distinct class_name , id r

        from table_name

           where country_id =(select distinct domicile_country_id from (

        select domicile_country_id from table_name where id = l_ser and domicile__id is not null

          union

        select domicile_country_id from table_name where id = l_ser and domicile__id is not null))  and rownum<=20 order by 1

      )

       

       

      please help