3 Replies Latest reply: Sep 26, 2013 1:44 PM by PhilBolte RSS

    suppressing values in table

    875076

      Hi All ,

       

      I want to suppress the repeating values in the row in rtf. What is the best way to suppress the repeating value in the the table.Grouping does not seem to work.

       

      Thanks,

       

      Sushil

       

      Region

      State

      Order_ID

      Sub_order_ID

      Type

      01

      MA

      125

      AD

      10

      01

      MA

      125

      AD

      11

      01

      MA

      125

      DE

      09

       

       

      Suppress the value to show as below. Desired output

      Region

      State

      Order_ID

      Sub_order_ID

      Type

      01

      MA

      125

      AD

      AD

      DE

      10

      11

      09

        • 1. Re: suppressing values in table
          PhilBolte

          Yes, grouping is the solution to your question.  I will illustrate an example tomorrow.

          • 2. Re: suppressing values in table
            PhilBolte

            Today I added grouping to my rtf for the sample orders data model, so I know the following method works:

            It is likely that your data file does not contain the grouping hierarchies already, so you perform the grouping in rtf using the following method:

            4.12.3  Regrouping the XML data.

            http://docs.oracle.com/cd/E23943_01/bi.1111/e22254/create_rtf_tmpl.htm#autoId96

            Tomorrow I will post my rtf code, after I clean out the clutter.

            If you wish, feel free to send me your data file, to ensure my solution is relevant to you.

            • 3. Re: suppressing values in table
              PhilBolte

              Sushil,

               

              I took 3 screenshots of my xml structure, rtf code, and report output, but these forums do not allow images.

              So, here is the info:

              (1)  My xml structure (data source) has no hierarchies (no groups).

              (2)  My rtf code groups first by customer, then by order, then displays all line items for each order.

              (3)  The report output suppresses repeating values of the two groups (customer, order).

              (4)  The rtf code is below:

              CUSTOMER_NAME

              ORDER_ID

              LINE_ID

              PRODUCT_DESCRIPTION

              <?for-each-group:ROW;CUSTOMER_NAME?>

               

              <?CUSTOMER_NAME?>

               

               

               

              <?for-each-group:current-group();ORDER_ID?>

              <?ORDER_ID?>

               

               

              <?for-each:current-group()?>

               

              <?LINE_ITEM_ID?>

              <?PRODUCT_DESCRIPTION?>

              <?end for-each?>

              <?end for-each-group?>

              <?end for-each-group?>