DevOps, CI/CD and Automation

Hi,

I'm new to reports and there are certain issues I'm not able to resolve:

1) a) When i run the report which has a repeating frame and all items are within it, I get the following error 'REP-212 Repeating Frame Object is not enclosed by its enclosing object'.

b) I do not have a main(parent) frame for the repeating frame, when i tried to insert one, just thought that would solve the above issue, the main frame is overlapping above the repeating frame and its contents in the layout .How do i add a main frame and make it the parent frame for the repeating frame?

c) Can a repeating frame span across pages?


2) In one of my queries I would like to use a lexical parameter as follows:

SELECT
ea.employee_names
,ea.current_level
,ea.consultant_role
,ea.groups
,ea.start_date
,get_name_id(go.employee_id) mgr_name
,ea.employee_id
FROM
employee_assignment1 ea
,group_owners go
WHERE go.groups=ea.groups
AND go.enable = 'Y'
AND ea.employee_id IN (&p_emp_id)

However, when I create this query i get an "ORA-00936 : missing expression AND ea.employee_id IN (==>) " error. This does not happen if i put ea.employee_id = :p_emp_id

Please help me resolve these issues. Thanks in advance.

Regards,
Priyanka

Message was edited by:
user552828