2 Replies Latest reply: May 3, 2013 12:19 AM by pm RSS

    Repeating groups in BI publisher report

    pm
      I wanted to create report in BI Publisher like below

      Dept No Dept Name
      10 Dept1
      Emp No Emp Name Salary
      100 Emp1 1000
      101 Emp2 2000
      -------------------------------------------------
      Sub Total : 3000
      Dept No Dept Name
      20 Dept2
      Emp No Emp Name Salary
      102 Emp3 1100
      104 Emp4 2210
      -------------------------------------------------
      Sub Total : 3310
      =============================
      Grand Total : 6310

      Please share pointer on this.
        • 1. Re: Repeating groups in BI publisher report
          JorgeAnicama
          That is very easy. Do this:

          1. Define two for-loops
          a) the first will loop through the different departments
          b) the second will loop through the diff employees in each department
          2. At the end of the second loop define a calculation in the template to give you
          the totals for emp salaries.

          An example of this is here:
          http://docs.oracle.com/cd/E23943_01/bi.1111/e22254/create_rtf_tmpl.htm#do_assoc
          (item 4.3.1.3 Completing the Example)

          This picture:
          http://docs.oracle.com/cd/E23943_01/bi.1111/e22254/img/rtftemp_basic.gif
          In your case VENDOR_NAME becomes your department and
          INVOICE_NUM becomes employee number.

          regards
          Jorge Anicama
          p.s If this answers your question then please mark my answer as "Correct" or "Helpful"
          • 2. Re: Repeating groups in BI publisher report
            pm
            Thanks for pointers.