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;