How to remove header from Reports in Spotfire Statistica?
Article ID: KB0138000
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 14.3 |
Description
In a few scenarios, the header property settings for the generated spreadsheet from analysis in reports do not require a header. We have listed ways available in Statistica to remove it.
Environment
Windows Server
Resolution
Resolution 1: Manually
1. Open the generated report spreadsheet.
2. Navigate to the View menu -->Display Options--> Headers
3. Click on Headers. This will remove the header marked in the red box. Follow to save the report.
Resolution 2: By using a Macro
We have a way to automate the header removal in generated report spreadsheets, which will involve creating a Macro first and adding that script to other Nodes.
1. Create a new MACRO and add this code:
Dim S1 As Spreadsheet
Set S1 = ActiveDataSet S1.Header.Value =""
2. Save the MACRO locally
3. For the node where you want the header to be removed, right-click and select Customized Output:
4. Add the script to the Spreadsheet/Graph node (as per requirement)
5. Add that script by drag-and-drop from the bottom pane to the upper under the node name.
6. Execute the workspace node.
Then, when a report is created with this workspace, the headers will be removed.
Issue/Introduction
This article outlines the steps to remove the header in Statistica reports generated through workspace nodes.
