This discussion is archived
2 Replies Latest reply: Sep 9, 2012 12:05 PM by HamidHelal RSS

Group report help

only.ashish99 Newbie
Currently Being Moderated
i want to create report in Oracle D2k (Reports 6i). Please help.

i have 3 tables.
1 master table: school with school_id primary key
2 detail tables: dept & employee with school_id foreign key in both

Now I want report like this:

1 Delhi Public School
----------------------------------------------------------------------------------
school_id dept id dept name
1 10 chemistry
1 20 Physics

school_id Employee_id Employee_name
1 100 ABC
1 200 XYZ
-----------------------------------------------------------------------------------
2 Punjab Public Shool

school_id dept id dept name
2 10A Computers
2 20B History

school_id Employee_id Employee_name
2 A100 12ABC
2 C200 12XYZ
----------------------------------------------------------------------------------------

Please help. thanks in advance.
  • 1. Re: Group report help
    O.Developer Journeyer
    Currently Being Moderated
    want to create report in Oracle D2k (Reports 6i). Please help.

    i have 3 tables.
    1 master table: school with school_id primary key
    2 detail tables: dept & employee with school_id foreign key in both

    Now I want report like this:

    1 Delhi Public School

    school_id dept id dept name
    1 10 chemistry
    1 20 Physics

    school_id Employee_id Employee_name
    1 100 ABC
    1 200 XYZ
    2 Punjab Public Shool

    school_id dept id dept name
    2 10A Computers
    2 20B History

    school_id Employee_id Employee_name
    2 A100 12ABC
    2 C200 12XYZ

    Please help. thanks in advance.
    ---------------

    Try below
    Select report type as group above
    sql query is like this :
    select a.schoolid, a.schoolname, b.details
    where
    a.schoo.d = b.school id

    for group above use scholl id
    ----------------
    You will get what you mentioned
  • 2. Re: Group report help
    HamidHelal Guru
    Currently Being Moderated
    only.ashish99 wrote:
    i want to create report in Oracle D2k (Reports 6i). Please help.

    i have 3 tables.
    1 master table: school with school_id primary key
    2 detail tables: dept & employee with school_id foreign key in both
    SELECT COLUMN_NAME
    FROM SCHOOL,DEPT,EMPLOYEE
    WHERE SCHOOL.SCHOOL_ID=DEPT.SCHOOL_ID
    AND EMPLOYEE.SCHOOL_ID=SCHOOL.SCHOOL_ID;
    now make group in data block lay out and arrange in layout view with appropriate repeating frame.

    Hope this helps

    if helpful or correct, mark it.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points