the report generates statics for each ward and i want to divide specific ward 5c into two wards, the first 12 beds are for 5c - pediatric and the last 12 beds are for 5c-adults.

the report takes input from the user by selecting the wards so if the user chooses 5c, the report should show 2 wards.

the report declare cursor at the begining so how can i divide the ward.

SQL(DECLARE WARDL CURSOR FOR
 SELECT distinct
            %EXACT(Hospital_DR ),
            HOSPDesc,
           WARDRowID,
           WARDCode,
            case 
           
            WHEN WARDDesc='Ward 2D - Surgery' THEN '2D'