You can set up views such that users will be prompted to choose the format for displaying view results each time they run the view. This is done by setting the Presentation section's Prompt property to Yes.
When the users, run the view, they will be presented with a View Prompt window. They can change the selection in the Presentation section to run the view in Viewer (grid) format or as an MS Excel file.
Note: If there aren’t any other parameters defined for the view, then only the Presentation section will display in the View Prompt window.
If the Viewer option is selected, the view grid will display in the Stratum.Viewer interface. If the Excel option is selected, the View Definition page will display in the background while a File Download window or browser message opens. Users can open the file or save it to a specified location.