The following procedure describes how to create a Multi-Layout Report Services Document in Strategy Web 9.x to utilize multiple worksheets and how to create an Excel Subscription with Strategy Distribution Services 9.x to deliver this file.
Worksheets in Excel can be a highly desired feature for organizational purposes. More advanced Report Services Documents can be created to further utilize this feature as well. However, In this instance only two datasets will be utilized, in order to create a separate worksheet for each dataset.
The following steps outline how to accomplish this:
1. Create a new Document in Strategy Web 9.x and edit it within Design Mode
2. Add the desired amount of datasets to the document.
3. Add the desired amount of layouts to the document. This can be achieved by going to the 'Insert' menu and selecting 'Layout'. The layouts can be renamed by right clicking them. The Layout name will be the respective Excel Worksheet name.
Note: The number of layouts will determine the number of Worksheets in the Excel file.
4. Add at least one dataset to each of the layouts available on the document.
5. Save the document, and subscribe the document to be delivered. In this example, a File Subscription is used. The 'Expand Layouts' feature must be selected for all layouts to be included as Excel Worksheets
6. Click 'OK'. The resulting Excel file will contain multiple worksheets with the Datasets in their respective positions.
