glebovpavel / IR_to_MSExcel

Oracle Apex plugin for Interactive Grid or Interactive Report
http://glebovpavel.github.io/Description_IR_TO_XSLX/
Other
39 stars 14 forks source link

IR => Actions => Applying 'Group By' to report doesn't export grouped data to Excel #63

Open raghu607 opened 5 years ago

raghu607 commented 5 years ago

Hi Pavel,

Hope you are doing great.

This is Raghunath & I have been using your apex plugin 'Download to Excel' for IRs/IGs reports and this is really a wonderful plugin that you have created. One thing i noticed with the plugin is when i apply 'group by' clause on a column using IRs reports => Action => Group By and save my own format of IR report and then try to download to Excel; the group by clause is not working in the excel.

When I download the 'group by clause' applied report, the plugin instead of downloading the 'group by' clause report its downloading the primary report. I was wandering why this was happening, can you share some insight on this.

LifeBasher commented 4 years ago

You have to change the l_report.ir_data.report_columns in the IR_TO_XLSX to get the right columns and then adjust the layout of what is displayed. Btw Pavel really great job for this plugin