Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

hiding column headings in classic report

TayyebMar 29 2024

I have a classic report retrieving only one row of data. I wanted to display data in such a way that columns must appear piled up upon each other. So, I use a template value attribute pairs - column. Everything works fine, but I want to hide a column header such as for LESSON column based on the value in column LESSON_INCLUDE; for example, if there is ā€˜N’ in column LESSON_INCLUDE, the column header for LESSON must disappear. Kindly suggest step by step process on how I can achieve this. Below is the code. Thanks )

select MODULE_ID,
       SESSION_ID,
       QUARTER_ID,
       WEEK_ID,
       STAFF_ID,
       GRADE_ID,
       GRADE_SECTION_ID,
       SUBJECT_ID,
       LESSON,
       QUIZ,
       ASSIGNMENT,
       RESOURCES,
       TEACHER_GUIDELINES,
       LESSON_INCLUDE,
       ASSIGNMENT_INCLUDE,
       QUIZ_INCLUDE,
       RESOURCES_INCLUDE,
       TEACHER_GUIDELINES_INCLUDE
  from MODULESS
 where SESSION_ID = :P174_SESSION_ID
  AND QUARTER_ID = :P174_QUARTER_ID
  AND WEEK_ID = :P174_WEEK_ID
  AND STAFF_ID = :P174_STAFF_ID
  AND SUBJECT_ID = :P174_SUBJECT_ID
  AND GRADE_ID = :P174_GRADE_ID_1
  AND GRADE_SECTION_ID = :P174_GRADE_SECTION_ID;
Comments
Post Details
Added on Mar 29 2024
2 comments
563 views