Share this page

# Worksheet Configuration Pane - Advanced Tab

The worksheet configuration pane enables you to configure the Business Views Microsoft Excel Report, and to select the projects to include in the report.

To access | In the ALM tab in Excel, click Add or New Report. Select the business view and click OK. Select the Advanced tab.
Important information | To hide the Worksheet Configuration pane, click the Show Configuration button. Clicking the button again reopens the Worksheet Configuration pane. If you click in the Excel worksheet outside the actual report, the Worksheet Configuration pane closes. Click in the report to reopen the pane.
Relevant tasks | How to Generate a Business View Excel Report
See also | ALM Tab - Microsoft Excel

The Advanced tab of the worksheet configuration pane enables you to configure the report by directly editing the DQL query, and to select the projects to include in the report. User interface elements are described below:

UI Element | Description
--- | ---
Dataset Query | The DQL query used to create the report.
Edit Query | Click to edit the DQL query. The Edit Query dialog box opens. For details, see Edit Query Dialog Box. Note: You can only edit the DQL query if you belong to a user group that has the required permission: Customize DQL Query.
Use current project only | Select if only the current project is to be included in the Business Views Microsoft Excel Report.
Include domain and project name | Select to show the domain and project name in the Business Views Microsoft Excel Report.
Domain | The domains included in the Business Views Microsoft Excel Report.
Project | The projects included in the Business Views Microsoft Excel Report.
Select Projects | Click to select projects to include in the Business Views Microsoft Excel Report. The Select Projects dialog box opens. For details, see Select Projects Dialog Box. Note: You can only select projects if you belong to a user group that the required permission: Allow Cross Project Excel Reports.

https://admhelp.microfocus.com ALM 8942
Tips to improve your search results... ALM Help Center ALM Help Center ALM Help 15.5-15.5.1 All View Local Help Center View Online Help Center back Go back in browser history forward Go forward in browser history Remove search highlights next topic Go to next topic previous topic Go to previous topic Print the current topic Version: