How to insert an empty row underneath each element row in MicroStrategy Developer 9.x
Users may want to add an empty row beneath each element of a report, as shown in the screen shot below:
To achieve this, perform the following steps:
Create a metric and name it "test". This metric basically serves only as a placeholder, therefore, any metric can be used. In this example, Max(1) is used to define "test" metric, as shown below:
Hide the metric value from displaying on the report.
To hide the metric, go in metric editor > Tools > Formatting > Values. Select the 'Number' tab > Custom category and enter a double parenthesis (""), as shown below:
Place the "test" metric on a report template.
Hide the metric header so that it does not display on the report.
To hide the metric header, the user can give the metric an alias by entering a blank space in Report Data Option > Display > Alias, as shown in the following screen shot:
Re-execute the report. The user should now be able see an empty row added beneath each attribute element.
