I'm a newbie to ADF and im having issues while extracting pivot table data.
1. Create a VO with a bind variable.
2. Drag and drop execute with params to the page.
3. Drag and drop data control as pivot table to the page.
4. Add below code in the jsf source above the pivot table
<af:commandButton text="Export To Excel" immediate="true" id="cb1">
<dvt:exportPivotTableData type="excelHTML" exportedId="pt2"
filename="updated_export.xls" title="PivotTable export"/>
</af:commandButton>
5. Run the jsf page.
6. Click on export to excel button, excel gets generated but the screen hangs. user has to forcefully refresh the screen.
Any workarond present for this issue?
Jdev version:12.1.3