MicroStrategy ONE

Properties and Formatting Dialog Box: Layout

If you arrived here from Workstation, see the Workstation Document Authoring Help.

You can use the Layout options in the Properties and Formatting dialog box to format the layout of controls in your document. For example, you can specify the width and height of a control, or how to display content that overflows the boundaries of a document. Some options are only available for certain types of controls.

You can change the following options:

  • Position: Determine the positioning of the control in the document. These options are not available for document sections.
    • Left: Determine the distance between the left edge of the control and the left border of the section.
    • Top: Determine the distance between the top edge of the control and the top of the section.
    • Locked: Determine whether the control is locked in its current position in the document. If this option is selected, the control cannot be moved or resized. This checkbox is cleared by default.
    • Show only in repeated sections: Determine whether the control is displayed on the last page. For a control in a section that is repeated on every page, you can specify whether the control is displayed on all pages or on all pages except the last page. This allows you to display text such as "Continued on next page" on every page except the last page. Available for controls in any header or footer sections, except for the Page Header and Page Footer.
  • Size: Determine the width, height, and other size options for the control.
    • Width: Determine the width of the control by selecting one of the following options. This option is not available for document sections or lines.
      • Fixed at: Specify the width of the control when it is displayed in the document.
      • Fit to contents: Automatically size the control to fit its contents. Available for text fields, Grid/Graphs, and widgets.
      • 100%: Automatically set to the width of the section. Available for rectangles.
    • Height: Determine the height of the control by selecting one of the following options, which are not available for document sections. For document sections, type the height in the Height field. This option is not available for lines.
      • Fixed at: Specify the height of the control when it is displayed in the document.
      • Fit to contents: Automatically size the control to fit its contents. Available for text fields, Grid/Graphs, and widgets.
      • 100%: Automatically set to the height of the section. Available for rectangles.
    • Height Can Shrink: Determines whether the section height can shrink to fit its contents. Affects all display modes and PDF export. Clear this checkbox to decrease the time it takes to execute the document. Available for document sections.
    • Height Can Grow: Determines whether the section height can expand to fit its contents. Affects all display modes and PDF export. Clear this checkbox to decrease the time it takes to execute the document. Available for document sections.
    • Max Height: The maximum height for the section. Zero (0) indicates there is no height limit. Available for document sections.
    • Hide if Empty: Determine whether the section displays if it has no content, regardless of how the Height Can Shrink property is set. By default, it is set to True.
    • Length: Determine the length of a line by selecting one of the following options. Available for lines.
      • Fixed at: Specify the length of the line when it is displayed in the document.
      • 100%: Automatically expands the line across the section. If the line is vertical, the line height is set to the height of the section.
    • Content Overflow: Determine how to display the content in a panel stack when the content is larger than the dimensions of the panel stack. This option is available for panel stacks, including filter panels.
      • Clip: Display only the contents that can fit within the size of the panel stack.
      • Scroll (default): Display a scroll bar to allow the user to view all of the contents. The scroll bar is displayed for Presentation Mode in Web.
    • Text overflow (HTML): Determine how to display the text when it is larger than the dimensions of the text field. This option is available for text fields. The options are:
      • Clip (default): Display only the text that can fit within the size of the text field.
      • Scroll: Display a scroll bar to allow a user to view all of the text. The scroll bar is displayed for Presentation Mode in MicroStrategy Web, and when the document is exported to HTML. The text field is clipped in other display modes or export formats. The scroll bar is most useful when the height of a text field is set to a fixed value.
    • Lock Aspect Ratio: Determine whether the image retains its original width-to-height ratio. Available for images.
  • Title Height: Determine the height of the control's title bar. Enter a number of inches in the Fixed at __ Inches field. Available for panel stacks, Grid/Graphs, widgets, and selectors.
  • Grid: The options in the Grid category are available for Grid/Graphs.
    • Data source: Determine the dataset to use to populate the selected Grid/Graph. If you select None, the Grid/Graph displays all the elements from all the datasets used on the Grid/Graph. A Grid/Graph that uses multiple datasets cannot determine which metric to use, so no metric values are displayed.
    • Shortcut: Determine whether to link the Grid/Graph to the dataset report as a shortcut. If this checkbox is selected, any changes made to the original report are automatically passed to the Grid/Graph in the document. This checkbox is cleared by default.
    • View: Determine the mode in which the Grid/Graph is displayed once the document is executed. You can select either Grid View, Graph View, or Grid and Graph View.
    • Grid Overflow (HTML) (available for Grid View, and Grid and Graph View): Determine how to display the selected grid in Editable Mode and Presentation Mode if the Grid/Graph overflows beyond the boundaries of the document. The options are:
      • Clip: Crops the grid to fit the document's size.
      • Scroll (default): Displays a scroll bar that enables the user to see the entire grid even if the grid is larger than the document.
    • Grid Overflow (PDF & Excel) (available for Grid View, and Grid and Graph View): Determine how to display the selected grid if it overflows beyond the boundaries of the document, when the document is printed or exported to PDF or Excel. The options are:
      • Clip (default): Crops the grid to fit the document's size.
      • Fit to grid contents: Automatically resizes the grid so that all data is visible.
    • Graph Overflow (PDF): Determine the behavior of the selected graph if it overflows beyond the boundaries of the document, when the documented is printed or exported to PDF or Excel. The options are:
      • None (default): Crops the graph to fit the document's size.
      • Vertical: Displays overflowed content, including other grids or graphs, below the selected graph.
      • Horizontal: Displays overflowed content, including other grids or graphs, to the right of the selected graph.
    • Spacing (available for Graph View): Determine the space inserted between the graph and overflowed content. This option is only available if the Graph Overflow option is set to Vertical or Horizontal. The default value is .5 inches.
    • Quick Switch (available for Grid View and Graph View): Determines whether a user can switch between viewing the data in a Grid/Graph as a grid or a graph by clicking a button in Editable Mode or Presentation Mode. This checkbox is cleared by default.
    • Grid Position (available for Grid and Graph View): Determine where the grid report is displayed in relation to the graph report for Grid/Graphs displayed in Grid and Graph View. The options are:
      • Top: Displays the grid above the graph.
      • Bottom (default): Displays the grid below the graph.
      • Left: Displays the grid to the left of the graph.
      • Right: Displays the grid to the right of the graph.
    • Grid Area (available for Grid and Graph View): Determine the percentage of the Grid/Graph covered by the grid report; the remaining area is used by the graph report. The default value is 50%.
  • Selector: The options in the Selector category are available for selectors.
    • DHTML Style: Determine which style to use to display the selector in Editable and Presentation Mode. The options are:
      • Drop-down
      • Slider
      • Listbox
      • Button Bar
      • Radio Button
      • Link Bar
      • Check Boxes
      • Search Box
    • Flash Style: Determine the style in which the selector is displayed in Flash Mode. The options are:
      • Automatic: Displays the selector using the same style specified in the DHTML Style option above.
      • Date Selection: Displays the selector as a Date Selection widget.

      • Fish Eye: Displays the selector as a Fish Eye widget.

        Flash Mode is available only if your document was created before MicroStrategy 10.1 and was defined to display in Flash Mode. Beginning with 10.1, Presentation Mode replaces Flash Mode.

    • Orientation: Determine whether the items in the selector are displayed in a horizontal or vertical layout.
    • Allow multiple selections: Determine whether users can select multiple items in the selector. This allows users to display data for several items in the selector at once, and specify which items are displayed in the target of the selector. (Not available for attribute selectors)

    • Change Selection on Mouse Over (Flash Only): Determine whether users can select an item by hovering the cursor over the item in the selector to select it.

      The Change Selection option is available only if your document was created before MicroStrategy 10.1. Beginning with 10.1, Presentation Mode replaces Flash Mode, and this option is not applicable.

    • Make all items the same width: Determine whether all items in the selector are displayed using equal widths.
    • Export selector to PDF as shown on screen: (Available when DHTML Style is Button Bar, Check Boxes, Link Bar, or Radio Button) Determine whether the selector is exported to a PDF file as shown on the screen or whether it is exported with only the selected items displayed.
    • Search on server: (Available when DHTML Style is Search Box) Determine whether the search is performed on the server or the client. When the checkbox is selected, elements are fetched directly from the data warehouse or Intelligent Cube as the user performs the search.

  • Excel: The Excel property is available for sections.

    Automatically Fit Rows: Determine whether Excel automatically resizes the row heights when the document is exported.

    By default, the height of all rows is the same in a document exported to Excel. This conserves the same layout that you created in the document. However, a Grid/Graph can contain data that is too long to fit inside an Excel cell and is therefore cut off. You can allow Excel to dynamically and automatically resize the row heights in a specific document section so that the rows are tall enough to display the full text. For more details, see How to Allow Excel to Automatically Change Row Height. For instructions on exporting documents to Excel, see Export a Document.

  • PDF: The options in the PDF category are available for document, group, and detail headers and footers. The options apply in Presentation Mode and when the document is exported to a PDF.
    • Keep together: Specify whether a page break is allowed within the section. By default, the checkbox is cleared, meaning that as much of the section as possible is printed on the current page, with the remainder on the following pages. If the property is selected and the entire section does not fit on the page, the section starts on the top of the next page and continues on subsequent pages.
    • Repeat on each page: Specify whether the contents of the selected section are repeated on each page of the PDF. Available for header and footer sections, except for the Page Header and Page Footer. To create repeated sections with controls that do not display on the last page, you can use this property with the Show only in repeated sections property (defined for controls, not document sections).
    • Repeat horizontally: Specify whether the entire contents of the selected section are repeated on the next horizontal page when the section spans multiple pages. Available for document, group, and detail headers.
    • Force new page: Specifies whether a page break is inserted. The options are:
      • None: No page break is inserted
      • Before section: The current section is always printed at the top of a new page
      • After section: The section immediately following the current section is printed at the top of a new page
      • Before and after section: The current section is printed at the top of a new page and the next section is printed at the top of a new page

Related Topics

Properties and Formatting Dialog Box

Document Creation Help