Sage integrated reporting presently requires that criteria be entered by the user in the dialogue. 

It would be helpful if the tool were able to pick up criteria from [named] locations in the Excel file. 

Eg a set up sheet for a report may specify the end date for the report, the nominal codes to be used and the relevant departmental range. 

The end date may change. If Sage Integrated Reporting picked up its criteria from the setup sheet, then refreshment of the Sage report in Excel would be significantly easier. Presently to modify criteria the modify criteria dialogue requires all criteria to be re-entered. I have logged a separate item asking that this dialogue display the criteria currently used. This item is a different request. 

Such a feature would also allow us to easily adapt an Excel reporting tool for different departments. Not infrequently an Excel report, which may be used as a template for several departments, may be updated. Presently, the Sage report would have to be set up in each copy of the new Excel report. If the criteria for the Sage report were entered on the face of the Excel file, then only the Sage report in the template file need be set up for say department 0, and in each copy that criteria changed on the set up sheet in the reporting file.