Resizing a column or row: Column handles and Fixed Column Width mode

Most reports are designed to have column widths and row heights sized automatically by the system. However, you can redesign the report to size columns and rows manually. This lets you drag a column edge left or right, or a row edge up or down, to resize the space. This gives you fine control over the look of your report.

Use the appropriate procedure below, depending on the degree of control you want when resizing rows and columns:

Use the column handles procedure if you want to simply drag column handles around to resize a column.
Use the pixel height and width procedure to enter a specific number of pixels for column width, to assign a different width to specific columns, and to enter a specific number of pixels to adjust row heights.

Steps are below to resize columns and rows in both MicroStrategy Developer and MicroStrategy Web.

To display column handles in Developer

The procedure below is slightly different depending on whether your report was designed to use Fixed Column Width mode or Auto Column Width mode. The differences are described below.

Run a grid report.
On the Grid menu, select View Column Handles.

The following message may appear: "Column width changes in Automatic Column Width mode will not be saved. Do you want to switch to Fixed Column Width mode?"

This message indicates that the report you executed is in Automatic Column Width mode. This means the system automatically sizes the columns for you. If you click No, the report stays in Automatic mode and any column sizing you do will not be saved. If you click Yes, the report's column width mode is changed to Fixed, and any column sizing you do will be saved when you save the report.
Column handles appear along the top of the columns of the report. In the following image, the report on the top has no column handles displayed. The report on the bottom shows column handles displayed.
Hover your cursor over a column handle until the cursor changes to a double arrow, as shown below:
Drag the handle left or right to make the column narrower or wider.

To determine pixel height of rows and width of columns in Developer

Open a grid report.
From the Grid menu, select Options.
On the Columns and Rows tab, select Fixed.
From the drop-down list, select the report features you want to specify width for:
- All Columns: Determines the width of all the columns on the report.
- All Row Axis: Determines the width for the column on the row axis (usually the attributes). Use this setting if there are no metrics (columns) on the report.
- All Grid: Determines the width of the data columns.
- Attribute form name: Determines the width for the specified attribute form. Each attribute form in the report is listed.
- Metrics: Determines the width of the column named "Metrics", which holds the column headers.
- Metric name: Determines the width for the specified metric. Each metric in the report is listed. All instances of this metric use this width, including those that are in page-by fields. (For details on page-by fields, see Grouping data by page.)
Enter the column width in Pixels.
Select one of the following row height settings:
- Auto Row Height: Allows row heights to be determined automatically by the system.
- Fixed Row Height: Allows you to specify the height of the rows. Enter the number of Pixels for the row height.
  
  Column widths must be fixed for row heights to be fixed. Column widths are applied first and then row heights.
Click OK.

To resize the columns and rows on a report in MicroStrategy Web

Open a report.
Do one of the following:
- Click and drag a column header's vertical lines to adjust the size of a column. The size of the column is adjusted accordingly.
- From the Format menu, select Resize Columns and Rows. The Resize Columns and Rows dialog box is displayed.
  - If DHTML is disabled, click Go. The Resize Columns and Rows panel is displayed.
Resize the columns and rows using the following options:
- To automatically set the size of the columns and rows:
  - Auto Fit to Window: The grid report's columns stretch to fit the size of the browser window.
  - Auto Fit to Contents: The width of the report's columns or rows is determined by the data in the column or row. All extra space in the grid is removed.
- To manually size the height of the rows or width of the columns, select Fixed in the Columns area or Fixed Height in the Rows area. Type a size for the columns or rows. The grid report is adjusted to the column width and row height you specify.
  
  Changing the height of the rows manually does not affect the header rows at the top of the report.
Click OK.