2 Replies Latest reply: Sep 9, 2012 2:05 PM by HamidHelal RSS

    Group report help

    only.ashish99
      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
          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
            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.