I am trying to create a process that generates an excel report using the Report Editor, such that each page of the report is exported as a sheet in the same excel file.
For example, my report has 2 pages, which need to be exported as sheet1 and sheet2 in the same excel file. But I do not find any such option in the properties window of the Report Editor.(I do find this option in the preview mode, but it is only useful for saving the file manually, and not progranmatically)