Actually, #2, exporting to Excel, works if I turn off Dev Mode. It fails in Dev Mode because it throws a Assertion Error:

500: Unexpected server error
Can't set maxRows when not paginated

Home Back Folder

java.lang.AssertionError: Can't set maxRows when not paginated
       at org.labkey.api.query.QuerySettings.setMaxRows(QuerySettings.java:487)
       at org.labkey.api.query.QueryView.getExcelWriter(QueryView.java:1551)
       at org.labkey.api.query.QueryView.exportToExcel(QueryView.java:1610)
       at org.labkey.api.query.QueryView.exportToExcel(QueryView.java:1595)
       at org.labkey.query.controllers.QueryController$ExportSqlAction.export(QueryController.java:2509)
       at org.labkey.query.controllers.QueryController$ExportSqlAction.export(QueryController.java:2460)
       at org.labkey.api.action.ExportAction.getView(ExportAction.java:41)
       at org.labkey.api.action.SimpleViewAction.handleRequest(SimpleViewAction.java:61)
       ...