• 1-2 of 2
  • Nirmal Kumar L

    Hi Guys, 

    Thanks for your reply. I am done with this requirement. Below are the steps which I followed to achieve this. 

    1. First create 2 or more data sets in data model
    2. After creating Data model(DM) create report.
    3. While creating report, Drag all the columns from first data set and then click page break to separate the report(1st report in sheet 1)
    4. After clicking page break option, drag the columns from second data set. 
    5. Now the reports will come in sheet 1, sheet 2, sheet 3 etc



    Nirmal kumar

  • Nirmal Kumar L
    select distinct per.person_number ter_person_number,
          pos.actual_termination_date ter_actual_termination_date,
          s.manager_id ter_manager_id,
          mgr_num.person_number ter_manager_number,
     per.person_id ter_person_id,
     mgr_name.DISPLAY_NAME ter_manager_name,
     mgr_adid.attribute3 ter_mgr_adid
    from per_periods_of_service pos
    ,    per_assignment_supervisors_f s
    ,    per_all_people_f mgr_num
    ,    per_all_people_f per
    , PER_PERSON_NAMES_F mgr_name
    , per_persons mgr_adid
    where pos.actual_termination_date is not null
    and   pos.person_id = s.person_id
    and   pos.actual_termination_date between s.effective_start_date and s.effective_end_date
    and   s.manager_id = mgr_num.person_id
    and   s.manager_type = 'LINE_MANAGER'
    and   pos.actual_termination_date between mgr_num.effective_start_date and mgr_num.effective_end_date
    and   per.person_id = pos.person_id
    and   pos.actual_termination_date between per.effective_start_date and per.effective_end_date
    and   s.manager_id = mgr_name.person_id
    AND mgr_adid.person_id      = mgr_name.person_id(+)