Error: Export Pivot Table Data is not valid child of a Button element.

(Doc ID 970242.1)

Last updated on APRIL 05, 2018

Applies to:

Oracle JDeveloper - Version 11.1.1.2.0 to 11.1.1.3.0 [Release Oracle11g]
Information in this document applies to any platform.

Goal

NOTE:

Similar issue for af:button in 12.1.3.0.0 is discussed in Note 2356125.1.

 

The Design Editor of JDeveloper gives the following error when trying to drag-n-drop exportPivotTableData component into commandButton:

Export Pivot Table Data is not valid child of a Button ... element.


However, in Source editor you can still create the following:

...
<af:panelGroupLayout xmlns:af="http://xmlns.oracle.com/adf/faces/rich" id="pgl1">
  <af:commandButton text="Prenos v EXCEL (celotna tabela)" id="b111"
      inlineStyle="background-color:Aqua; font-size:larger;">
    <dvt:exportPivotTableData type="excelHTML"
                              exportedId="pivotTable1"
                              filename="matrix.xls"
                              title="Matrièni prenos"
                              exportedData="all"/>
  </af:commandButton>
  <af:spacer width="10" height="10" id="s1" inlineStyle="width:20.0px; height:20px;"/>
  <af:commandButton text="Prenos v EXCEL (izbrani podatki)" id="cb2"
                    inlineStyle="background-color:Aqua; font-size:larger;">
    <dvt:exportPivotTableData type="excelHTML"
                              exportedId="pivotTable1"
                              filename="polja.xls"
                              title="Matrièni prenos (izbrani podatki)"
                              exportedData="selected"/>
   </af:commandButton>
</af:panelGroupLayout>
...


But you still JDeveloper warns that exportPivotTableData is not a proper child of af:commandButton.

Why do you get this error ?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms