APEX 4.1
I have a dynamic query report which uses Function Returning SQL query to generate report.
My report should look something like this
| USER | P1 | P2 | Total |
|---|
| user 1 | 5 | 5 | 10 |
| user 2 | 10 | 10 | 20 |
| user 3 | 2 | 1 | 3 |
| report total: | 17 | 16 | 33 |
i have checked in SUM option under Report Attributes for each column P1,P2,Total to get last total row.
But the issue is text "report total " does not appear while using dynamic SQL ,but for normal SQL query this text is available.
so what i did is on page load wrote a jquery code to add text report total to last row first child of the report.
But on report download "report total" will not be available in excel.
Can we retain any css change done on report using jquery after report download?
Is there any way out?