Forums

I'm having some troubles developing an Enterprise Portal [AX2012] page that shows grouped data with total value sums and including an 'Export to Microsoft Excel' button.

The only way to get the 'Export to Microsoft Excel' button, that I know of, is to create a ListPage with a command button in the action pane. However, when I create my ListPage and add a query that uses a Group By, the ListPage on the portal shows a grid where only the first line is selected and the selection can not be changed. I tried to use a view, but this gave me the error message that the datasource is not pageable. I have a hunch that a ListPage with a Group By is never going to work because it lacks a datakey.

So does anyone know if it's possible to use ListPage with grouped data and have it show up normally in the Enterprise Portal?

Or does anyone know a way to add the 'Export to Microsoft Excel' button to a webpage without using a ListPage?